COUNTIF function

[Lauren]

I am using Excel 2002 and I was wondering if I can use the
COUNTIF function to count the number of times a certain
value appears over a number of worksheets in the same
workbook. I know it works in a range on the same
worksheet. Example if I have 5 worksheets and I want to
see how many times the letter "a" shows up within a
specific cell over those 5 worksheets, can I do it? If not
COUNTIF, is there another way? If anyone has an idea of
how to do this, I'd greatly appreciate it.

Thanks!
Lauren

 

[Thomas]

Just use the sheetnames and add them together
=COUNTIF(B:IV,"=a")+COUNTIF(Sheet2!1:65536,"=a")
and so on.