I have all my expenses listed by date order for 2009. I categorized them
using a "Data Validation" list. Now I want to get totals for each category.
How do I do this?

Without seeing your WB I would suggest to Filter-Out whatever needed category
and calculate its sum with SUBTOTAL.
Micky


"The Ambassador" wrote:

I have all my expenses listed by date order for 2009. I categorized them
using a "Data Validation" list. Now I want to get totals for each category.
How do I do this?

Hi

Assuming you have headings in row 1 like Date, Category and Value
Place cursor in A1DataPivot TableFinish
On the PT skeleton that appears on a new sheet
Drag Category to the Row area
Drag Value to the Data area as Sum of Value

If you want to Summarise by Date as well, than drag Date to the Row area as
well
Right click on the first of the Date cellsGroup and OutlineGroupSelect
MonthOK
You can then drag the Month label to the Column area and see the 12 months
across the page.

For more help on Pivot Tables take a look here
http://www.contextures.com/xlPivot07.html
--
Regards
Roger Govier

"The Ambassador" wrote in message
...
I have all my expenses listed by date order for 2009. I categorized them
using a "Data Validation" list. Now I want to get totals for each
category.
How do I do this?

__________ Information from ESET Smart Security, version of virus
signature database 4743 (20100104) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4743 (20100104) __________

The message was checked by ESET Smart Security.

http://www.eset.com