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 |
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 |
All times are GMT +1. The time now is 08:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com