Reply
 
Thread Tools Display Modes
  #1   Report Post  
Lynn Taylor
 
Posts: n/a
Default 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 25-mar-
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   Report Post  
CyberTaz
 
Posts: n/a
Default

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 25-mar-
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   Report Post  
Bob Buckland ?:-\)
 
Posts: n/a
Default

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 25-mar-
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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Avoid Word 2003 Table Style Problems Judy Haynes Tables 0 March 23rd 05 06:41 PM
Word 2003 table style confusion Coder Droid Tables 4 February 18th 05 06:05 PM
how to convert wordperfect 5.0 floppy files to word pcoelho Microsoft Word Help 2 February 17th 05 06:55 PM
Excel worksheet in Word linked text boxes Eduardo Oliveira Page Layout 0 January 5th 05 11:23 PM
macro in word js Microsoft Word Help 1 December 28th 04 03:01 AM


All times are GMT +1. The time now is 11:42 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"