Item Count vs Item Cost

M

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.
 
S

smartin

Michael said:
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
 
M

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


Michael said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top