Excel formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bonni Wilbourne - 16 Oct 2006 15:12 GMT

=COUNTIF(E913:E914,"COR") is the formula I'm using to count the number of
times COR appears in column E. Am I using this formula incorrectly? What is
the correct formula to count a non number in a column if this is wrong??
Thanks

Signature

Bonni

Reply to this Message

Roger Govier - 16 Oct 2006 15:46 GMT

Hi Bonni

You say "appears in column E", but you have restricted it to rows
913:914 within column E. Is this what you wanted to do?

There is nothing wrong with your formula, but if you are getting a
result of 0, it may be that your data has a space after the COR.

Try
=COUNTIF(E913:E914,"COR ")
or
=COUNTIF(E913:E914,"COR*")
but be aware that the latter could find COR as part of CORRESPONDENCE
etc.

There are other techniques as well, so post back if any of these
suggestions do not resolve your problem.

Signature

Regards

Roger Govier

> =COUNTIF(E913:E914,"COR") is the formula I'm using to count the number
> of
[quoted text clipped - 3 lines]
> wrong??
> Thanks

Reply to this Message