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?

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?

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?

Select it in Excel, copy, switch to Word, PasteSpecial. Excel's formatting
isn't quite up to Word's, but unless you're doing something unusual you
should be able to format it to match the Word original.

There's no simple Word formula for this; you'd need to use some macro
code -- which introduces more complexities and risk. Sooner or later you'll
wish you hadn't tried that approach.



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