lookup multiple cells with corresponding multiple criteria based on one table

Hello,
I've been trying to find an answer to this question online - so far no success.
I have a table of several types, where each type has two values (Z1,Z2)
I have another table, with 6 rows, in each row several instances of the types from the first table, with no specific order.
I'm trying to calculate the TOTAL Z1 and Z2 values of all the instances in each row.

Any idea?

Thank you alllookup table.jpg

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

In H22, copied across and down:

=SUMPRODUCT(($C22:$G22=$B$12:$B$17)*C$12:C$17)

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.