Field Formula doubles total

[Diana]

I have an accounting form which uses a table with numeric
fields in three columns and calculated fields in a 4th
column which add up the first three columns, and a row at
the bottom of the table which adds up the fields in the
rows above. Lastly, I have one cell on the bottom right
of the table which should add up the total rows. I have
tried adding up the total row cells by using =sum(left)
and I've also tried bookmarking the cells to be added and
using a formula that states =(bookmark1 + bookmark2 +
bookmark3) but no matter how I do it, I get a doubled
amount of what the total should be.

It seems as if it is totaling the cells to the left and
the cells above, but I have no reference to the cells
above in the formula. Does anyone know why this is
happening?

 

[Diana]

I have solved the problem and, as it turns out, there is
nothing wrong with the Word table or formulas. I was
given the problem table by one of my users and I could
not get the table to work correctly. After a while, I
wondered if perhaps she had copied or translated the
table from a WordPerfect document since we use both word
processors in our office. As it turns out, that is
exactly what had happened! We recreated the table from
scratch in Word and it works fine!

Diana