Results 1 to 7 of 7

Calculating values from different sheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-23-2013
    Location
    Bangalore
    MS-Off Ver
    2010
    Posts
    130

    Calculating values from different sheet

    Hi All,

    Straight to the point!!

    I have a workbook with 3 sheets each having 2 columns!

    Sheet1:
    
    Col-A	Col-B
    3245688	12
    4567893	13.5
    1342567	15
    
    Sheet2:
    Col-A	Col-B
    3245688	13.7
    2139475	45
    9875768	23
    
    Sheet3:
    Col-A	Col-B
    142234	23
    24563	56
    156789	13.2
    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:

    Col-A	Col-B
    3245688	25.7
    4567893	13.5
    1342567	15
    2139475	45
    9875768	23
    142234	23
    24563	56
    156789	13.2
    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,
    Last edited by JBeaucaire; 03-08-2013 at 12:57 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1