On Sun, 21 Feb 2010 05:59:02 -0800, pdberger
wrote:

Good morning --

I'm shooting for a COUNTIF formula that will count text occurances across
multiple worksheets. I can get the formula to work if the data is on the
same worksheet but as soon as I go to multiple ones, it fails and I get a
'#VALUE!' error.

Here's the formula:

=COUNTIF(First:Last!A1,"Y")

Thanks in advance.

COUNTIF does not work with 3D references.

You may be able to use something like:

=SUMPRODUCT(COUNTIF(INDIRECT("'"&A4:A7&"'!A1"),"Y" ))

where A1:A4 contains the names of your worksheets.
--ron