WD2000: SUM Formula Does Not Update Correctly (212070)

SYMPTOMS

The SUM formula field may update incorrectly if text exists in a cell of a row or column when using one of the following predefined formula fields:

{ =SUM(LEFT) }

{ =SUM(RIGHT) }

{ =SUM(BELOW) }

{ =SUM(ABOVE) }

For example, in the following table

1	2	3	{ =SUM(LEFT) }
1	2	Text	{ =SUM(LEFT) }
1	Text	3	{ =SUM(LEFT) }

the calculation field result in the first and second rows updates correctly. However, if text is in a cell that splits the values that are being calculated, the calculation updates incorrectly. For example, the third row produces an incorrect result, as shown in the table below.

1	2	3	6
1	2	Text	3
1	Text	3	3

{=sum(a1:c1)}
				

{=sum(a1,b1,c1)}