Forum Discussion
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
Hi Doug,
This question can be solved with lookup formula.
It can also be solved using a combination of 'match' and 'index' functions, which are my favorite for various set of problems. I've shown in the file attached.
I'm attaching the worksheet with both the formulas in it. I've used Haytam's Excel template to demonstrate.
