How to sum data from 2 tables for unique ID number

[Josu]

Hello guys I am using Excel 2010
I have big need at work to figure out how I can quickly sum data from 2 tables
As example i have 2 tables with data for each ID - let say it's customer, and for each customer i have number of units ordered, is it any easy way to sum that numbers?
Issue is that often i don't have customer from Table B in Table A, but all data basically need to be summed in Table A.
Can you help please?
Tables are looking like this:
Table A
Customer Pens Pencils Staples
555 5 4 3
556 5 4 3
557 5 4 3
558 5 4 3

Table B
Customer Pens Pencils Staples
555 5 4 3
557 5 4 3
559 5 4 3

 

[jtakw]

Hi,

This is one way:

Book3.xlsx
	A	B	C	D	E	F
1	Table A					Total Units
2	555	5	4	3		24
3	556	5	4	3		12
4	557	5	4	3		24
5	558	5	4	3		12
6
7
8	Table B
9	555	5	4	3
10	557	5	4	3
11	559	5	4	3
Sheet815

Cell Formulas
Range	Formula
F2:F5	F2	=SUMPRODUCT((A$2:A$5=A2)*B$2:D$5)+SUMPRODUCT((A$9:A$11=A2)*B$9:D$11)

 

[Josu]

Man, you amazing, thanks for the formula i almost made very useful tool for me, now need to look for more formulas in google

 

[jtakw]

You're welcome, thanks for the feedback.