Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Item Count vs Item Cost
I would like to put the cost of an item in a cell and have the sum of the
costs in a cell to the right but at the top of the column I would like to have a total item count for all the items in that column would look something like this, with Col A items worth $15.00, Col B $10.00 and so on. A B C D E F G 3 1 5 1 15.00 10.00 20.00 $55.00 2 20.00 $20.00 3 30.00 20.00 $30.00 4 20.00 $20.00 5 20.00 $20.00 Help as always, is greatly appreciated. -- Regards Michael Koerner |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Item Count vs Item Cost
Michael Koerner wrote:
I would like to put the cost of an item in a cell and have the sum of the costs in a cell to the right but at the top of the column I would like to have a total item count for all the items in that column would look something like this, with Col A items worth $15.00, Col B $10.00 and so on. A B C D E F G 3 1 5 1 15.00 10.00 20.00 $55.00 2 20.00 $20.00 3 30.00 20.00 $30.00 4 20.00 $20.00 5 20.00 $20.00 Help as always, is greatly appreciated. If I read you right, something like this? A 1 =SUM(A2:A6)/15 2 15.00 3 4 30.00 5 6 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Item Count vs Item Cost
Arrrrrrrrgh! I came up with the same solution at 03:00 am this morning. You
don't want to know how may days I have been thinking about this thing. thanks for confirming. -- Regards Michael Koerner "smartin" wrote in message ... Michael Koerner wrote: I would like to put the cost of an item in a cell and have the sum of the costs in a cell to the right but at the top of the column I would like to have a total item count for all the items in that column would look something like this, with Col A items worth $15.00, Col B $10.00 and so on. A B C D E F G 3 1 5 1 15.00 10.00 20.00 $55.00 2 20.00 $20.00 3 30.00 20.00 $30.00 4 20.00 $20.00 5 20.00 $20.00 Help as always, is greatly appreciated. If I read you right, something like this? A 1 =SUM(A2:A6)/15 2 15.00 3 4 30.00 5 6 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to ask for a item# and then show all details for that item | Excel Discussion (Misc queries) | |||
To find rate of each item from item.xls and to copy price.xls | Excel Discussion (Misc queries) | |||
Item numbers result in item description in next field in Excel | Excel Worksheet Functions | |||
How to display the first Item in a combobox as the default item | Excel Programming | |||
Pivot Item: removing non-existant item from the drop down | Excel Programming |