|Subject:||Multiply values in one column by values in another column|
|Posted by:||Paul Kaye (paulmjka…@gmail.com)|
|Date:||Mon, 7 Jul 2008|
I'm sure this must have been posted before but I can't seem to get my
search terms accurate enough to find it. I have two columns: "Number
of containers" and "Volume of container". I want to multiply these to
give me the total volume of all containers: (A1*B1)+(A2*B2)+(A3*B3)...
I could create this long formula manually, but I'm sure there must be
a better way. Naturally, I could do this by creating a new column,
multiplying each row and then adding the values in the third column
but, again, I'm sure there must be a more elegant solution.