how do I multiply two columns one by another? Thanks

K

kawka

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.
 
G

Gord Dibben

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
 
S

Sandy Mann

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

[email protected]
[email protected] with @tiscali.co.uk
 
K

kawka

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
 
K

kawka

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
 
Top