SUMIFs or any other excel function with multiple criteria

[Stacy Rueda]

Hello there!

Can you guys please help me with my problem. i know this is very easy but to be like novice in excel, I don't know how to formulate below. Please help. Replies is very much appreciated.

Result : Sum the quantity based on Type, month and destination.

Thank you in advance.

[TABLE="width: 692"]
<colgroup><col><col><col><col><col span="2"><col><col><col><col></colgroup><tbody>[TR]
[TD]TYPE[/TD]
[TD]MONTH[/TD]
[TD]DESTINATION[/TD]
[TD]QTY[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: center"]April[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Apr[/TD]
[TD]CN[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD]DESTINATION[/TD]
[TD="colspan: 2"]QTY[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Apr[/TD]
[TD]CN[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]A[/TD]
[TD]CN[/TD]
[TD="colspan: 2"]?[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Jul[/TD]
[TD]CN[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD]HK[/TD]
[TD="colspan: 2"]?[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Apr[/TD]
[TD]HK[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD]JP[/TD]
[TD="colspan: 2"]?[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Apr[/TD]
[TD]HK[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]PH[/TD]
[TD="colspan: 2"]?[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Apr[/TD]
[TD]HK[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Apr[/TD]
[TD]HK[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD]B[/TD]
[TD]CN[/TD]
[TD="colspan: 2"]?[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Apr[/TD]
[TD]HK[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]HK[/TD]
[TD="colspan: 2"]?[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Apr[/TD]
[TD]HK[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]JP[/TD]
[TD="colspan: 2"]?[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Apr[/TD]
[TD]CN[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]PH[/TD]
[TD="colspan: 2"]?[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Apr[/TD]
[TD]JP[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Apr[/TD]
[TD]JP[/TD]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Apr[/TD]
[TD]JP[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Apr[/TD]
[TD]JP[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]May[/TD]
[TD]JP[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]May[/TD]
[TD]PH[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]May[/TD]
[TD]JP[/TD]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]May[/TD]
[TD]PH[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

Try to generate a pivot table, something like;

Book1
	N	O	P	Q	R
1	Sum of QTY	Column Labels
2	Row Labels	Apr	May	Jul	Grand Total
3	A	9	3	3	15
4	CN	3		3	6
5	HK	6			6
6	PH		3		3
7	B	22			22
8	CN	1			1
9	HK	9			9
10	JP	12			12
11	C		10		10
12	JP		8		8
13	PH		2		2
14	Grand Total	31	13	3	47
Sheet1