Formula In Table

[Earl Partridge]

Word 97, Windows XP
Created a table with numbers in columns. On the bottom row of each column, set the
formula to be =sum(c2:c25)
This worked fine.
I changed the formula to be: =sum(above)
This formula works in other tables where that was the original formula.
I do have some blank cells.
Example, rows 2 - 15 had numbers, rows 16 - 20 were blank, row 21 had a number.

Using =sum(above) in the bottom row returned only the value of the number in row 21.
For now, I have changed back to specifying the exact row number vs "above"

Earl

 

[Doug Robbins - Word MVP]

As you have discovered, =Sum(Above) cannot handle blank rows.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

Word 97, Windows XP
Created a table with numbers in columns. On the bottom row of each column, set the
formula to be =sum(c2:c25)
This worked fine.
I changed the formula to be: =sum(above)
This formula works in other tables where that was the original formula.
I do have some blank cells.
Example, rows 2 - 15 had numbers, rows 16 - 20 were blank, row 21 had a number.

Using =sum(above) in the bottom row returned only the value of the number in row 21.
For now, I have changed back to specifying the exact row number vs "above"

Earl