Searching for data criteria from a range over multiple sheets

[cmac7872]

Hello All,

This should be a pretty simple formula but it is eating my lunch.

I am trying to sum occurrences of "sw" in range E10:E122 over 31 sheets. I have tried numerous combinations but keep getting errors. I am positive it is a syntax error on my part, just can't figure it out. Thanks.

[cmac7872]

I tried this one:

=COUNT(IF(Sheet1:Sheet31!E10:E122="sw",0))

It tells me that it refers to empty cell, when in fact they are not empty.

[cmac7872]

For any one that reads:

I learned you can not Countif and/or Count across multiple sheets without an extensive macro or creating a 3D reference. I simply added the cells criteria in a seperate box on each sheet and used Sum accordingly.