Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel formula
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! -- Bonni |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel formula
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 "Bonni Wilbourne" wrote: 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! -- Bonni |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Excel Formula Issue | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |