Asked by crystal

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

Answered by helper
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'.
Answered by Writeacher
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.
Answered by crystal
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
Answered by helper
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.
There are no AI answers yet. The ability to request AI answers is coming soon!