Using SUM in Word 2003

[arefem]

I have a table in Word 2003 for generating my invoices. Usually invoices are
presented covering 4 or more weeks. However, I have one invice to present
which is only for 2hrs work, so I reduced the number of rows accordingly.

The table is four rows deep and four columns wide.

The 4 cells in row 1 have been merged into one, and are used to describe the
contract.

Row 2 contains text headers for the next row (W/c, Hours, Rate), the final
one is blank)

Row 3, Cell 1 is text (usually the W/C date), Cell 2 the number of hours,
Cell 3 the hourly rate, cell 4 the product of cell2*Cell3

Cells 1-3 of the final row are merged and contain text. Cell 4 contains
'=SUM(ABOVE)' formula, at least thats what I typed. Word adds \*
MERGEFORMAT to this and replaces it even when I delete it. (this does not
appear in the original multi-line invoice)

In this reduced table, the result of the final cell dows not calculate
properly. It adds together the value of the cell above (Row 3, Cell 4) and
the two cells to the left (R2,C3 and R3,C2). {adding another row to this
invoice and inserting a value results in a correct calculation, leaving it
blank results in an incorrect calculation}

Putting a zero in row 2 cell 4 also results in a correct calculation.

Why?

 

[CyberTaz]

My guess would be the merged cells - at least in part, but you've posted to
the Mac Word group Work from here for the PC Word groups:

http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx

Good Luck |:>)
Bob Jones
[MVP] Office:Mac