summing line items by category

[The Ambassador]

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

 

[Roger Govier]

Hi

Assuming you have headings in row 1 like Date, Category and Value
Place cursor in A1>Data>Pivot Table>Finish
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 cells>Group and Outline>Group>Select
Month>OK
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

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