Running totals in upside down table

[jomili]

See the attached for a better understanding.
In my Bank I have a checking account, a savings account, and a Money Market account.

I have one table to keep track of all three accounts.

The beginning balances are at the bottom.
At the top I have my current balances.

Along the side of my TABLE, in column H, I have a running balance formula like so:

Please Login or Register  to view this content.

This formula works, but it's not a TABLE formula, so when I have to expand my table I have to doublecheck my running total formula to ensure it's still tracking correctly.

So, what I'd like is a TABLE formula that will do what my current formula does, plus automatically adapt to new TABLE dimensions, but I can't figure out how to do that, and I know for a fact that there are sharper crayons in the ExcelForum box, so I'm appealing to you.

If you can help me, thanks and Merry Christmas!
If you can't help me, i still wish you a Merry Christmas!

Thanks!

[TMS]

This:

Please Login or Register  to view this content.

[TMS]

If you wanted a running total:

Please Login or Register  to view this content.

[jomili]

TMS,
Both of these formulas depend on the D509 staying constant, but that row will change as I continually add rows to my TABLE. That was why I specified I was looking for a TABLE formula.

[djclements]

If you want the "Balance" formula to be entered as a calculated column within the table, you could toggle the Total Row on first (Ctrl+Shift+T), then use it as the anchor point for the expanding range reference:

Please Login or Register  to view this content.

With the Total Row toggled off, you could also use the TAKE function to reference the last row in each column:

Please Login or Register  to view this content.

Alternatively, you could also try the following dynamic array formula to spill the reversed running totals alongside the table:

Please Login or Register  to view this content.

A complete explanation of the last method can be found here: https://stackoverflow.com/a/79228977

See attached, if needed...

[jomili]

djclements,
This is awesome. Not one, not two, but three workable solutions. That's over and above! Thanks so much!

Merry Christmas!

[djclements]

You’re very welcome, and Merry Christmas to you and yours as well!

[TMS]

@jomili: Thanks for the rep.