Hi Richard

One way
=MAX(0,SUMPRODUCT(--(C7:J7="AR")+(C7:J7="IR"))-1)

Regards
Roger Govier


Richard wrote:
Hi,

I have a list of 8 intitials in a row (C7 : J7), such as AR, IR, CS, RP
etc. These are 4 golfing pairs.

How do I count the number of times "AR" AND "IR" appear anywhere on row
C7..J7?

E.g.
if both "AR and "IR" appear in range C7 : J7, the result of "1" would be
returned in K7.
if just "AR" appears, without "IR", the result of "0" would be returned
in K7.

I'm stumped - any assistance would be appreciated

Tks - Rick