ExcelBanter - COUNTIF

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - COUNTIF (https://www.excelbanter.com/excel-worksheet-functions/104885-countif.html)

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.

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

--
HTH

Bob Phillips

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

"Slim" wrote in message
...
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.