Thread: Excel formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Excel formula

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.

--
Regards

Roger Govier


"Bonni Wilbourne" wrote in
message ...
=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
--
Bonni