Help in using best way to get the result required

[Aashish1981]

I have an excel with the table structure shown below

Role	Name	1-Jan-23	10-Jan-23	20-Jan-23	30-Jan-23	10-Feb-23	20-Feb-23
Painter	A	P	P	A	A	P	P
Painter	B	A	P	A	P	P	P
Electrician	C	P	P	P	P	P	A
Plumber	D	P	A	P	P	A	P
Plumber	E	P	P	P	A	A	A
Plumber	F	A	P	P	P	P	P

I want to calculate the number of absentee and Presence on the basis of role, I was trying to calculate to put the condition of of role and presence or absence but not able to , Can anyone help me here, I want role wise absent presence status and also resource wise absence presence status.

[#2 · Accepted solution]

@Aashish1981 Hi maybe you can use the COUNTIF Functions, I think it can solve your problem.