Help for a newbie?
 

This is probably easy but I haven't been able to figure it out

Column A is a quantity, Column B is a price. I have Column A and B
populated and want to make Column C to be the actual price paid (ie,
column a*column b). Column A and column B, however, have about 2500
rows of information. Is there a way to have column C report the
product of column A and column B without manually entering a1*b1
a2*b2 etc etc in column C for all 2500 rows?


Thanks


--
rehr0001
------------------------------------------------------------------------
rehr0001's Profile: http://www.excelforum.com/member.php...o&userid=18477
View this thread: http://www.excelforum.com/showthread...hreadid=396721

In Column C, input your formula +a1*b1. in column c1 right click and choose
copy, then click in cell c2 and hold down the left mouse button and drag it
down to your last row and then right click and choose paste. Or in cell c2
put your pointer on the little square in the bottom right corner of the cell
click an hold the mouse and drag to the last cell and release. It should
copy your formula down for you.

"rehr0001" wrote:


This is probably easy but I haven't been able to figure it out

Column A is a quantity, Column B is a price. I have Column A and B
populated and want to make Column C to be the actual price paid (ie,
column a*column b). Column A and column B, however, have about 2500
rows of information. Is there a way to have column C report the
product of column A and column B without manually entering a1*b1
a2*b2 etc etc in column C for all 2500 rows?


Thanks


--
rehr0001
------------------------------------------------------------------------
rehr0001's Profile: http://www.excelforum.com/member.php...o&userid=18477
View this thread: http://www.excelforum.com/showthread...hreadid=396721

On the second part of the solution, I said to put you pointer in cell c2, but
it should be in c1. Put your pointer in the little square until it turns to
a "+", then drag it down.

"rehr0001" wrote:


This is probably easy but I haven't been able to figure it out

Column A is a quantity, Column B is a price. I have Column A and B
populated and want to make Column C to be the actual price paid (ie,
column a*column b). Column A and column B, however, have about 2500
rows of information. Is there a way to have column C report the
product of column A and column B without manually entering a1*b1
a2*b2 etc etc in column C for all 2500 rows?


Thanks


--
rehr0001
------------------------------------------------------------------------
rehr0001's Profile: http://www.excelforum.com/member.php...o&userid=18477
View this thread: http://www.excelforum.com/showthread...hreadid=396721

Hi!

Try this:

=SUMPRODUCT(A1:A2500,B1:B2500)

Multiplies column A by column B then sums the total.

Biff

"rehr0001" wrote in
message ...

This is probably easy but I haven't been able to figure it out

Column A is a quantity, Column B is a price. I have Column A and B
populated and want to make Column C to be the actual price paid (ie,
column a*column b). Column A and column B, however, have about 2500
rows of information. Is there a way to have column C report the
product of column A and column B without manually entering a1*b1
a2*b2 etc etc in column C for all 2500 rows?


Thanks


--
rehr0001
------------------------------------------------------------------------
rehr0001's Profile:
http://www.excelforum.com/member.php...o&userid=18477
View this thread: http://www.excelforum.com/showthread...hreadid=396721

Thank you so much for your help Ms. P and Biff. Ms. P, your solution
is exactly what I was looking for.


--
rehr0001
------------------------------------------------------------------------
rehr0001's Profile: http://www.excelforum.com/member.php...o&userid=18477
View this thread: http://www.excelforum.com/showthread...hreadid=396721