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


"Paul Kaye" <paulmjkaye@gmail.com> wrote in message
news:315c8aa3-311e-43d8-9801-9ccebb7812a4@y21g2000hsf.googlegroups.com...
> 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

On Jul 7, 11:27*am, "Rick Rothstein \(MVP - VB\)"
<rick.newsNO.S...@NO.SPAMverizon.net> wrote:
> 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
>
> "Paul Kaye" <paulmjk...@gmail.com> wrote in message
>
> news:315c8aa3-311e-43d8-9801-9ccebb7812a4@y21g2000hsf.googlegroups.com...
>
> > 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

Perfect - thanks!