COUNTIF

Copper Contributor

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!

2 Replies

@Elther 

=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.

@Elther 

That could be like

=COUNTIF(A2:A9, "*Diamond*")