COUNTIF PROBLEM

M

manfred3

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
 
M

Mike H

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

manfred3

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

Pete_UK

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
 
M

manfred3

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




- Show quoted text -

Hi Pete,

Thanks for your reply.

This is just what was needed.

Regards,

Manir
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top