How can I get a count of specifc words in a range?

  • Thread starter Thread starter Guest
  • Start date Start date
If there will be a maximum of one specifc word per cell:

=COUNTIF(range, "specifc")


If the specifc word can occur multiple times within a cell, array-enter
(CTRL-SHIFT-ENTER or CMD-RETURN):

=SUM(LEN(range)-LEN(SUBSTITUTE(range, "specifc","")))/LEN("specifc")
 
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

how to lookup if value exists in a range of data? 3
How can I calc totals for specifc techs on a specific date? 3
How do I link a value into a sentence in Excel? 4
counting specific words 6
counting unique items within categories - but EXCLUDING blank cell 5
HELP NEEDED FOR IF Function Inside a Macro 1
Hide Rows If Condition True 2
Counting a specific item in a form or report 2

Back
Top