Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ninabean
 
Posts: n/a
Default 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?
  #2   Report Post  
Mike
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hiding columns and custom views problem Bettergains Excel Discussion (Misc queries) 2 April 12th 05 11:48 PM
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns foofoo Excel Discussion (Misc queries) 1 April 2nd 05 12:02 AM
How to calculate days:Hours:Minutes: Hood Excel Worksheet Functions 1 January 17th 05 11:11 AM
how to increase maximum number of columns in excel 2003 [email protected] Excel Discussion (Misc queries) 1 January 16th 05 08:13 PM
Counting the Contents of Two Columns Molochi Excel Discussion (Misc queries) 6 December 22nd 04 08:13 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"