sum(above) Bug in Word 2007 Table

N

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
 
H

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top