balancing checkbook - assigning categories - HELP

[d_run]

i need some help here. i know it's simple stuff compared to what you guys might deal with, but...

i want to see exactly how i spend all my money. so.. i paste my banking statement into excel, and then assign each expenditure to a category. i figure that i can do this by having an extra column called "Category" in which i can place pre-determined letters. For example, all transportation expenditures would be A's...

i need a formula or something that would add up each expediture based on the assigned letter. how do i do this?

view the image to get an idea of what i'm talking about. http://www.species.hxc.com/images/sample.jpg

any help is GREATLY appreciated.

david

[Smitty]

Welcome to the Board!

I think that SUMIF would do what you need.

Smitty

P.S. Your link doesn't seem to work. (It was "Forbidden"). Take a look at Colo's HTML Maker to post a shot of your sheet. You'll find the link at the bottom of the page.

[plettieri]

Hi:

Something like this migh do...

******** ******************** ************************************************************************>

Microsoft Excel - test55.xls ___Running: xl2002 XP : OS = Windows 98
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
F16F18F19F20F21F23 =
	E	F	G	H	I
6
7	Rent	44.78
8	Food	33.00
9	telephone	44.55
10	Travel	2.00
11	Food	3.00
12	telephone	3.00
13	Food	44.00
14	telephone	67.00
15	Travel	99.00
16		340.33
17
18	Rent	44.78
19	Food	80.00
20	telephone	114.55
21	Travel	101.00
22
23		340.33
24
25
26	'=SUMIF($E$7:$E$15,D26,$F$7:$F$15)
27
Sheet1

[HtmlMaker 2.32] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

hope this helps

plettieri

[d_run]

sorry about the link... i think you will be able to view it if you type it directly into a new window.

the SUMIF command sounds like it might work. but what if i have 20 or more categories? will i have a cell that will be filled with excessive amounts of code?

david

[plettieri]

Hi:

You might also consider a pivot table approach...


plettieri

[d_run]

what is that? i know i'm revealing my ignorance..

david[/quote]

[Smitty]

the SUMIF command sounds like it might work. but what if i have 20 or more categories? will i have a cell that will be filled with excessive amounts of code?

Not if you follow Plettieri's example.

For a Pivot Table, goto Dat-->Pivot Table and follow the wizard. Here's an overview from the Help File:

A PivotTable report is an interactive table that you can use to quickly summarize large amounts of data. You can rotate its rows and columns to see different summaries of the source data, filter the data by displaying different pages, or display the details for areas of interest.

When to use a PivotTable report: Use a PivotTable report when you want to compare related totals, especially when you have a long list of figures to summarize and you want to compare several facts about each figure. Use PivotTable reports when you want Microsoft Excel to do the sorting, subtotaling, and totaling for you.

Hope that helps,

Smitty

[d_run]

guys...

thanks so much for the help. i'll look into this in the next day or so.. and you might see me posting more questions at that point.

peace...

david

[plettieri]

Hi:

In addition to Pennysavers great explaination on Pivot table (PT) you might find the search help on this forum extremely helpful and with plenty of examples.

Search on Pivot table.


hope this helps
plettieri

[d_run]

the sumif command did exactly what i wanted it to. thanks for the nfo.

david