how do I get the columns to automatically add?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding totals to new sheet 9
need Excel formula that figures out which data adds up to total 4
Having cells default to 0 2
Using Text to Columns with a function 6
Cell for Changing Multiple Values in other columns 2
looking for a function that will populate opening a worksheet or t 2
WHAT IS THE RIGHT FUNCTION ? 3
Data Look Up 2

Back
Top