1. Registered User
Join Date
Sep 2003
Posts
2

Good Afternoon
I am looking for someone to help me with setting up summing totals in my budget spreadsheet. I have a column for:

Starting Balance
Category Debit Credit Total 100.00
ATM 10.00 90.00
dinner 40.00 50.00
ATM 10.00 40.00
dinner 10.00 30.00
gas 15.00 15.00

Now how do I automatically at the end of the month group these together and get a total for; ATM, Dinner, Gas...
I have already started playing with the pie chart to show where my money goes, but I would like to have it calculate each category as we go through the month. I hope that you can understand and someone can help.

Thank you

2. Registered User
Join Date
Sep 2003
Location
Cincinnati, Oh USA
Posts
203
Use the "SumIf" Function: Assuming that all entries are made in two columns (Item [A] and Charge [B]) it would go something like this:
=SumIf(A1:A20,"Dinner",B1:B20) This formula will look into column A rows 1-20 for the word "Dinner" and return from Column B rows 1-20 the corresponding value.

3. Registered User
Join Date
Sep 2003
Posts
2

## Thanks

That worked Great thanks for the help!

Originally posted by RickKnight
Use the "SumIf" Function: Assuming that all entries are made in two columns (Item [A] and Charge [B]) it would go something like this:
=SumIf(A1:A20,"Dinner",B1:B20) This formula will look into column A rows 1-20 for the word "Dinner" and return from Column B rows 1-20 the corresponding value.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•