I have a cell of data that contains the following:
Cell A2: plastic straws; plastic cups; plastic soda bottles; plastic cutlery; plastic stirrers;
I want to count in a different cell how many of the following words are in the above cell:
straws
cups
water
soda
cutlery
stirrers
cotton
other
The answer should be 5.
Is this possible in Excel?
Thanks in advance!
Last edited by mlmsimmons; 11-16-2022 at 11:09 PM. Reason: solved
is that what you want?
Company 1 Count straws cups soda bottles cutlery stirrers Total
No, I need a single number to be in the cell. Similar to what I highlighted in yellow on the attachment.
An option, please tryFormula:
Please Login or Register to view this content.
like this ?
Score for Company 1
Amazing!!!! OK, one more question. What if I wanted straws to be given 2 points and the rest were 1?
Amazing!!!! OK, one more question. What if I wanted straws to be given 2 points and the rest were 1?
Please try =SUM(FILTER(D3:D10,ISNUMBER(FIND(C3:C10,A2))))
Re: Count specific words in a cell
after set your own points Refresh green table
plastic straws; plastic cups; plastic soda bottles; plastic cutlery; plastic stirrers;
Last edited by sandy666; 11-16-2022 at 10:18 PM.
THANK YOU for such a quick response. And one more question (hopefully this is the last one!) For the first formula you provided...if the cell doesn't include any of the words, how do I get it to show a 0 instead of #CALC! ?
use @username !
Please tryFormula:Please Login or Register to view this content.
Thank you Hans and Sandy, I truly appreciate your time and help! THANK YOU!!!!
You are welcome, thanks for your feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks