Thread: COUNTIF PROBLEM
View Single Post
  #3  
Old April 19th, 2010, 12:41 PM posted to microsoft.public.excel.worksheet.functions
manfred3
external usenet poster
 
Posts: 5
Default COUNTIF PROBLEM

On Apr 19, 9:28*am, manfred3 wrote:
Hi,

I am using the countif formula in my spreadsheet to count the number
of times "DPRS" appears in say column G. for some reason it keeps
givong me the wrong answer i.e. instead of 29 I get 9 as the
answer.When I filter for "DPRS" I get 29. There are no blank cells in
between.

Thanks,

Manir


i would appreciate aeply.