COUNTIF function

  • Thread starter Thread starter Lauren
  • Start date Start date
L

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
 
Just use the sheetnames and add them together
=COUNTIF(B:IV,"=a")+COUNTIF(Sheet2!1:65536,"=a")
and so on.
 
Back
Top