+ Reply to Thread
Results 1 to 4 of 4

Running total for 15 accounts (managed on one spreadsheet)

  1. #1
    Registered User
    Join Date
    01-13-2017
    Location
    Denver, Colorado
    MS-Off Ver
    2013
    Posts
    2

    Question Running total for 15 accounts (managed on one spreadsheet)

    Hello Excel Geniuses!
    Please see the simple scenario below to see some backstory to what I need help with!

    First, lets pretend that online banking doesn't exist so I need an excel spreadsheet that can help track multiple running totals.
    Then, lets say that i have 15 grandchildren, so i opened 15 bank accounts - each account is named with one of my grandchildren's names.

    I deposited $1000 in each account as they opened.
    My grandkids can withdrawl from the account as they please, but i'd like to know when they are getting close to $0.
    Everyday, I log data on ONE excel spreadsheet which grandchildren withdrew from their account.

    Is there a way for me to keep a running total of how much is left in each account?
    So if "Joe" withdrew $250 from his account on day one,
    "Sarah" withdrew $10 from her account on day two,
    "Alexa" withdrew $100 from her account on day six,
    and "Joe" withdrew $50 from his account on day seven -- I will know that Joe only has $700 remaining?

  2. #2
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: Running total for 15 accounts (managed on one spreadsheet)

    You'll want to use SUMIF. Something like:

    =1000-SUMIF(NameRange,"Joe",WithdrawalAmountRange)

    EDIT: Here's a sample table to show how it could work:
    Attached Files Attached Files
    Last edited by CAntosh; 01-13-2017 at 05:40 PM.

  3. #3
    Registered User
    Join Date
    10-20-2020
    Location
    Texas
    MS-Off Ver
    16
    Posts
    1

    Cool Re: Running total for 15 accounts (managed on one spreadsheet)

    Can I get a sample of this document with formulas? I am trying to do something similar for my job.

    Thanks

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,423

    Re: Running total for 15 accounts (managed on one spreadsheet)

    Hello tdavenp1 and Welcome to Excel Forum.
    You should be able to download the .xlsx file from post #2, however if you have questions about the file and/or formula then we ask that you start a new thread and make mention of the file/formula in this thread.
    I hope that you have a blessed day.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Formula to return total of sub-accounts to the main account
    By shtuamouth in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 06-27-2016, 04:11 PM
  2. [SOLVED] Running balance for accounts payable data
    By karstens in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-27-2015, 12:21 PM
  3. [SOLVED] How to do a running total of different accounts in a table
    By flapface in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-16-2014, 02:13 PM
  4. Array function to allocate total across accounts based on prioritization
    By lpcapital in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-29-2013, 04:56 PM
  5. Replies: 1
    Last Post: 07-08-2013, 05:28 PM
  6. Excel 2008 : Running Total of different accounts
    By jonpackbosoxfan in forum Excel General
    Replies: 2
    Last Post: 02-08-2012, 03:16 AM
  7. [SOLVED] How to stop running total on excel spreadsheet
    By RC in forum Excel General
    Replies: 2
    Last Post: 04-21-2005, 09:07 PM

Tags for this Thread

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