Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I get the columns to automatically add?
I am new to excel and I need one column to add the quanity to the dollar
amount and need it to total in the last column how do I set that up to do it automatically? -- MaryAnne |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I get the columns to automatically add?
Assume the dollar amount is in cell B2, the quantity in C2, and the total in
D2. The formula should read: =B2*C2 . You can then copy the same formula down column D. Click on D2, and hold down the shift key while clicking on the last row of data. Then press Ctrl+D to copy the formula. "rockingmom" wrote in message ... I am new to excel and I need one column to add the quanity to the dollar amount and need it to total in the last column how do I set that up to do it automatically? -- MaryAnne |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding three consecutive columns | Excel Worksheet Functions | |||
Automatically Break Multiple Rows to Two Columns | Excel Discussion (Misc queries) | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) |