Horses for courses. You're using a wordprocessor to do spreadsheeting. There
are ways you could do this in Word, but none of them straightforward. On the
other hand, using Excel, or an Excel range embedded in your document, you
wouldn't have the problem at all.




"Mango" wrote in message
news
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?