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.
Have a look he
https://www.microsoft.com/communitie...r=US&sloc=&p=1
Hope this helps / Lars-Åke