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?
Bookmarks