waysofolde
12-18-2007, 11:41 AM
Need to know if there is a formula for counting text in Excel that would count the cell if if contains multiple values.
for example:
I am wanting Excel to count the range of cells in column J that contain the word football. However, some of the cells contain football, baseball.
and other will have baseball, football.
Is there anyway that I can write the formula that would count the cells if the word is showing at all?
Thanks in advance for any and all help.
for example:
I am wanting Excel to count the range of cells in column J that contain the word football. However, some of the cells contain football, baseball.
and other will have baseball, football.
Is there anyway that I can write the formula that would count the cells if the word is showing at all?
Thanks in advance for any and all help.