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

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

On Apr 19, 9:28*am, manfred3 <manir.far...@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.

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

On Apr 19, 12:43*pm, Pete_UK <pashu...@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...@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

You're welcome, Manir - thanks for feeding back.

Pete

On Apr 19, 12:54*pm, manfred3 <manir.far...@googlemail.com> wrote:
>
> Hi Pete,
>
> Thanks for your reply.
>
> This is just what was needed.
>
> Regards,
>
>

Hi Pete,

No problem.

Manir



On Apr 19, 1:00*pm, Pete_UK <pashu...@auditel.net> wrote:
> You're welcome, Manir - thanks for feeding back.
>
> Pete
>
> On Apr 19, 12:54*pm, manfred3 <manir.far...@googlemail.com> wrote:
>
>
>
>
>
> > Hi Pete,
>
> > Thanks for your reply.
>
> > This is just what was needed.
>
> > Regards,- Hide quoted text -
>
> - Show quoted text -