CountIf query within text string

J

JohnH

Hi all,

I am trying to count a word within a range of cells. Some cells may contain
the word within a text string for example:
Count the word "red" within "red 1", "red 2", "red 3" etc.
I know this can be done with the formula..."=CountIf(range, "*red*")"

The real question is if this is possible to search by a cell value?
ie. If cell "A1" equals "red" then count "red", if "A1" equals "blue" then
count the number of times "blue" appears.

Hope this makes sense. Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count If query within string 1
CountIf query for words within string 1
Count Word in long string 2
Program buttons to create a word document 0
Use BeforeDoubleClick to place 1 or 4 character in a cell 1
Conditional formatting with vba 3
Number Of Cells Between Colored Cells? 1
Remove Identical words 0

Top