#1   Report Post  
Deb B.
 
Posts: n/a
Default copying columns

I want to multiply one column by the next one to produce a product in
the third column. Is there a formula that does this in one step?
Thanks,
Deb
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

Deb

=SUMPRODUCT(A1:A65535,B1:B65535) in C1

For more on SUMPRODUCT see Bob Phillips' site

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Gord Dibben Excel MVP


On 26 Nov 2004 17:08:00 -0800, (Deb B.) wrote:

I want to multiply one column by the next one to produce a product in
the third column. Is there a formula that does this in one step?
Thanks,
Deb


  #3   Report Post  
Sean Haynes
 
Posts: n/a
Default

I want to multiply one column by the next one to produce a product in the
third column. Is there a formula that does this in one step?


Not as far as I know, but Excel will allow you to do nearly the same in few
steps. Let's say you have you have the following spreadsheet:

A B C
1 Price Qty Subtotal
2 $5.00 2 $10.00
3 $4.80 10 $48.00
etc.

where C2 =A2*B2
C3 =A3*B3
etc.

Now click on C3 and drag the little black box down as far as you need. Excel
will apply "Price*Qty" formula all the way down.

I use Excel 2003 and assume this will work for you.

- Sean Haynes


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can i set consecutive columns in an excel worksheet to differ. Adam H Charts and Charting in Excel 2 February 26th 05 12:08 AM
Colors of columns after sorting data in the supporting table Booger_Boy Charts and Charting in Excel 6 January 24th 05 03:41 PM
How can I write vertically in some columns on an Excel spreadshee. Teacher using spreadsheets Charts and Charting in Excel 1 January 9th 05 02:00 AM
Can I use side by side colums and stacked columns in same graph? Debbie Charts and Charting in Excel 1 December 29th 04 07:01 PM
Creating a chart with values from two columns Ivan Charts and Charting in Excel 2 December 12th 04 08:31 PM


All times are GMT +1. The time now is 01:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"