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.