Word Table Sum of the contents

  tonyq 16:25 PM 30 Jun 11
Locked
Answered

Is it possible to find what the Sum of the contents of a colume in Word 2007 add up to,like you can in Excel, when some of the cells in the columns have no contents. I hope this makes sense to you!

  VoG II 17:24 PM 30 Jun 11

Add a row to the bottom of the table.

Click in that new row.

Press CTRL + F9

This should appear: { }

Inside those curly brackets type

=SUM(ABOVE)

Press F9

  Peter 17:47 PM 30 Jun 11

tonyq,

If you use the option, from the Table drop-down menu, to insert a Formula and choose =SUM(ABOVE) the total will be displayed in the cell containing the formula, but only until an empty cell is encountered. You can alter the formula to =SUM(C2:C7), where C is the third column of the table and Row 2 to 7 contain the cells to be summed. It won't matter if they contain numbers or are empty and you can even have the total in a different column or row. Use Alt-F9 to toggle the cell between Formula and Result and use F9 to update the Result.

Peter.

  tonyq 18:18 PM 30 Jun 11
Answer

Thank you both,for your help.

Advertisement

This thread is now locked and can not be replied to.

How to watch Sony Xperia Z5 launch live: Sony Xperia Z5 live video stream from IFA 2015 - watch…

1995-2015: How technology has changed the world in 20 years

How Google's new logo was redesigned

What to expect at the September Apple event: Apple announces 9 September event, sends out invites