I created a table that has columns to which I add values periodically. At
the bottom of each column, I created formulas for adding the above cells
together. For example: =SUM(C2:C49), where the sum is displayed in cell C50.
When I add new data to the column, I click in cell C50 and press F9 to revise
the total. The problem is the old total gets added to the new total, so that
all previous cells are added twice, making the F9 function useless. If I
delete the number in cell C50, the formula gets deleted as well. Is there a
different way I need to write the formula in order that only the new values
will be added to the previous total?