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!

Question

Cost/Units Number of Units Total Cost

$0.99 40
$2.99 25

Answer 1

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'.

Answer 2

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.

Answer 3

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

Answer 4

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.