Formula In Table
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
|