Multiply values in one column by values in another column

  • Thread starter Thread starter Paul Kaye
  • Start date Start date
P

Paul Kaye

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
 
Try this...

=SUMPRODUCT(A1:A3*B1:B3)

where you would change the A3 and B3 to the last row you expect to have data
on.

Rick
 
Back
Top