Counting variable data in fields

[moshpitdj]

Hello -

I'm building a RACI chart for my superiors, and in some fields, I may have a combination of one or all four letters of R A C I. I'm having trouble finding a formula that can account for this - say I have an R in one field, and I could how many instances of R that column has - easy counting (=COUNTIF(F5:F100,"R") ), but what if I have R and A (in any combination AR, or A R, or A,R, or A;R), or all 4 letters, RACI?

How do I put a formula in the counting fields that will not only count single instances, but instances of any of the combinations? i.e. I need to account for all Rs, As, Cs, Is, RAs, RCs, RIs, all other possible combinations.

Thanks in advance,
Dan

[Sadath31]

HI
=SUMPRODUCT(ISNUMBER(SEARCH("A",F5:F100))*ISNUMBER(SEARCH("R",F5:F100)))
this will count all combination of R and A