Countifs

[Akki20]

Given data

DESIGNATION	Day-1	Day-2
PROJECT LEADER	P	P
TEAM LEADER	P	P
TEAM LEADER	P	P
SERVICE PLANNER	P	P

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>

Required data ( It should count "P" against each category)

	Day-1	Day-2
PROJECT LEADER	1	1
TEAM LEADER	2	2
SERVICE PLANNER	1	1

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>

 

[Peter_SSs]

Like this?

Formula in B11 copied across and down.

Excel Workbook
	A	B	C
1	Given data
2	DESIGNATION	Day-1	Day-2
3	PROJECT LEADER	P	P
4	TEAM LEADER	P	P
5	TEAM LEADER	P	P
6	SERVICE PLANNER	P	P
7
8
9	Required data ( It should count "P" against each category)
10		Day-1	Day-2
11	PROJECT LEADER	1	1
12	TEAM LEADER	2	2
13	SERVICE PLANNER	1	1
COUNTIFS

 

[Akki20]

Thank you very much.

I was also trying with the same concept but failed, now it is coming correct. Thanks