COUNTIF over several worksheets

  • Thread starter Thread starter RoyK
  • Start date Start date
R

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
 
Unfortunately, COUNTIF doesn't handle 3D ranges very well.
Try using:

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

HTH
Jason
Atlanta, GA
 
Back
Top