When I use the sum button it gives me the wrong answer but when I times it comes out right. How do I put the total in the total column? Please help if you know how use excel!
Cost/Units Number of Units Total Cost
$0.99 40
$2.99 25
You don't want a sum, you want a product.
Use auto sum button, and choose more functions, put multiply or product in the search box and choose 'Product'.
http://www.google.com/search?aq=f&sourceid=chrome&ie=UTF-8&q=excel+tutorial
There are various Excel tutorials here. You probably need to learn how to make formulas for the exact calculation you need.
I know if I multiply Cell C ($0.99) and Cell D (40) the total is $39.60 but Im having trouble figuring out how to word it so the total will go in the right column
I'm not sure I'm following you.
Do you just want the total 39.60 in the total column?
If so, go to Cell E (col E) and click on 'Auto Sum'. One of the choices are "More Functions". Click on that. A box will come up. Type "Product" in that box and click go. "Product" will come up. Click that. The total, 33.60 will now be in Col D. Copy the contents of Col D to other cells as needed.
To put the total in the total column, you can use a formula in Excel. Here's how you can do it:
1. Click on the cell in the "Total Cost" column where you want to place the total.
2. Type the equal sign (=) to start a formula.
3. Select the cell in the "Cost/Units" column for the corresponding row (e.g., cell A2 for the first row) and multiply it by the cell in the "Number of Units" column for the corresponding row (e.g., cell B2 for the first row). The formula should look like this: =A2 * B2.
4. Press Enter to get the total cost.
Now, whenever you change the values in the "Cost/Units" or "Number of Units" columns, Excel automatically recalculates the total cost using the formula.