Counting Specific Text

  • Thread starter Thread starter japc90
  • Start date Start date
J

japc90

I want to type a formula that will look at a range of cells and count
1 each time it finds a specific word. So if my range of cells is
A1:A50 and the word "math" is in cells A2, A4, and A10 it would bring
back a count of 3.

All help is greatly appreciated.
 

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 fowmula that will look for multiple words 2
counting 3
Count number of values 2
counting 2
Urgent assistance required for excel 2
Excel Need Countifs Formula Help 0
Sumproduct and Count If 1
Real-time sorting 11

Back
Top