Posted to microsoft.public.excel.worksheet.functions

manfred3

external usenet poster

Posts: 5

COUNTIF PROBLEM

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Countif Problem	Rob	Excel Discussion (Misc queries)	4	February 16th 10 03:31 PM
Problem with COUNTIF ...	Mac	Excel Worksheet Functions	1	November 6th 07 09:50 AM
countif problem	Scott@CW	Excel Discussion (Misc queries)	6	October 4th 07 02:41 PM
Problem w countif	ingeman	Excel Discussion (Misc queries)	2	July 17th 06 08:05 AM
Countif Problem	Mark W	Excel Worksheet Functions	2	April 21st 06 08:39 PM

All times are GMT +1. The time now is 06:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us