How do I create a running balance that has the following criteria:
- It uses an array formula
- the rows don't need to be sorted by date, but running total only returns balance of:
- Rows with the same or earlier dates
- Rows with the same exact account name
- Balance accrues by Date, by Name. (i.e. it filters all results by one name and only adds AMT's whose date is the same or comes before)
I've created a check ledger, that accounts for deposits and withdrawals. here is a link to what I've been working on so far ( it has more columns than the picture below: because I've experimented with several solutions. )
WHAT I'VE TRIED: see google sheet
=ARRAYFORMULA(SUMIF($A$2:A,$A$2:A,$C$2:C))This only gives the current total ( not the running total for each account & it completely ignores the date column.
- Using an Array
=SORT(A2:C,2,TRUE)to populate duplicate columns of A through C except now they are sorted. Then adding the formula
=SUMIF($H$2:H2,H2,$J$2:J)Where column H is the sorted column of A & Column J is the sorted column C. Then copying that formula down to the rest of the column. Problem is, that it is not an Array. Although the result is closest to what I'm hoping to accomplish.
The sheet I "shared" publically originally had edit access to everything on it was changed. I did my best to repair and improve it for ease of understanding (i.e all $ amounts were changed to 1, Bold & Purple highlights areas where formulas exist)