Thread: COUNTIF
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default COUNTIF

Check my response!

--
HTH

Bob Phillips

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

"Slim" wrote in message
...


"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.