Countifs, but only last 5 occurrences

[ste33uka]

Hi could someone adjust this formula so it would count the last 5 occurrences ?
My data sheet has over 10,000 rows, have just shown small example

have attached photo for better understanding

Book1
	C	D	E	F	G	H	I	J
2				PETER				3
3				5
4
5
6
7
8
9	PETER		12
10	PETER		1
11	PETER		3
12	PETER	2	14
13	PETER	2	15
14	DAN		8
15	DAN		2
16	DAN		1
17	DAN		4
18	PAUL		4
19	PETER		12
20	PETER		1
21	PETER		3
22	PETER	1	12
23	PETER		12
24	PETER		1
25	PETER		3
26	PETER	2	14
Sheet1

Cell Formulas
Range	Formula
J2	J2	=COUNTIFS($C$1:$C$9971,$F$2,$D$1:$D$9971,"",$E$1:$E$9971,">="&$F$3)

 

[KRice]

I don't quite follow what is meant by count the last 5. This will count the number of rows that match your criteria, and if the value exceeds 5, only 5 will be reported back.

=MIN(5,SUMPRODUCT(($C$9:$C$9971=$F$2)*($D$9:$D$9971="")*($E$9:$E$9971>=$F$3)))