Hi all,
Im trying to to do a Countif over a number of sheets but for some reason my formula returns #value. Im trying to count the number of "Y"'s in cell B2 over each sheet.
Ive highlighted cell B2 and selected my 7 sheets from August 06 - Jan 07..and typed this is my formula
=COUNTIF('August 06:Jan 07'!B2, "y")
Am i doing something wrong?
Thanks
Im trying to to do a Countif over a number of sheets but for some reason my formula returns #value. Im trying to count the number of "Y"'s in cell B2 over each sheet.
Ive highlighted cell B2 and selected my 7 sheets from August 06 - Jan 07..and typed this is my formula
=COUNTIF('August 06:Jan 07'!B2, "y")
Am i doing something wrong?
Thanks