Vlookup and Sum if meet criteria

[faisus]

Hi all, I have 2 sheets and under one sheet I have below 3 rows

In the other sheet I have below columns and would like to have category wise Sum of amount for Active members and deleted members separately in the respective columns.

Kindly advise the formula as the data is alot. Thank you

 

[Kerryx]

Book1
	A	B	C
1	m.Status	Amount	Cat
2	Active	88	VIP
3	Active	1460	A
4	Active	392	B
5	deleted	450	C
6	deleted	850	A
Sheet1

Book1
	A	B	C
1	Cat	Amt Del	Amt Act
2	VIP	0	88
3	A	850	1460
4	B	0	392
5	C	450	0
Sheet2

Cell Formulas
Range	Formula
B2:B5	B2	=SUMIFS(Sheet1!$B$2:$B$6,Sheet1!$A$2:$A$6,"Deleted",Sheet1!$C$2:$C$6,$A2)
C2:C5	C2	=SUMIFS(Sheet1!$B$2:$B$6,Sheet1!$A$2:$A$6,"Active",Sheet1!$C$2:$C$6,$A2)

 

[faisus]

Thank you dear, works perfectly.