Forum Discussion
Solved
I need help with a Sumif formula
Hi Everyone I have 20 sales reps and we are kicking off a new commissions structure, whereby the sales rep is rewarded for selling more than 70 subscriptions in a month. If they sell =< 70 subsc...
Hi Doug,
I think that this is what you looking for:
Please find the attached file.
Hope that helps
Haytham
Doug,
build a lookup table and use LOOKUP() to find the value.
=LOOKUP(D2,$A$1:$B$7)*D2
| Number | Commission | |||
| 0 | $0,00 | 110 | $660,00 | |
| 71 | $5,00 | |||
| 101 | $6,00 | |||
| 121 | $7,50 | |||
| 151 | $9,00 | |||
| 201 | $12,00 |
Thank you Detlef, I really appreciate the prompt assistance - works great!
