Forum

Notifications
Clear all

Total Commission Calculation Using VLookUp

5 Posts
3 Users
0 Reactions
169 Views
(@tmridzogmail-com)
Posts: 8
Active Member
Topic starter
 

hi guys

What is the total commission made by Jackie? from the attached ,had used the formula below and its not working

 

"=sum(VLOOKUP("jackie",$B$5:$N$17,{((2*C20),(3*D20),(4*e20),(5*f20),(6*g20),(7*h20),(8*i20),(9*j20),(10*k20),(11*l20),(12*m20),(13*n20)},0)

Attached is the file

Regards

 

Tererai

 
Posted : 31/01/2017 8:46 am
(@fravis)
Posts: 337
Reputable Member
 

Don't understand completely what your formula is doing. But: in your formula you spelled the name without the capital "J" and because you looked for an exact match (the zero at the back of the formula) that's maybe one point to check out? 

 
Posted : 31/01/2017 4:13 pm
(@fravis)
Posts: 337
Reputable Member
 

Second one. I don't see anything counting other than the percentages on row 20. So that doesn't work either. There is no relation between something in the table (lets say the values on the row of Jackie) and the commission and the counting then. Can you explain what you want to be counted? You are using two formulas in the wrong way together, as I see it at the moment

 
Posted : 31/01/2017 4:18 pm
(@tmridzogmail-com)
Posts: 8
Active Member
Topic starter
 

Hi Frans

 

thank you ,got it ,check below formula for the calculation

 

=SUMPRODUCT(INDEX(C5:N17,MATCH("Jackie",B5:B17,0),),C20:N20)
 
Posted : 01/02/2017 4:43 am
(@sunnykow)
Posts: 1417
Noble Member
 

Just change your formula to

=SUMPRODUCT(INDEX(C5:N17,MATCH("Jackie",B5:B17,0),0))

it should give you $307

Hope this helps.

Sunny

 
Posted : 01/02/2017 11:34 am
Share: