Hi
It is possible to do this without a macro using SUMPRODUCT or SUMIF. If you
don't specifically need a macro, post back and we'll respond for you!

Andy.

"BLW" wrote in message
...
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