[NCC]

If you have a table with 3 columns or more and ONLY 3 rows, you can try this
to replicate the bug:

Qty Unit Cost Total
1 2.00 2.00
---merged field--- {sum(above)}

You will realize that you will get a total of 5, instead of 2.

However, if you add in another row like this:

Qty Unit Cost Total
1 2.00 2.00
2 3.00 6.00
---merged field--- {sum(above)}

You will get a total of 8.00, which is correct.

This problem occurs if the first row is a text row, second row with some
alpha numeric values, and third row is a merged columns while trying to sum
the above cell.

If you have two or more than numeric rows above the {=sum(above)}, it will
never occurs.

When can Micorsoft offers a patch for this? Other Office suit version has no
such problem.

Thanks

NCC

[Herb Tyson [MVP]]

I'm not seeing the same thing here, but I do see a summation error. Here, my
sum is 4, not 5, in those circumstances. So, here, at least, it's picking up
only the 2 from unit cost, not the 1 from Qty.

BUT... I see the identical behavior in Word 2003. I no longer have Word 2002
and earlier installed, so I can't verify whether it was a problem
previously.

If the the two cells in the lower left corner aren't merged, as you've
discovered, the error doesn't occur.

--
Herb Tyson MS MVP
http://www.herbtyson.com
Author of the Word 2007 Bible
Please respond in the newsgroups so everyone can follow along.
"NCC" wrote in message
...
If you have a table with 3 columns or more and ONLY 3 rows, you can try
this
to replicate the bug:

Qty Unit Cost Total
1 2.00 2.00
---merged field--- {sum(above)}

You will realize that you will get a total of 5, instead of 2.

However, if you add in another row like this:

Qty Unit Cost Total
1 2.00 2.00
2 3.00 6.00
---merged field--- {sum(above)}

You will get a total of 8.00, which is correct.

This problem occurs if the first row is a text row, second row with some
alpha numeric values, and third row is a merged columns while trying to
sum
the above cell.

If you have two or more than numeric rows above the {=sum(above)}, it will
never occurs.

When can Micorsoft offers a patch for this? Other Office suit version has
no
such problem.

Thanks

NCC