Sum by category

[Nathan]

I am simply trying to create a budget worksheet. I have categorized
my checking spreadsheet with a column validation (Car, House,
Groceries, etc). I am trying to get my budget worksheet to total each
category, preferably by month. I can't figure out how to do this.
Any ideas would be appreciated. Thanks

 

[JE McGimpsey]

The best way will be to use a Pivot table, IMO.

If you're not familiar with PTs, see Debra Dalgleish's intro:

http://peltiertech.com/Excel/Pivots/pivottables.htm

 

[Frank Kabel]

Hi
I agree with JE: use a pivot table for this. Below some additional
resources:
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