ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I calculate columns? (https://www.excelbanter.com/excel-worksheet-functions/43068-how-can-i-calculate-columns.html)

Ninabean

How can I calculate columns?
 
In column 1 I have a list of jobs. For each job I need to keep track of Qty
sold, price and total. For instance, say I sold 2 @ $250.00 each, how do I
make the formula to calculate the total?

Mike

In the cell where you have the total hit the equal sign, click on the qty
cell, tap the * key, click on price cell then hit return. I assume you did
this on row 2, highlight row two, hold down the shift key until the totals
stop. Then hit control d which copies the formula down.

"Ninabean" wrote:

In column 1 I have a list of jobs. For each job I need to keep track of Qty
sold, price and total. For instance, say I sold 2 @ $250.00 each, how do I
make the formula to calculate the total?



All times are GMT +1. The time now is 08:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com