J
JohnH
Hi all,
I am trying to find a formula that will count specific words within a range.
Some of the cells may be part of a text string for example:
count the word "red" within cells containing "red", "red 1", "red 2" etc.
I know this can be done with the formula...=countif(range, "*red*")
The real question is if I can do this by searching for a word within a cell
value? So, if cell "A1" equals "red", count "red", if cell "A1" equals
"blue", count blue.
Thanks in advance.
I am trying to find a formula that will count specific words within a range.
Some of the cells may be part of a text string for example:
count the word "red" within cells containing "red", "red 1", "red 2" etc.
I know this can be done with the formula...=countif(range, "*red*")
The real question is if I can do this by searching for a word within a cell
value? So, if cell "A1" equals "red", count "red", if cell "A1" equals
"blue", count blue.
Thanks in advance.