Simplify formula

**BRISBANEBOB** · 11-28-2010, 05:38 PM

There has to be a simpler, more robust formula than I am using in the sample worksheet (attached) - I'm thinking =sumproduct - but I can't find it. Late night last night...

Any help appreciated.

Thanks

**JBeaucaire** · 11-28-2010, 06:02 PM

My math comes up a little different from yours, but perhaps like so...

**martindwilson** · 11-28-2010, 06:06 PM

put another column t with a vlookup to get rates then you can use sumproduct or even sumifs with excel 2007(mind you i make the total in your example 14,679 not 15,199

**BRISBANEBOB** · 11-28-2010, 06:06 PM

Beautiful, but what's with the "--"?

**TMS** · 11-28-2010, 06:16 PM

Maybe something like the attached updated workbook will work for you.

As you have a list of hourly rates, I've used that to collate the hours. That, in turn, is used in a SUMPRODUCT ... as you desired.

Regards