Word Table Sum of the contents

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

Thank you both,for your help.

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

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

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

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…