Sum/multiply function
Experts,
I am looking to multiply column A by column B and then sum multiple rows in
a single step.
Example:
A B
1 11 1
2 22 2
3 33 3
4 44 4
5 55 5
I have many rows like this and I would like to do this
<=a1*b1+a2*b2+a3*b3+a4*b4+a5*b5 without typing all of that out.
Ryan
|