![]() |
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? |
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