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

  • Thread starter Thread starter The Ambassador
  • Start date Start date
T

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make different cells fill in automatically from one entry? 3
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
Tally function assistance 4
I want to tally my sheet 6
Multiple Columns for SUMIF formula?!?! 2
summing line items by category 2
Can Excel Data be simultaneously entered in seperate category list 1
expenses spreadsheet questions 1

Back
Top