Word Table Sum of the contents

  tonyq 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 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 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 30 Jun 11
Answer

Thank you both,for your help.

Advertisement

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

Should I upgrade to Windows 10? 8 reasons why you should upgrade to Windows 10... and 2 why you…

We are being sold the ability to spend money we don't have. And we love it

Encore creates eerie effects for Spielberg's new TV show The Whispers

How to use Apple Music in the UK: Complete guide to Apple Music's features

We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message