Tererai Muridzo
Harare,Zimbabwe
Member
Members
Forum Posts: 8
Member Since:
February 5, 2016
February 5, 2016
Offline
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
Frans Visser
Duivendrecht (near Amsterdam) - The Netherlands
VIP
Members
Forum Posts: 346
Member Since:
April 21, 2015
April 21, 2015
Offline
Frans Visser
Duivendrecht (near Amsterdam) - The Netherlands
VIP
Members
Forum Posts: 346
Member Since:
April 21, 2015
April 21, 2015
Offline
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
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Catalin Bombea, Noel Noel
Guest(s) 10
Top Posters:
Catalin Bombea: 1913
SunnyKow: 1432
Anders Sehlstedt: 899
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 279
lea cohen: 245
Jessica Stewart: 219
A.Maurizio: 213
Newest Members:
Mallika Asireddy
Sheila Sanders
Francine Walshe
Sean Ladlow
Jorge Chicas
mahmoud salem
Irvine Choolo
Deon Bouwer
Amgad Squires
jim bo
Forum Stats:
Groups: 3
Forums: 24
Topics: 6836
Posts: 29989
Member Stats:
Guest Posters: 49
Members: 33569
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —