If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
COUNTIF PROBLEM
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 . |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
COUNTIF PROBLEM
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 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 |
#5
|
|||
|
|||
COUNTIF PROBLEM
On Apr 19, 12:43*pm, Pete_UK 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 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 |
#6
|
|||
|
|||
COUNTIF PROBLEM
You're welcome, Manir - thanks for feeding back.
Pete On Apr 19, 12:54*pm, manfred3 wrote: Hi Pete, Thanks for your reply. This is just what was needed. Regards, |
#7
|
|||
|
|||
COUNTIF PROBLEM
Hi Pete,
No problem. Manir On Apr 19, 1:00*pm, Pete_UK wrote: You're welcome, Manir - thanks for feeding back. Pete On Apr 19, 12:54*pm, manfred3 wrote: Hi Pete, Thanks for your reply. This is just what was needed. Regards,- Hide quoted text - - Show quoted text - |
Thread Tools | |
Display Modes | |
|
|