Counting series' of text within a row

[Kipper63]

Hi, I have a table with rows of data where the column headings are dates and a code 'd' is added for particular instances of activity on that date.
I have included a simple example below.
I am trying to calculate how many series of 'd' there are i.e. there are 4 unique series of 'd' code appearing. I am not interested in the number of 'd's.
I am struggling to get started, I am hoping someone can help?

A B C D E F G H I J K L M N O P Q R
Row 1 01/03/20 02/03/20 03/03/20 04/03/20 05/03/20 06/03/20 07/03/20 08/03/20 09/03/20 10/03/20 11/03/20 12/03/20 13/03/20 14/03/20 15/03/20 16/03/20 17/03/20 18/03/20
Row 2 d d d d d d d d d d
Row 3

 

[Peter_SSs]

Try this

=COUNTIFS(J2:JY2,"d",J$1:JY$1,"<"&TODAY(),J$1:JY$1,">="&EDATE(TODAY(),-12),K2:JZ2,"<>d",K$1:JZ$1,"<="&TODAY(),K$1:JZ$1,">"&EDATE(TODAY(),-12))

 

[Kipper63]

That is fabulous, thanks once again.

 

[Peter_SSs]

That is fabulous, thanks once again.

Cheers. Glad to help.