COUNTIF

[Guest]

I am trying to use the COUNTIF function over a number of worksheets in a
spreadsheet to counht various values in a given cell on each sheet. However,
I just get a #VALUE error.
An example of the formula I am trying is
=COUNTIF('Blank Sheet:Blank Sheet 2'!D2, "0")

Any help much appreciated.

 

[Bob Phillips]

=SUMPRODUCT(COUNTIF(INDIRECT("'"&{"Blank Sheet","Blank Sheet1","Blank
Sheet2"}&"'!D2"),"0"))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)