how do I multiply two columns of numbers one by another?
almost every # is different but there is the same amount of them in both
columns.

Assuming columns A and B.

In C1 enter =A1+B1

Double-click on the fill handle of C1 to copy down.

Fill handle is the little black lump at bottom-right corner of the cell.


Gord Dibben MS Excel MVP

On Fri, 25 May 2007 20:42:00 -0700, kawka
wrote:

how do I multiply two columns of numbers one by another?
almost every # is different but there is the same amount of them in both
columns.

I think that Gord intended:

=A1*B1

but if you want to add all the results of the multiplications up without
having the results of the multiplication try

=SUMPRODUCT(A1:A100,B1:B100)

adjust the ranges to suit.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Assuming columns A and B.

In C1 enter =A1+B1

Double-click on the fill handle of C1 to copy down.

Fill handle is the little black lump at bottom-right corner of the cell.


Gord Dibben MS Excel MVP

On Fri, 25 May 2007 20:42:00 -0700, kawka

wrote:

how do I multiply two columns of numbers one by another?
almost every # is different but there is the same amount of them in both
columns.

Hej gays - you're wanderfull there. I spend so many hours to figure it out
myself with no result.... & it was just clic away - love U

"Sandy Mann" wrote:

I think that Gord intended:

=A1*B1

but if you want to add all the results of the multiplications up without
having the results of the multiplication try

=SUMPRODUCT(A1:A100,B1:B100)

adjust the ranges to suit.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Assuming columns A and B.

In C1 enter =A1+B1

Double-click on the fill handle of C1 to copy down.

Fill handle is the little black lump at bottom-right corner of the cell.


Gord Dibben MS Excel MVP

On Fri, 25 May 2007 20:42:00 -0700, kawka

wrote:

how do I multiply two columns of numbers one by another?
almost every # is different but there is the same amount of them in both
columns.

Thanks Sandy

"multiply" being the keyword


Gord

On Sat, 26 May 2007 12:06:48 +0100, "Sandy Mann"
wrote:

I think that Gord intended:

=A1*B1

but if you want to add all the results of the multiplications up without
having the results of the multiplication try

=SUMPRODUCT(A1:A100,B1:B100)

adjust the ranges to suit.

Hej gays - you're wanderfull there. I spend so many hours to figure it out
myself with no result.... & it was just click away - love U

"Gord Dibben" wrote:

Assuming columns A and B.

In C1 enter =A1+B1

Double-click on the fill handle of C1 to copy down.

Fill handle is the little black lump at bottom-right corner of the cell.


Gord Dibben MS Excel MVP

On Fri, 25 May 2007 20:42:00 -0700, kawka
wrote:

how do I multiply two columns of numbers one by another?
almost every # is different but there is the same amount of them in both
columns.