Quick Microsoft Excel Question

[mkx]

Column B contains the quantity (ex. 2) and column C contains the price (ex. 5.50), how do I automatically or manually have excel calculate the total cost (column B x column C) and possibly even put it in column D for me. There are to many cells to do this with a calculator.

Right now it is just adding column B + C, example sum = 7.50

[Trixxxia]

Is it B+C or BxC?

[mkx]

Right now by default it is B+C, i need to make it BxC, i think it is something simple but I hardly ever use excel so I am not sure

[Trixxxia]

If it's B+C= D In column D put '=SUM(B1:C1)'
If it's BxC= D In column D put "=SUM(B1*C1)'
Then copy your D1 cell and paste it all the way down.

[mkx]

Thanks so much, that worked!

[Trixxxia]

Coolio *It better have, I'm an Excel freak* heheheh