View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Koerner Michael Koerner is offline
external usenet poster
 
Posts: 164
Default 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