Forum Discussion
Calculating the sum of incentive amount for each sales person with a given condition
Hello guys, I am stuck in a calculation. Actually, I am reporting a sheet on a daily basis recently i've added a column called incentive amount and i was calculating total sum of incentive amount for...
=VLOOKUP(C5,$G$5:$H$7,2,FALSE)<=D5=VLOOKUP(C5,$G$5:$I$7,3,FALSE)I'd apply two helper formulas in cells E5 and F5 and fill down as required.
=SUMPRODUCT(($B$5:$B$11=L14)*($E$5:$E$11=TRUE)*$F$5:$F$11)This is the formula in cell M14 which is filled across range M14:M16.