COUNTIF on several worksheets???

  • Thread starter Thread starter Mally
  • Start date Start date
M

Mally

Is it possible to use the COUNTIF function to count
letters on several worksheets.

I want it to count the letter "B" in cells F7:BO7 on 12
worksheets.

Once i have this formula i'll copy it down the sheet.

Tried using the OR function but no luck.

Thanks

Mally
 
You could use
=sum(countif(),countif(),countif()...,countif())
with each countif pointing at one of the 12 sheets

Or if your 12 sheets are contiguous, you could use a UserDefined function that
Myrna Larson and David Hager wrote. It's on John Walkenbach's site:

http://j-walk.com/ss/excel/eee/eee003.txt
 
IMHO the easiest way would be to use the countif formula in the same cell
(a7) of each ws. Then, on the master sheet just use =sum(sheet1:sheet12!a7)
 
Is it possible to use the COUNTIF function to count
letters on several worksheets.

I want it to count the letter "B" in cells F7:BO7 on 12
worksheets.

Once i have this formula i'll copy it down the sheet.
Click to expand...
...

If you have a list of worksheet names either in a range or an array, you could
use a formula like

=SUMPRODUCT(COUNTIF(INDIRECT("'"&LstWrkshtNms&"'!"&CELL("Address",F7)&":"&
CELL("Address",BO7)),"B"))
 
Back
Top