Multiplying the results of two columns of sums - Total Billed and Total Paid

I'm sure there's a simple answer to this, however I'm new to Excel and can't seem to find a suitable answer by Googling this issue. Thanks in advance for your patience, I'll try to explain the issue the best I can.

Here's the background:

I have a number of contract employees that work variable hours, I pay them a specific rate and bill my client for their services, at a marked up rate. I'm trying to calculate the TOTAL I pay the contractors over a two week period; and the TOTAL I bill the client over a two week period.

I've attached a sample worksheet, however in case there's issues opening it, my spread sheet looks like this:


Pay Rate Bill Rate Pay Period 1 Pay Period 2 Profit

Employee A $20.00 $25.00 40 40 $400.00
Employee B $30.00 $35.00 35 40 $375.00
Employee C $20.00 $25.00 40 40 $400.00
Employee D $15.00 $20.00 45 40 $425.00
Employee E $30.00 $40.00 40 40 $800.00
Employee F $25.00 $35.00 40 40 $800.00
Employee G $30.00 $45.00 40 40 $1,200.00
Employee H $40.00 $50.00 40 40 $800.00



Total Pay ??? (need formula)

Total Billed ??? (need formula)

The formula I use to calculate the "Profit" per line is =SUM((C2-B2)*(D2+E2)) (e.g. Profit for "Employee A")

What I need is a formula that allows for the variance in weekly hours, and automatically calculates the 'Total Pay' and 'Total Billed' fields.

Any help would be greatly appreciated!!

-Stu

Total Pay

=SUMPRODUCT(($B$2:$B$9)*($D$2:$D$9+$E$2:$E$9))

total Bill

=SUMPRODUCT(($C$2:$C$9)*($D$2:$D$9+$E$2:$E$9))

Thanks so much John!! Greatly appreciated!!

Thank you for the feedback and rep.

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

Thank you so much, mcmahobt... worked perfectly!