CountIf query within text string

  • Thread starter Thread starter JohnH
  • Start date Start date
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.
 
John

The folmula you need is:-
=COUNTIF(range,"=" & A1)

Regards.
 
You must log in or register to reply here.

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
Excel Need Countifs Formula Help 0
Count font colour in a cell 2
How do I use Conditinal Format for another cell? 1
String Handling Discrepancy 2003 vs. 2007 3
Conditional Formatting VBA with formula to find string 3
Using Color as Criteria in Countif Function 3

Back
Top