COUNTIF over several worksheets

[Roy K]

Hi,
Getting #value eror when using countif trough several
worksheets (in the same workbook).
Does anyone now if this should work.

Example:
=COUNTIF(Sheet2:Sheet4!A1;">0")
(does not work)

Works OK
=COUNT(Sheet2:Sheet4!A1)

and COUNTIF on the same sheet is OK:
=COUNTIF(B5:B7;">0")

Thanks

 

[Frank Kabel]

Hi
one way: Download the free addin morefunc.dll
(http://longre.free.fr/english). It incluides the function
COUNTIF.3D

 

[Guest]

Hi, thanks for suggestion.
Tried it but it didn't contain the countif.3d function
(only 4 functions)

Do you know any other addin, containing a countif (3d)
function ?

 

[Frank Kabel]

Hi
check this again
This addin contains such a function