Forum Discussion
Solved
Calculating Commissions with escalator clause
Hi, I am trying to calculate commissions with an escalator clause and break it out by month. In column A I have the date the deal closed. In column E I have the amount of the deal, with E29 totaling ...
See the attached workbook.
Hi,
the escalator starts over at the start of the new Fiscal year, which is April. Capturing that piece of that isnt essential - I can always make another box of months to capture if needed. Thank you,
the escalator starts over at the start of the new Fiscal year, which is April. Capturing that piece of that isnt essential - I can always make another box of months to capture if needed. Thank you,
See the attached workbook.
- Thank you! I altered it slightly to =SUMIFS($E$3:$E$23,$A$3:$A$23,">="&DATE(2023,1,1),A3:A23,"<="&DATE(2023,1,31)) for the cumulative for only the month in question and then commission =SUMPRODUCT((B29>$F29:$F$29)*(B29-$F$28:$F$29),$H$28:$H$29)
thank you so much!