Return value if cell contains specific text

[CAMERON854]

Hello,
I am trying to count how many times a specific text appears in column M:M

for example:

if column M:M contains "CaCl" then return how many times this appeared in cell R4

so R4 would have a value of 105 if that's how many times CaCl was in column M:M

any help is greatly appreciated

 

[Fluff]

How about

=countifs(M:M,"CaCl")

 

[CAMERON854]

How about

=countifs(M:M,"CaCl")

Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[CAMERON854]

Thank you!

How about

=countifs(M:M,"CaCl")

how can i do this for multiple words and return the sum?
=countifs(M:M,"Cacl","NaDi","KCl")

 

[Fluff]

How about

=sum(countifs(M:M,{"Cacl","NaDi","KCl"}))

 

[CAMERON854]

How about

=sum(countifs(M:M,{"Cacl","NaDi","KCl"}))

thank you it worked perfectly ! just needed the extra boost. this is how the formula turned out.

=SUM(COUNTIFS('July Blend (A)'!M:M,{"Test NaDi,","Test CaCl,","Test KCl,","Test MgCl,","Test NaCl,","REJECT ChkWgt,Test NaDi,","REJECT ChkWgt,Test NaCl,","REJECT ChkWgt,Test MgCl,","REJECT ChkWgt,Test KCl,","REJECT ChkWgt,Test CaCl,"}))

 

[Fluff]

Glad to help & thanks for the feedback.