Countifs

[Rajesh M]

How to apply the formula at same column Countifs and index match formula.
Below mentioned example data is particular date. If i change the date in drop down list, need data also will be change.
Which formula i can apply this formate. Pleas anyone help me.

summary

Designation	Scope	P	WOFF	A	V
SUPERVISOR	4	44087	0	0	0
PROMOTER	54	30	21	3	0
SHARED PROMOTER	18	12	5	1	0
MERCHANDISER	11	10	0	1	0

Source data

Designation	SUPERVISOR NAME	1-Sep-20	2-Sep-20	3-Sep-20	4-Sep-20	5-Sep-20	6-Sep-20	7-Sep-20	8-Sep-20	9-Sep-20
SUPERVISOR	CHANDRAKANTH	P	P	P	P	P	WOFF	P	P	P
MERCHANDISER	CHANDRAKANTH	P	P	P	P	P	WOFF	P	P	P
PROMOTER	CHANDRAKANTH	P	P	P	P	A	WOFF	P	P	P
SHARED PROMOTER	SOWMYA N	P	P	P	P	P	WOFF	P	P	P

 

[padapinto]

WHICH DATA DO YOU WANT TO GET CHANGED,