Labor Dollars By Employee and Client

[benwahchang]

I'm looking to figure out if there is a formula I can easily write/replicate that will show me total number of labor hours by client (Client 1 & 2) at the bottom of each client (highlighted in yellow). The current value in the cell highlighted in yellow is what should be shown, however, there isn't a formula for it. I need it to be accurate based off the number of hours each employee had under that specific client while also reflecting their specific pay rate.

Example file attached. Again, the formula I'm looking for should go in the cells highlighted in yellow.

[protonLeah]

You would be better off using helper columns vs. some complex formula.

[benwahchang]

What would you propose from a helper column standpoint?

[JeteMc]

Try pasting the following into cell G45 and dragging across to cell H45: =SUMIFS($F2:$F43,G2:G43,"<>")
Let us know if you have any questions.