WD97: Incorrect Formula Results Using ABOVE, BELOW, LEFT, RIGHT

   |------------------|
   |               3  | <(Cell A1)
   |------------------|
   |                  | <(Cell A2)
   |------------------|
   |               4  | <(Cell A3)
   |------------------|
   |                  | <(Cell A4)
   |------------------|
   |               5  | <(Cell A5)
   |------------------|
   |   {=SUM(ABOVE)}  | <(Cell A6)
   |------------------|
				

WORKAROUND

To work around this problem, use either of the following methods.

Method 1: Type Zero (0) in Any Blank Cells

Type zero (0) in any blank cells included within the calculation range, for example:

   |------------------|
   |               3  | <(Cell A1)
   |------------------|
   |               0  | <(Cell A2)
   |------------------|
   |               4  | <(Cell A3)
   |------------------|
   |               0  | <(Cell A4)
   |------------------|
   |               5  | <(Cell A5)
   |------------------|
   |   {=SUM(ABOVE)}  | <(Cell A6)
   |------------------|
				

Method 2: Use Cell References

For a range that contains one or more blank cells, use cell references to define the range instead of ABOVE, BELOW, LEFT, or RIGHT. For example, use the following formula field to obtain a correct result:

   |------------------|
   |               3  | <(Cell A1)
   |------------------|
   |                  | <(Cell A2)
   |------------------|
   |               4  | <(Cell A3)
   |------------------|
   |                  | <(Cell A4)
   |------------------|
   |               5  | <(Cell A5)
   |------------------|
   |   {=SUM(A1:A5)}  | <(Cell A6)
   |------------------|