Forum Discussion
Solved
Politely Asking for Help on a Formula - Thanks!
Hi, my business gives commissions to our drivers (called “captains” as shown in the Excel screenshot). Their commission is 10% of the sale price of a surcharge they sell. I want to track...
=LET(captain,UNIQUE(TRANSPOSE(P5:T5)),
commission,SUMIF($P$5:$T$5,captain,$P$30:$T$30),
result,CHOOSE({1,2},captain,commission),
result)Maybe with this formula as shown in the attached file.