Excel formula

[Bonni Wilbourne]

=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

 

[Roger Govier]

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.