Sum Multiple Columns in Pivot Table

[tcustance]

Hello everyone,

I have been trying to solve my problem for hours now. Wondering if anyone can point me in the direction. I am trying to do a sum of like products in a pivot table, but from multiple columns.

Here is what my data looks like:

Product 1	Product 2	QTY for Product 1	Qty for Product 2
A	B	7	7
A	C	4	4
A	A	19	19
A	B	2	2
A	A	6	6

I would like to have a pivot table sum the quantity for product 1 & 2 across the sheet, like below:

Product	Total for Product
A	63
B	9
C	4

Thank you,

 

[Saurabhj]

Hi,

I am not sure if we can show the data in Pivot table.

But to show the sum of products you can use below formula:

=SUMIF(A:A,J2,C:C)+SUMIF(B:B,J2,D:D)

Thanks,
Saurabh

 

[Sufiyan97]

Saurabhj's formula will look like

Book6
	A	B	C	D	E	F	G	H	I	J	K
1	Product 1	Product 2	QTY for Product 1	Qty for Product 2						Product	Total for Product
2	A	B	7	7						A	63
3	A	C	4	4						B	9
4	A	A	19	19						C	4
5	A	B	2	2
6	A	A	6	6
Sheet1

Cell Formulas
Range	Formula
K2:K4	K2	=SUMIF(A:A,J2,C:C)+SUMIF(B:B,J2,D:D)