Counting cells which contain a specific word

  • Thread starter Thread starter YHG
  • Start date Start date
Y

YHG

I want to count the number of cells within a range which
contain the word "partner", where "partner" is not the
only word within the cell. COUNTA(B2:M65,"partner") only
returns the number of cells for which "partner" is the
sole entry in the cell. I need _all_ cells which contain
the word "partner", regardless of whether other words
appear in the cell. Any clue how I can do this? Your
expertise would be most appreciated.
 
Back
Top