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

(e-mail address removed)
(e-mail address removed) 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to center adjust text above and image in a two column document. 1
Format column widths from one table to a separate table on same page 1
Two columns followed by single page-width column on same page 0
Autonumber field in Excel that behaves the same as Access 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Count total balance using two numbers 5
Format a Range to Multiply by 1000 5
how can I multiply a column by only one cell? 4

Top