Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reference Formula

Status
Not open for further replies.

rnordquest

New member
Joined
Jul 17, 2003
Messages
148
Location
US
How do I calculate something on one sheet from data on another? I want to do something like this:

In a cell on Sheet1:

=Countif(Sheet2!A3:A500,"Y")

or

=Sheet2!Countif(A3:A500,"Y")

What is the proper syntax? I want to avoid the intermediate step of making the calculation on Sheet2 and then have =Sheet2!A1 for my equation.
 
The first one is correct, so
=Countif(Sheet2!A3:A500,"Y")

Wouldn't it be much easier to just try both options to see which one worked, instead of posting it in this forum?
 
My problem is neither one worked. I was hoping my errors would be close enough to describe what I was looking for.
 
It didn't work the first time but #1 works now. I was getting an error for both. Don't know what was wrong.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top