No worries thanks for your help.

I did see this formula: =SUM(--(FREQUENCY(IF(A1:A10=1,ROW(A1:A10)),IF(A1:A10<>1,ROW(A1:A10)))>1)) this works for counting consecutive 1's, does anybody know if it could be changed to "S" for example or any text?