Countif the letter among another letter

[KIM Chanthan]

Hi,

Do you have any excel formula to count if one letter from another combination of word...
Please check attached file for more detail example.

Thanks,
Chanthan

 

[bosco_yip]

Try...........

D2, copied down :

=LEN(A$2&A$3&A$4)-LEN(SUBSTITUTE(A$2&A$3&A$4,C2,""))

Regards
Bosco

 

[John Jairo V]

Hi, to all!

If you will have more than three cells in future, this could be an option:

=SUMPRODUCT(LEN(A$2:A$4)-LEN(SUBSTITUTE(A$2:A$4,C2,"")))

Blessings!

 

[KIM Chanthan]

Try...........

D2, copied down :

=LEN(A$2&A$3&A$4)-LEN(SUBSTITUTE(A$2&A$3&A$4,C2,""))

Regards
Bosco

It works perfectly. Thanks

 

[KIM Chanthan]

Hi, to all!

If you will have more than three cells in future, this could be an option:
=SUMPRODUCT(LEN(A$2:A$4)-LEN(SUBSTITUTE(A$2:A$4,C2,"")))

Blessings!

It works perfectly. Thanks