counting across sheets

[drk52]

I have a workbook with 35 wrkshts. I am making a summary and need a formula that will return the number of times a specific cell across all sheets was above 0

I am new to this and hope someone can help me,
Thanks

 

[Aladin Akyurek]

On 2002-10-25 11:09, drk52 wrote:
I have a workbook with 35 wrkshts. I am making a summary and need a formula that will return the number of times a specific cell across all sheets was above 0

I am new to this and hope someone can help me,
Thanks

If you're allowed to use a third-party add-in, download & install the morefunc.xll from:

http://longre.free.fr/english/index.html,

you could use:

=COUNTIF.3D(Sheet1:Sheet35!B2)