Formula to update balance totals?

[maurerjl]

Is there a formula that will update my monthly balance total with the last line of data in the balance sheet? I.e. if John Doe makes a payment on 8/12 and the balance increases, is there a formula that will replace the current monthly total with the new balance?

Currently, I am just =SUM(G#) the last line, but the monthly total auto-fills a 12-month cash-flow sheet- so if I forget to update the balances, my cash-flow will be off.

Suggestions?

[JohnTopley]

try in GŁ

=INDEX(G5:G60,MATCH(9.99999999999999E+307,G5:G60))

in G62 put =GŁ

[maurerjl]

Awesome, that worked. Thank you! Now I just have to update every balance sheet for each item for every month! Haha. Oh, boy!

[Tony Valko]

=INDEX(G5:G60,MATCH(9.99999999999999E+307,G5:G60))

This one's a few keystrokes shorter...

=LOOKUP(1E100,G5:G60)