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.
 
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

TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
can we count words in a row which has links from other file 2
Count the words in a cell 8
count nonblank cells 3
How do I count cells that contain a number of charctors. 3
count a word recurrent in many cells 1
Counting cells with specific month in 7
How to count cells that do not contain "-" 8

Back
Top