Forum Discussion
ishaqib
Mar 21, 2023Copper Contributor
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...
OliverScheurich
Mar 21, 2023Gold Contributor
=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.