Hi there --

I have an extensive Excel spreadsheet that requires SUMPRODUCT in many of my
formulas. I have had success so far, but am now stumped. Any help would be
appreciated.

Here's a sample layout of the portion of the spreadsheet I'm calculating from:

Col A Col B (hours) Col C (bill rate)
FT 46 $95
FT-OT 48 $85
FT-OT 40 $75
FT 36 $65

So here's the issue:
1. If Col A is FT (full time), simply multiple Col B by Col C.
2. If Col A is FT-OT (overtime allowed) and over 40 hours, multiple 40
times Col C, multiple hours over 40 times (Col C * 1.5) for time-and-a-half.
3. If Col A is FT-OT and <= to 40, simply multiple Col B by Col C.

1 and 3 are not a problem at all. I can handle that. However, my problem is
with 2. It is a bit complicated communicating what I've tried, so I won't
include that here. But if anyone could provide the formula to accomplish
this, I would be VERY APPRECIATIVE.

Thanks so much. Let me know if you need any additional info.

Ellen