A
AFN
A B
1 3 $1.12
2 8 $0.14
3 15 $1.71
4 etc etc
400 6 $3.83
I want to have one cell at the bottom be = A1*B1 + A2*B2 + A3*B3 etc
....... A400*B400
I know that I could add a column C to store the multiplication on each row,
and then SUM column C, but is there a way to do this without adding a column
C?
1 3 $1.12
2 8 $0.14
3 15 $1.71
4 etc etc
400 6 $3.83
I want to have one cell at the bottom be = A1*B1 + A2*B2 + A3*B3 etc
....... A400*B400
I know that I could add a column C to store the multiplication on each row,
and then SUM column C, but is there a way to do this without adding a column
C?