Autoupdate Formula Based On Recent Date

[SamuraiSam83]

I have setup a logbook to track daily stock profits. I would like to create a formula that automatically updates the Current Balance value, based on the most recent date. I don't have very much knowledge about programming, so I don't know if this is even possible to do. I also apologize if this is already a topic, but could not find the answer. I do not know what search terms I would use to find the answer to this.

I have uploaded screenshots of my logbook on my website here:

Home

 

[bbott]

Welcome to the board. Try:

=SUM(INDEX(D:D,MATCH(9.9E+307,D:D,1)-2):INDEX(D:D,MATCH(9.9E+307,D:D,1)))

 

[SamuraiSam83]

Wow, that was a fast response, and that coding worked exactly how I need it to.


Thank You,
SamuraiSam83

 

[bbott]

Wow, that was a fast response, and that coding worked exactly how I need it to.


Thank You,
SamuraiSam83

You're welcome.