COUNTIF

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
=SUMPRODUCT(COUNTIF(INDIRECT("'"&{"Blank Sheet","Blank Sheet1","Blank
Sheet2"}&"'!D2"),"0"))

--
HTH

Bob Phillips

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