![]() |
Quick Microsoft Excel Question
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 |
Is it B+C or BxC?
|
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
|
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. |
Thanks so much, that worked!
|
Coolio :) *It better have, I'm an Excel freak* heheheh
|
All times are GMT -7. The time now is 04:19 PM. |
Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
©2000-, AI Media Network Inc123