COUNTIF PROBLEM
in [Functions]
|
Prev: Check the lasta character
Next: Date refrencing
From: manfred3 on 19 Apr 2010 04:28 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
From: Mike H on 19 Apr 2010 05:37 Hi, the answer may be spaces, try this =SUMPRODUCT(--(TRIM(G1:G13)="DPRS")) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "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 > > . >
From: manfred3 on 19 Apr 2010 07:41 On Apr 19, 9:28 am, manfred3 <manir.far...(a)googlemail.com> 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.
From: Pete_UK on 19 Apr 2010 07:43 Post the formula that you are using. Does it cover the correct range of column G? Could you have spaces before or after some of those DPRS values? You might like to try this: =COUNTIF(G:G,"*DPRS*") Hope this helps. Pete On Apr 19, 9:28 am, manfred3 <manir.far...(a)googlemail.com> 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
From: manfred3 on 19 Apr 2010 07:54
On Apr 19, 12:43 pm, Pete_UK <pashu...(a)auditel.net> wrote: > Post the formula that you are using. Does it cover the correct range > of column G? Could you have spaces before or after some of those DPRS > values? You might like to try this: > > =COUNTIF(G:G,"*DPRS*") > > Hope this helps. > > Pete > > On Apr 19, 9:28 am, manfred3 <manir.far...(a)googlemail.com> 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- Hide quoted text - > > - Show quoted text - Hi Pete, Thanks for your reply. This is just what was needed. Regards, Manir |