Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
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 |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help me with a formula in Table | Tables | |||
Table formula? | Microsoft Word Help | |||
Table Formula | Tables | |||
Table Formula Help | Tables | |||
formula in a table | Microsoft Word Help |