Thread: Sumif?

Hello all:

I am working on a report where I need to SUM amounts in column H, but only those amounts whose ID (located in column A) can be found on a list in a specific sheet of the same workbook. I have 5 additional sheets with lists that contain ID's so I'll use the same piece of code to sum all of these ID's column H values that match ID's in other sheets.

So basically steps are these:

1. Go through column A in the active sheet and look for ID's that match ID's in specific sheet (also located in Column A).
2. If the matching ID is found, use value from the H column of the same row and add it to the SUM.

SUM cell is located 8 cells under the last row in column F, but that's not the problem since I already figured that part out. I am just having difficulties with creating a piece of code to SUM values from cells in column H based on the matching ID's in column A.

Hopefully I made some sense. Let me know if you need more clarification.

Thank you!!!

Assuming sheet 1 and sheet 2 then try this formula

=SUMPRODUCT(ISNUMBER(MATCH(A2:A100,Sheet2!A2:A100,0))+0,H2:H100)