Count the same value in a cell

[Falinaicare]

To Whom It May Concern,

I have attached the excel document for you to guide me on the countif.

Is there any idea that I can count 2 values in one cell?

If yes, please share here.

Hope to hear from you soon.

Thanks.

 

[Juniad]

Copy and paste the formula in cell A10 - for Office 365
=SUM(IF(MID(SUBSTITUTE(B10,"ABC","!"),SEQUENCE(LEN(B10)),1)="!",1,0))

 

[vletm]

Falinaicare​

=IF(FIND(CHAR(10),B10)>1,2,1)
Note: My Excel finds that char(10)

 

[Monty]

Try This

=COUNTIF(A1:A10, "*value1*") + COUNTIF(A1:A10, "*value2*")

 

[Falinaicare]

Dear Junaid, vletm and Monty,

Appreciated of all your excel assistance.