How do I tally numbers, of a specific expense category?

[The Ambassador]

I have all my expenses for 2009 listed in date order. I have assigned each
one an expense category using a drop-down based on the "data validation"
tool. Is there an easy way to tally up the total expenses for each category?

 

[Dave Peterson]

You could sort your data (all the columns) by the category column.

Then use data|subtotals (in xl2003 menus).

Then use the outlining symbols to the left to hide/show details.

If you're really industrious, you could learn about pivottables.

If you've never used pivottables, here are a few links:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx

 

[Bernard Liengme]

SUMIF will work but that mean you must make a list of categories
Pivot table would be ideal but will take you a few minutes to lean how to do
it

http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
http://www.techonthenet.com/excel/pivottbls/index.htm
http://www.dicks-blog.com/archives/2005/06/23/download-pivottable-parameters/

best wishes

 

[ryguy7272]

Sounds like a job for a Pivot Table:
http://peltiertech.com/Excel/Pivots/pivottables.ht
http://www.babeled.com/2008/07/18/excel-pivot-table-tutorial-wizard-usage-and-basic-manipulation/