COUNTIF over several worksheets

[RoyK]

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

 

[Jason Morin]

Unfortunately, COUNTIF doesn't handle 3D ranges very well.
Try using:

=SUM(COUNTIF(INDIRECT("Sheet"&{2,3,4}&"!A1"),">0"))

HTH
Jason
Atlanta, GA

 

[Frank Kabel]

Hi
see your post in Excel.misc