Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I set up a way to add up the number of lines used when cal.
I am doing a worksheet. On this chart I want to track the price of an object
sold. Along with that I want to add up the number of the objects that have been sold, by just adding up the number sold in a column. Is there a way to do this, beside creating another column and putting a qty in it. |
#2
|
|||
|
|||
It sounds like you want to use =countif()
(if each object is singular) If you have quantities, maybe using =sumif() Debra Dalgleish has some nice counting/summing instructions at: http://www.contextures.com/xlFunctions01.html and http://www.contextures.com/xlFunctions04.html Nixco wrote: I am doing a worksheet. On this chart I want to track the price of an object sold. Along with that I want to add up the number of the objects that have been sold, by just adding up the number sold in a column. Is there a way to do this, beside creating another column and putting a qty in it. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions | |||
multiply by actual number in cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |