+ Reply to Thread
Results 1 to 6 of 6

Expenses Sheet

  1. #1
    Registered User
    Join Date
    08-27-2014
    Location
    Dallas, Texas
    MS-Off Ver
    Office 2013
    Posts
    14

    Expenses Sheet

    Hello, I'm just creating a simple expenses sheet to help keep up with all my money. I make a decent amount of money for my age, but I seem to lose it all and not sure where it all goes haha.

    I created a drop down menu for checking/savings and a column for money spent. I just want all the funds to subtract/add from the savings or checking total I created to the right of all the funds. If anyone could be please help me out with a code that could do this for me that would be great.

    Or if anyone has created anything that looks a lot better than mine that would be awesome too.
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,895

    Re: Expenses Sheet

    Look at my alternate set up for you. I think you will find this more meaningful as you track your expenses.

    Look at sheet 3
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    08-27-2014
    Location
    Dallas, Texas
    MS-Off Ver
    Office 2013
    Posts
    14

    Re: Expenses Sheet

    Hopefully my other posts don't show up since I don't think Quick Reply is working for me...

    But I like the one I set up, I appreciate you trying to help me out with it. I have it where it will change colors for positive/negative values.

    I'm just looking for a code that will do add/subtract and also include what the drop menu is doing

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,895

    Re: Expenses Sheet

    Ok. That works for me. In Cell E2, type =SUM($C$2:C2) and copy it down column E. This will give you a running balance. Assuming you will be entering expenses as negatives.

  5. #5
    Registered User
    Join Date
    08-27-2014
    Location
    Dallas, Texas
    MS-Off Ver
    Office 2013
    Posts
    14

    Re: Expenses Sheet

    Thanks! I got it to work using this =SUMIF(B2:B100,"Checking",C2:C100) and just changing it from checking to savings to help for savings.

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,895

    Re: Expenses Sheet

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Total Sheet to always add up certain persons expenses
    By Wombie2903 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2013, 09:37 AM
  2. Formula to show current week expenses on a different sheet
    By wiljar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-24-2013, 04:25 AM
  3. Replies: 3
    Last Post: 05-11-2006, 01:30 PM
  4. Looking for sheet for expenses and income
    By AA Arens in forum Excel General
    Replies: 1
    Last Post: 09-28-2005, 12:05 PM
  5. [SOLVED] spread sheet for medical expenses
    By currybjc in forum Excel General
    Replies: 0
    Last Post: 02-14-2005, 01:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1