Total Commission Calculation Using VLookUp

[Tererai Muridzo]

hi guys

What is the total comission 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)

See file attached for the data


Regards


Tererai

 

[Chihiro]

Something like this.
=SUMPRODUCT(INDEX(C5:N17,MATCH("Jackie",B5:B17,0),),C20:N20)

 

[Tererai Muridzo]

hi Chihiro

Thank you ,let me work around it to fully comprehend it

Regards

Tererai