Count based on multiple criteria

[Sufiyan97]

I want to count PL text based on name and date

Book4
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1		1/1/2022	1/2/2022	1/3/2022	1/4/2022	1/5/2022	1/6/2022	1/7/2022	1/8/2022	1/9/2022	1/10/2022	1/11/2022	1/12/2022	1/13/2022	1/14/2022	1/15/2022
2	Name
3	A	1	1	1	1	PL	PL	1	1	1	1	1	1	1	1	1
4	B	PL	1	1	1	1	1	1	1	1	1	1	1	1	1	1
5	C	1	1	1	1	1	1	1	1	1	1	1	1	1	PL	PL
6	D	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
7	A	1	1	1	1	1	1	1	1	PL	1	1	1	1	1	1
8	A	1	1	1	1	1	PL	1	1	1	1	PL	1	1	1	1
9	A	1	1	1	1	1	1	1	1	1	1	1	1	1	1	PL
10	B	1	1	1	1	1	1	1	1	1	1	1	PL	1	1	1
11	B	1	1	1	1	1	PL	1	1	1	1	1	1	1	1	1
12
13
14
15							Date	1/6/2022
16							Name	A
17						Expected	PL	2
18
19
Sheet1

 

[Fluff]

How about

=COUNTIFS(A3:A11,H16,INDEX(B3:P11,,MATCH(H15,B1:P1,0)),G17)

 

[Sufiyan97]

Thank you very much Fluff
Working Perfect!

 

[Fluff]

You're welcome & thanks for the feedback.