Excel formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bonni Wilbourne - 16 Oct 2006 15:10 GMT

I am using the formula - =COUNTIF(E913:E914,"COR") to count the number of
times the word COR occurs in my document. I got the formula from Excel Help
in the program. The problem is that it won't count, the answer is always
zero even though COR appears several times in Column E. Am I using the wrong
formula or even entering it wrong? Help!

Signature

Bonni

Reply to this Message

Ron Coderre - 17 Oct 2006 18:23 GMT

The formula you posted: =COUNTIF(E913:E914,"COR")
counts the number of cells that contain only "COR" (not case-sensitive) in
the 2 cells you referenced (E913 and E914).

Is that your situation?
Or may the cells contain "COR" within other text, e.g. "CORPORATE"?

Just in case....try this:
=COUNTIF(E913:E914,"*COR*")

The asterisks (*) are wildcards and will extend the match to any cell that
contains "COR" anywhere in it's displayed text. (only in those 2 cells, of
course)

Does that help?
***********
Regards,
Ron

XL2002, WinXP

> I am using the formula - =COUNTIF(E913:E914,"COR") to count the number of
> times the word COR occurs in my document. I got the formula from Excel Help
> in the program. The problem is that it won't count, the answer is always
> zero even though COR appears several times in Column E. Am I using the wrong
> formula or even entering it wrong? Help!

Reply to this Message

Rate this thread: