Reference Formula

[rnordquest]

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.

 

[Guidoo]

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?

 

[rnordquest]

My problem is neither one worked. I was hoping my errors would be close enough to describe what I was looking for.

 

[rnordquest]

It didn't work the first time but #1 works now. I was getting an error for both. Don't know what was wrong.