Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
#2
![]() |
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
How to calculate days:Hours:Minutes: | Excel Worksheet Functions | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) |