Sequence flag

[fireslguk]

I have no idea where to start on this one

I have a row of columns that would contain days of a month e.g 31

On a row I would like to flag a sequence of 15 in one cell and the next right being 9

Ignoring all other combinations e.g 15 15. Or zero 15 or 9 15 - only to flag a 15 then next column 9. Not only flag but count these occasions if it happens a number of times in the month

So typical sheet

Row. 3. Columns b until af for the number of days 31 for certain month

Each tab will be a different month

Column A would be a persons name same row

 

[Marcelo Branco]

Counting 15 followed by 9
=SUMPRODUCT(--(B2:AE2=15),--(C2:AF2=9))

M.

 

[fireslguk]

Of course I see my error now I used the sumproduct but used the wrong range !! Thankyou

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.