Please Help!
On one part of the spreadsheet I have a resource schedule of employees and
what they should be working on during a specific week (columns B&C).

Column A Column B Column C
Jack EAS EAS
Ted Optimum BSN
Carl Twin Labs Optimum
Bill EAS Optimum

On another part of the same spreadsheet I have stages (column Y) and the
price per unit (column Z) for each account (column X)

Column X Column Y Column Z
EAS Shipping 25.50
Optimum Packaging 30.29
Twin Labs Shipping 19.95
BSN Labeling 35.78


So I need to calculate if an account is in the shipping stage what the total
of column Z per week (columns B&C). For Week 1 (column B) it would be 70.95
and for week 2 (column C) it would be 25.50. HOWEVER, the bigger issue is
that all of these fields are constantly changing so the formula needs to be
open for future iterations. I've tried this

=SUM((SUMPRODUCT ((B2:B5=X1)*Z1)),((SUMPRODUCT ((B2:B5=X2)*Z2))...etc.

which will give me the total amount but I can't seem to work in the "if"
condition for the shipping status. Any thoughts? there's gotta be a better
way