Count attandance within a month by employee ID

I was working on an attendance sheet.
A B C D E F G H
Staff ID: PB01 PB02 PB03 PB04 PB05 PB06 V001
Kabir Monir Alamgir Yeamin Akash sadek Mahfuz
01 October 2021 P P P P P P P
02 October 2021 P P P P P P P
03 October 2021 P P P P P P P
04 October 2021 P P P P P P P
05 October 2021 P W P P P P W
06 October 2021 W P W W W W P
07 October 2021 P P P P P P P
08 October 2021 P P P P P P P

And so on............
Now I want to count the total attendance "P" of a month by using Staff ID, something like as below

Staff ID: PB01 (Dropdown staffs ID)
Name:

Attandance
JAN #N/A
FEB #N/A
MAR #N/A
APR #N/A
MAY #N/A
JUN #N/A
JUL #N/A
AUG #N/A
SEP #N/A
OCT 1
NOV #N/A
DEC #N/A

Here I use this formula =COUNTIFS(INDEX($B$4:$BA$1000,MATCH(1,($A$4:$A$1000>=AX6)*($A$4:$A$1000<=AX7),0),MATCH(BA2,$B$2:$BA$2,0)),"P")
In AX6: start date of a month
In AX7: Last date of that month
but it returns 1. not the total attendance date. Please seeking solution for this problem from experts.

Here I attach my sample datasheet.

To use a single formula change the file as per attachment



Sheet2


D6=SUMPRODUCT((Sheet1!$B$1:$P$1=Sheet2!$D$2)*(MONTH(Sheet1!$A$3:$A$100)=MONTH(Sheet2!$C6&0))*(Sheet1!$A$3:$A$100<>"")*(Sheet1!$B$3:$P$100=Sheet2!D$4))

Copy down

Thanks Samba, it worked nicely.

Thanks CARACALLA, Its worked nicely.