"Otto Moehrbach" wrote:

Slim
You have to give us more than that. What is your question? HTH Otto
"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.