Oct 25 2021 08:38 AM
Hi,
I need to count the amount of times 2 words appear in each row in a column. (See image attached) I need to calculate how many times "Diamond" and "Medium" appear. I have been trying to use the COUNTIF formula and I was only able to count how many times Diamond appears (one word or value).
Can someone help me with this?
Really appreciate it in advance!
Oct 25 2021 08:53 AM
=SUM(--ISNUMBER(SEARCH("Diamond",A2:A9)),--ISNUMBER(SEARCH("Medium",A2:A9)))
Is this the formula you are looking for? It has to be entered as arrayformula with ctrl+shift+enter.