I need URGENT Help

[Ibrarbutt]

Group 1	P
Group 1<strike></strike>	A
Group 2	P
Group 3	A
Group 3	A
Group 1	P
Group 2	A
Group 3	P
Group 2	P
Group 1	A

<tbody>
</tbody>

I need Results, i have 1000 rows for 15 groups

Group No	Count(P)	Count(A)
Group 1	2	2
Group 2
Group 3

<tbody>
</tbody>

Group 1 Counts (A) Count
Group 2
Group 3

 

[James006]

Just Insert a Pivot Table ... (less than 5 seconds ... it's done ...)

 

[Ibrarbutt]

Pivot Table is not working, as the second col, i have almost 35.

 

[AlanY]

try

Book1
	A	B	C	D	E	F
1	Group 1	P		Group No	P	A
2	Group 1	A		Group 1	2	0
3	Group 2	P		Group 2	2	0
4	Group 3	A		Group 3	1	0
5	Group 3	A
6	Group 1	P
7	Group 2	A
8	Group 3	P
9	Group 2	P
10	Group 1	A
Sheet2

Cell Formulas
Range	Formula
E2	=COUNTIFS(A:A,$D2,B:B,E$1)