=SUM Formula (Word Search)

[bobzy20]

Hi,

This will probably be a very simple fix but with limited knowledge of how these formulas work, it isn't easy for me!

I'm using the following formula below and all I want to do is add an additional search word: Q.E.F

=SUM(LEN(Purchases!B:B)-LEN(SUBSTITUTE(Purchases!B:B,"QEF","")))/LEN("QEF")

Any help would be great.

Thanks

 

[Fluff]

Like

=SUM(COUNTIFS(A:A,{"*QEF*","*Q.E.F*"}))

 

[bobzy20]

Thanks very much for your help, this has now resolved all issues.

 

[Fluff]

You're welcome & thanks for the feedback