C
Charles Kenyon
Hi,
I've just discovered yet another reason for me to hate table math formulae
in Word.
I have a table with four columns in every row except the last row, which has
three, merging columns 1 & 2. The last two columns have figures in them in
every row except the last one where there is a formula to SUM(ABOVE) in
those columns. The first formula correctly sums the totals in its column.
The second (identical) formula sums the totals in both columns! That is, it
gives a total of the numbers in Column 3 and Column 4.
1 5
3 0
7 4
-- --
11 20
This is in Word 2002.
I fixed it by splitting the first cell in that row again (so all rows have 4
columns) but it is a puzzlement. Any other quirks I should know about? (I
know you can't have empty cells or text interrupting columns of figures.)
--
Charles Kenyon
Word New User FAQ & Web Directory:
<URL: http://addbalance.com/word/index.htm>
Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide)
<URL: http://addbalance.com/usersguide/index.htm>
See also the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.
I've just discovered yet another reason for me to hate table math formulae
in Word.
I have a table with four columns in every row except the last row, which has
three, merging columns 1 & 2. The last two columns have figures in them in
every row except the last one where there is a formula to SUM(ABOVE) in
those columns. The first formula correctly sums the totals in its column.
The second (identical) formula sums the totals in both columns! That is, it
gives a total of the numbers in Column 3 and Column 4.
1 5
3 0
7 4
-- --
11 20
This is in Word 2002.
I fixed it by splitting the first cell in that row again (so all rows have 4
columns) but it is a puzzlement. Any other quirks I should know about? (I
know you can't have empty cells or text interrupting columns of figures.)
--
Charles Kenyon
Word New User FAQ & Web Directory:
<URL: http://addbalance.com/word/index.htm>
Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide)
<URL: http://addbalance.com/usersguide/index.htm>
See also the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.