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
Contact Forum Editor

Send an email to our Forum Editor:


PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom


It's free to register, to post a question or to start / join a discussion


 

Word Table Sum of the contents


tonyq
Resolved

Likes # 0

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!

Like this post
VoG II

Likes # 0

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

Like this post
Peter

Likes # 0

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.

Like this post
tonyq

Likes # 0

Thank you both,for your help.

Like this post  

Reply to this topic

This thread has been locked.



IDG UK Sites

LG G Watch R video review: The most desirable Android Wear smartwatch

IDG UK Sites

Apple's 2014 highlights: the most significant Apple news of 2014

IDG UK Sites

2015 creative trends: leading designers & artists reveal the biggest influences & changes coming th)......

IDG UK Sites

Ultimate iOS 8 Tips: 35 awesome and advanced tips for using iOS 8 on iPhone and iPad