How To Match Values from different sheets and get the sum of those values

**lofthi** · 05-31-2013, 12:50 PM

Good day,

I have a problem regarding the match of values from different sheets.

I have here 3 worksheets, the first one is the Summary, then the two wroksheets is the project.

scenario:
I want to get sum of all the hours that he consume on that day and display it in the Summary Tab.

Here is my macro code, but when i Msgbox at the sheet_hours it loops.

Please Login or Register  to view this content.

I appreciate your help. Thanks a lot and comment please

**AlphaFrog** · 05-31-2013, 01:29 PM

If you only have the two sheets to sum from, this formula could lookup the values and sum the two results.
D11
=INDEX('DOC TYPE'!$10:$100,MATCH($B11,'DOC TYPE'!$B$10:$B$100,0),MATCH(D$10,'DOC TYPE'!$10:$10,))
+INDEX('KMS MOC'!$10:$100,MATCH($B11,'KMS MOC'!$B$10:$B$100,0),MATCH(D$10,'KMS MOC'!$10:$10,))

Or, as in your example workbook, the names and dates are all the same on each sheet, you wouldn't have to lookup anything.
D11 =SUM('DOC TYPE:KMS MOC'!E11)

**lofthi** · 05-31-2013, 02:19 PM

Hi,

Those 2 Worksheets was just for early example, So far, i didn't input yet all the sheets there.
Actually it will be all the same template for all the worksheet, What i'm after is to find the time of a specific person and get the hours that he spend.

Person 1 = get his total hours on all the same day of different project.