Help needed to get values from different sheet and sum if the value in one column matches

szpt9m

Board Regular
Joined
Feb 24, 2013
Messages
53
Hi All,
I have a workbook with 3 sheets each having 2 columns!

Rich (BB code):
Sheet1:

Col-A</SPAN>Col-B</SPAN>
3245688</SPAN>12</SPAN>
4567893</SPAN>13.5</SPAN>
1342567</SPAN>15</SPAN>
<TBODY> </TBODY><COLGROUP><COL span=2></COLGROUP>
Sheet2:
Col-ACol-B
324568813.7
213947545
987576823
<COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY> </TBODY>
Sheet3:
Col-ACol-B
14223423
2456356
15678913.2
<COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY> </TBODY>

Now i need to search in all 3 sheets, if column A value of one sheet matches with another sheet, then i need to sum the values in column B. if it doesnot matches then i just need take those values and put it in my resultant sheet.
so the result from the above example will be as below:
Rich (BB code):
  
Col-ACol-B
324568825.7
456789313.5
134256715
213947545
987576823
14223423
2456356
15678913.2
<COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY> </TBODY>
Since here the first value in column A of sheet 1 matches with that of sheet 2, the values in column B is summed up.. all other values are placed as it is..
Thank you,
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Forum statistics

Threads
1,147,481
Messages
5,741,400
Members
423,657
Latest member
Medrok2021

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top