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.

TYPE	MONTH	DESTINATION	QTY					April
A	Apr	CN	1				DESTINATION	QTY
A	Apr	CN	2			A	CN	?
A	Jul	CN	3			HK	?
B	Apr	HK	5			JP	?
B	Apr	HK	1			PH	?
B	Apr	HK	3
A	Apr	HK	3			B	CN	?
A	Apr	HK	2			HK	?
A	Apr	HK	1			JP	?
B	Apr	CN	1			PH	?
B	Apr	JP	1
B	Apr	JP	6
B	Apr	JP	1
B	Apr	JP	4
C	May	JP	2
C	May	PH	2
C	May	JP	6
A	May	PH	3

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

 

[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