Simplify formula

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

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

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

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

http://www.xldynamic.com/source/xld.SUMPRODUCT.html why use --