Check out the features of Pivot Tables.

For very good assistance see Debra Dalgleish's site.

http://www.contextures.on.ca/tiptech.html

See help under the "P" section.

For your particular need maybe

http://www.contextures.com/excel-piv...subtotals.html


Gord Dibben Microsoft Excel MVP

On Thu, 8 Sep 2011 14:25:36 -0700 (PDT), trvlnmny
wrote:

I am working with Excel 2003 and W Vista.
I have a spread sheet that contains 5 columns. One column contains
Amounts Spent. Another column contains a one word category of what the
amount was spent on such as fuel, dining etc.
The spreadsheet is in order of the date of the expenditure. Someplace
at the bottom I would like to be able to show sub totals based on the
category.
Thank you for any and all help.