Merging and summing values with common column

[basak.dibojyoti]

Hi All Geniuses there,

I have a specific requirement where I need to sum values based on a common column. Say for ex-

Sheet1 has the following info:
Account Values
A3 30
A4 40
A1 50
A2 80

Sheet2 has the following Info:

Account Values
A2 20
A3 70
A1 50
Requirement is like to add up the values with respect to the common field and also merging the two sheets:

Result:

Account Values
A1 100
A2 100
A3 100
A4 40

I am new to excel, so was not too sure how to get this done, can someone please help.

Thanks in advance.
Dibo.

 

[BGY23]

On your summary sheet creat a unique list of all the accout numbers from both sheets 1 and 2. Lets sy the list is in the range a1:a10. Lets also say that the data on sheets 1 & 2 are in the range a1:B10.

In b1 on the summary sheet type this formula.

=sumif(sheet1!a1:a10,A1,Sheet1!b1:b10)+sumif(sheet2!a1:a10,A1,Sheet2!b1:b10)


You can anchor the ranges with $ as required.


In

 

[basak.dibojyoti]

Thanks a lot, really appreciate it.