Multiply values in one column by values in another column

Giganews Newsgroups
Subject: Multiply values in one column by values in another column
Posted by:  Paul Kaye (paulmjka…@gmail.com)
Date: Mon, 7 Jul 2008

Hi,

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.

Any suggestions?

Many thanks,

Paul

Replies