Subtotal at change in each Category?

KKD wrote:
I want to have a cell that is calculating all costs in a particular category.
The data is laid out in rows, so I will have the following columns:

Date Vendor Category Amount

I want a cell that is adding all amounts that are listed as a particular
category. One category might be "Events", another "Operations", etc. I want
these totals to be separated per category.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200905/1