VBA Count one number followed by another

[Stephen_IV]

Good evening,

I need to do certain counts of pairs. At work we have certain tasks (16) to where each employee has to participate. I need to check daily to see if certain employees are completing tasks one after the other. For this example I need to count 15 followed by 16. Cannot be 16 and 15 has to be 15 then 16. The example count below would be 3. Any help would be appreciated.

Book1 A B C D E F G H I J K L M N O P 2 21 15 16 14 1 1 16 12 12 15 16 1 2 15 16 3 Sheet2

 

[JoeMo]

=SUMPRODUCT(($B$2:$O$2=16)*($A$2:$N$2=15))

 

[Stephen_IV]

JoeMo that is nice. Thank you.

 

[JoeMo]

JoeMo that is nice. Thank you.

You are welcome - thanks for the reply.

 

[Peter_SSs]

.. or if you have the COUNTIFS function

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	21	15	16	14	1	1	16	12	12	15	16	1	2	15	16	3
Countifs

Cell Formulas
Range	Formula
P1	P1	=COUNTIFS(A1:N1,15,B1:O1,16)

 

[Stephen_IV]

Thanks Peter for replying another good option.

 

[Peter_SSs]

Thanks Peter for replying another good option.

Cheers. Thanks for the follow-up.