Home 
Search 
Today's Posts 
#1




Sum Above table with merged cells in Word 2003
I have a table, row one has more cells than row two. Row
two has 5 cells, row one has 12 cells. The last col of row one holds numbers I would like to sum. Cell 5 of row two is lined up with cell 12 of row one. I put sum above in cell 5 of second row but the sum above seems to be adding all numbers together from cells 5 onwards in row 1. For example, row one, cell 5 contains a date 25mar 05, and row one cell 7 contains text and a number Staff: 1. Row one cell 12 contains an amount 100.00. The sum above adds 100 + 25 + 05 + 1 which totals 131!! Any ideas anyone  by the way, it works ok in Word 2000 
#2




Hi Lynn
Wish I had an answer, but instead I just have a question. When you refer to it works ok in Word 2000, are you sure the summing wasn't done _before_ the table was restructured? I've never had any luck inserting functions in tables where merged cells were involved. The calc fields have also lost their reliability to update accurately even if the merging took place after the (originally successful) function was inserted. TIA :) "Lynn Taylor" wrote: I have a table, row one has more cells than row two. Row two has 5 cells, row one has 12 cells. The last col of row one holds numbers I would like to sum. Cell 5 of row two is lined up with cell 12 of row one. I put sum above in cell 5 of second row but the sum above seems to be adding all numbers together from cells 5 onwards in row 1. For example, row one, cell 5 contains a date 25mar 05, and row one cell 7 contains text and a number Staff: 1. Row one cell 12 contains an amount 100.00. The sum above adds 100 + 25 + 05 + 1 which totals 131!! Any ideas anyone  by the way, it works ok in Word 2000 
#3




Hi Lynn,
You may find the information here useful: http://word.mvps.org/faqs/apperrors/...eIncorrect.htm to possibly use the Table Cell Helper to identify the id's of the cells you want to add in your =sum(... formula. 'Above' visually may not be the same as 'Above' to Word logically ========= "Lynn Taylor" wrote in message ... I have a table, row one has more cells than row two. Row two has 5 cells, row one has 12 cells. The last col of row one holds numbers I would like to sum. Cell 5 of row two is lined up with cell 12 of row one. I put sum above in cell 5 of second row but the sum above seems to be adding all numbers together from cells 5 onwards in row 1. For example, row one, cell 5 contains a date 25mar 05, and row one cell 7 contains text and a number Staff: 1. Row one cell 12 contains an amount 100.00. The sum above adds 100 + 25 + 05 + 1 which totals 131!! Any ideas anyone  by the way, it works ok in Word 2000  Let us know if this helped you, Bob Buckland ?:) MS Office System Products MVP *Courtesy is not expensive and can pay big dividends* Office 2003 Editions explained http://www.microsoft.com/uk/office/editions.mspx 
Reply 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Forum  
How to Avoid Word 2003 Table Style Problems  Tables  
Word 2003 table style confusion  Tables  
how to convert wordperfect 5.0 floppy files to word  Microsoft Word Help  
Excel worksheet in Word linked text boxes  Page Layout  
macro in word  Microsoft Word Help 