tungtran.ftu
05-13-2015, 09:31 PM
Dear everyone.
I have to create a new function that sum of multiplier of muti-columns like below
A B C D E F G H
Qty' Price Qty' Price Qty' Price Total
Code1: 20 5 15 6 21 5.2 =Sum(B3*C3+D3*E3+F3*G3) -> function for this fomula
Code1: 20 5 15 6 21 5.2 =Sum(B4*C4+D4*E4+F4*G4)
Code1: 20 5 15 6 21 5.2 =Sum(B5*C5+D5*E5+F5*G5)
Code1: 20 5 15 6 21 5.2 =Sum(B6*C6+D6*E6+F6*G6)
Who can help me solve it?
Many thanks to you.
I have to create a new function that sum of multiplier of muti-columns like below
A B C D E F G H
Qty' Price Qty' Price Qty' Price Total
Code1: 20 5 15 6 21 5.2 =Sum(B3*C3+D3*E3+F3*G3) -> function for this fomula
Code1: 20 5 15 6 21 5.2 =Sum(B4*C4+D4*E4+F4*G4)
Code1: 20 5 15 6 21 5.2 =Sum(B5*C5+D5*E5+F5*G5)
Code1: 20 5 15 6 21 5.2 =Sum(B6*C6+D6*E6+F6*G6)
Who can help me solve it?
Many thanks to you.