Hi, I'm really struggling with using Sumproduct in a sales commission model. See the attached file please.
I have a number of hurdles, and sales commission %s once you pass each hurdle. The catch is, you only get commission on NEW incremental sales.
I have a sumproduct formula in line 10 but it is not fully accurate --- I need the formula to return the results in line 21 instead. The manual calculations in order to get to line 21 are in lines 13 to 19.
Help please!!!
I have a number of hurdles, and sales commission %s once you pass each hurdle. The catch is, you only get commission on NEW incremental sales.
I have a sumproduct formula in line 10 but it is not fully accurate --- I need the formula to return the results in line 21 instead. The manual calculations in order to get to line 21 are in lines 13 to 19.
Help please!!!