I have created a column that calculates the running total, and i would like
Excel to use only the last value in the list. however, when a new value is
added to the bottom of the list, excel will then take that entry.

Can anybody help. Thanks