Excel 2007 - Count of certain word within a cell's text string
Trying to figure out how I can configure a formula to count how many times a certain word appears within a range of cells.
i.e I have a range of cells that contain verbatim feedback and want to see how many times they include certain words within the feedback.
So I think I need a formula that not only searches but also counts... Any thoughts?
Thanks -
-T
With
A1: (a text value to count....eg Sugar)
and
cells containing text that *may* include the A1 text
D1: Sugar and Spice
D2: Sugar Bears contain no Sugar.
This formula returns the count of that value
in a range of cells:
Please Login or Register to view this content.
In the above example,
the count of "Sugar" is 3.
Note: SUBSTITUTE is case sensitive, hence the UPPER function.
Is that something you can work with?
oh well! Ron got there!
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
Thanks Ron! Perfect Solution!
Glad to help a fellow Bostonian.
What is wrong with simply
=COUNTIF(D1:D10,"Sugar*")
?? Thanks Paul
New to forum. Found =SUMPRODUCT helpful, however need to do the following: Total "sugar" or "oranges" as the text unit in a range of cells; then, need to multiply the "text unit" times a "number" in the "Units" range of cells. So total of sugar or oranges sold over period of time times the number of units sold.
Thanks in advance.
Tried it and only counts the cells that start with Sugar.Originally Posted by paultheguru
the following formula would also work
=countif(range,"*word*) that contains all the words no matter where they are at the beginning, middle or end in the cell.
this was helpful for a query that came up today. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks