X
xtrmhyper
I Have A Column A & B
I Have A Formula At Column C =sum(a2*b2)+(a3*b3)+(a4*b4)
Answer Is 31
I Want To Multiply A1 And B1 Up To The Last Range Of Data Add The Total
Product
The Problem Is:
If Have A Lot Of Data In Column A & B, The Formula Is So Very Long
Theres Any Easy Formula?
A B
3 5
2 7
2 2
I Have A Formula At Column C =sum(a2*b2)+(a3*b3)+(a4*b4)
Answer Is 31
I Want To Multiply A1 And B1 Up To The Last Range Of Data Add The Total
Product
The Problem Is:
If Have A Lot Of Data In Column A & B, The Formula Is So Very Long
Theres Any Easy Formula?
A B
3 5
2 7
2 2