Sub totals within an expenses worksheet

  • Thread starter Thread starter rushd45
  • Start date Start date
R

rushd45

Hi,

I am building a house and have created a spreadsheet giving a running total
of the $$ spent for categories of the house construction (Grading, Septic,
Water, Elec, Fence, Tools, Foundation, etc....) How can I make subtotals for
the different categories with out making a different spreadsheet for each
category. I have made a pull down list of the categories.

Thanks
Rush
 
If you place your categories in the same column, you could sort your data by
that column and then Data|subtotals.

But you may want to take a look at Data|Pivottable. Your data doesn't need to
be sorted.

If you want to learn more about pivottables, here are a few links.

Debra Dalgleish's pictures at Jon Peltier's site:
http://www.geocities.com/jonpeltier/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
 
Back
Top