Item Count vs Item Cost

[Michael Koerner]

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.

 

[smartin]

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

 

[Michael Koerner]

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

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