Hi all,

Can anybody please help... i'm really struggling here!

I need to count the number of blank cells (in a row) that occurs
between 2 words S and C. I have the formula below and i cant get the
damn thing to work!


=SUMPRODUCT(--(G5:AX5="S"),--(G5:AX5="C"))


Any help GREATLY appreciated..

Cheers

P :-)