Good Afternoon Excel Gurus:

Bonus Worksheet.xlsx

I work for a homebuilder and have team members incentivized to each sale. I need a little help figuring out the formula to compute the total bonus. I've attached a sample with some dummy data (the real data will be exported automatically).

Through search I was able to find many examples pertaining to %s, but nothing like what I am looking for.

Thanks in advance for your help. I'm still an excel 101 user...

Many thanks,
Phillip