MS EXCEL Budget

Reply

  #1  
Old 11-25-08, 09:21 AM
kolias's Avatar
Member
Thread Starter
Join Date: Jul 2004
Location: Canada
Posts: 1,357
Received 1 Vote on 1 Post
MS EXCEL Budget

I have this Excel spreadsheet where I keep an eye on my budget.

Column A is the description of the transaction, Column B is the expenses amount I pay and itís always a negative value, Column C is the income amounts going into the account and Column D is the balance.

Column D has this formula to update the balance: =IF(C377=0,D376+B377,D376+C377)

I would like to keep a track on individual expenses like Car expenses, Food, Entertainment etc., but I donít want to add columns for each category since this will make the spreadsheet too large to fit on a Laptop screen.

I wonder if there is a way to add a formula in column B which will recognize a word from column A like FOOD. In this case, if column A contains lets say the key word FOOD, the formula will leave the amount in column B but will also copy it to another cell (same or different spreadsheet) where I will have a table with columns for each category.

Any other ideas?

Thanks
 
Sponsored Links
  #2  
Old 11-25-08, 04:14 PM
Praxius's Avatar
Member
Join Date: Feb 2004
Location: Central CT
Posts: 121
Received 0 Votes on 0 Posts
I do not know if you can do what you want with a formula or not, but what I do is to just sort the column.

Highlight column A, B, C and D and hit the sort AZ button. As long as you title the transactions the same they will be grouped together after the sort.

You will first have to copy the columns and use "paste special" to paste the "values" into a new worksheet or area.

Hope this makes sense.
 

Last edited by Praxius; 11-25-08 at 04:27 PM. Reason: not enough info
  #3  
Old 11-25-08, 05:26 PM
kolias's Avatar
Member
Thread Starter
Join Date: Jul 2004
Location: Canada
Posts: 1,357
Received 1 Vote on 1 Post
That is one way of achieving what I want but I'm hopping for a more automated method.

Perhaps someone knows what I want, lets wait...

Thanks for your time
 
  #4  
Old 11-25-08, 09:56 PM
Member
Join Date: Feb 2008
Location: Canada
Posts: 188
Received 0 Votes on 0 Posts
Originally Posted by kolias View Post
I have this Excel spreadsheet where I keep an eye on my budget.

Column A is the description of the transaction, Column B is the expenses amount I pay and it’s always a negative value, Column C is the income amounts going into the account and Column D is the balance.

Column D has this formula to update the balance: =IF(C377=0,D376+B377,D376+C377)

I would like to keep a track on individual expenses like Car expenses, Food, Entertainment etc., but I don’t want to add columns for each category since this will make the spreadsheet too large to fit on a Laptop screen.

I wonder if there is a way to add a formula in column B which will recognize a word from column A like FOOD. In this case, if column A contains lets say the key word FOOD, the formula will leave the amount in column B but will also copy it to another cell (same or different spreadsheet) where I will have a table with columns for each category.

Any other ideas?

Thanks
I believe this is what you want. You can download the excel file by clicking on the link. It basically does a bank balance as well as a running total of the items like food in another column. This is achieved by using the sumif function.

http://www.mediafire.com/?sharekey=1...db6fb9a8902bda
 
  #5  
Old 11-26-08, 05:35 PM
kolias's Avatar
Member
Thread Starter
Join Date: Jul 2004
Location: Canada
Posts: 1,357
Received 1 Vote on 1 Post
I was not aware of the SUMIF function. I was trying to do something similar with the VLOOKUP, LOOKUP or OFFSET Functions.

It seems that your suggestion is working and is very simple.

Thank you for taking the time to reply
 
Reply

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread
 
Ask a Question
Question Title:
Description:
Your question will be posted in: