- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2008 July
- Multiply values in one column by values in another column

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

- Re: Multiply values in one column by values in another column posted by Rick Rothstein \(MVP - VB\) on Mon, 7 Jul 2008