View Single Post
  #2   Report Post  
Posted to microsoft.public.word.tables
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Formula In Table

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

"Earl Partridge" wrote in message ...
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