View Single Post
  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

oTry a pivot table, it will give you this, in the layout drag the category
header in the row field and the price to the data field


http://peltiertech.com/Excel/Pivots/pivotstart.htm



Regards,

Peo Sjoblom

"BLW" wrote:

I need help writing a macro that will look down the first column and will add
up the prices of whatever rows that have the same category.

Example:
category product price
pets horse 100
pets dog 50
food banana .50
food hamburger 1.50

pets subtotal: 150
food subtotal: 2.00

Thank you very much.

BLW