Yeah, I had the same idea, and actually tried to build the table in Excel,
but there are graphic aspects of the table that were hard to translate into
Excel, not to mention that I already have many of these tables configured in
Word already, one for each client. So you don't think there's a Word formula?
How does one embed an Excel range in one's document?

"Jezebel" wrote:

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?