Adding + Multiplying 2 Colums' Rows
 

I've been having troubles with this a while. It's got me so annoyed tha
I've searched the Internet for some macros or some postings to m
problem. I haven't found anything and just to get over this, I'v
decided to post a message, maybe somebody can help me solve this....

I have 2 columns with f.e. 1000 rows of numbers - column A and Colum
B
in column A there are numbers f.e. from 1 to 1000. In column B ther
are numbers 0.5 0.7 4.5 6.7 12.4 2.8 4 5 etc....u
to 1000 different numbers. I would like to create column C, a third on
where there would be a result of these two rows in columns function f.e
multiply. If I want to multiply column A and B in row 1, so thei
product is in column C and repeat this process for all rows up to 1000
what should I do if I don't want to input manually function into colum
C =PRODUCT (A1,B1) , =PRODUCT (A2,B2), =PRODUCT (A3,B3) etc.... fo
all 1000 rows?

is there any way to automate this? same thing for summing up. ca
anybody help me please. thanks!!

--
rusca
-----------------------------------------------------------------------
ruscak's Profile: http://www.excelforum.com/member.php...fo&userid=2651
View this thread: http://www.excelforum.com/showthread.php?threadid=39781

Adding + Multiplying 2 Colums' Rows
 

ruscak,

In cell C1, type in the formula

=A1*B1

Then pres enter. Reselect C1, then move your mouse to the fill handle (the laittle black square at
the lower right of the cell). When you cursor changes from a white cross to a black cross, double
click, and that will fill your formula down to match your data in column B.

HTH,
Bernie
MS Excel MVP


"ruscak" wrote in message
...

I've been having troubles with this a while. It's got me so annoyed that
I've searched the Internet for some macros or some postings to my
problem. I haven't found anything and just to get over this, I've
decided to post a message, maybe somebody can help me solve this....

I have 2 columns with f.e. 1000 rows of numbers - column A and Column
B
in column A there are numbers f.e. from 1 to 1000. In column B there
are numbers 0.5 0.7 4.5 6.7 12.4 2.8 4 5 etc....up
to 1000 different numbers. I would like to create column C, a third one
where there would be a result of these two rows in columns function f.e.
multiply. If I want to multiply column A and B in row 1, so their
product is in column C and repeat this process for all rows up to 1000,
what should I do if I don't want to input manually function into column
C =PRODUCT (A1,B1) , =PRODUCT (A2,B2), =PRODUCT (A3,B3) etc.... for
all 1000 rows?

is there any way to automate this? same thing for summing up. can
anybody help me please. thanks!!!


--
ruscak
------------------------------------------------------------------------
ruscak's Profile: http://www.excelforum.com/member.php...o&userid=26512
View this thread: http://www.excelforum.com/showthread...hreadid=397816