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
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