Multiple Lookup Values/Criteria

Hey everyone... I need to create a complicated function that will do the following on the workbook I attached:

1. Use a SUMIF function to check for the part number in the data values matches the part number in the column of my summary.
2. Multiply the SUM of those values in the data table by the quantity for each item. You must only multiply where the value in the month column is greater than 0.

If I am being unclear of what I am trying to accomplish, please let me know and I will explain in more detail.

Thanks for any help.

Enter this formula in C24, and fill down:

=SUMPRODUCT(--($A$4:$A$12=A24),($B$4:$B$12),($C$4:$C$12))

Originally Posted by BigBas

Enter this formula in C24, and fill down:

=SUMPRODUCT(--($A$4:$A$12=A24),($B$4:$B$12),($C$4:$C$12))

Worked great. Thanks for the help.

Glad I could help.