Working with Tables: Checking Totals

Formulas are built right into Word, so you can check totals with a click! Errors love to lurk in tables, checking the numbers can make an editor look like a hero. Just click the Formula icon on the right edge of the (Table) Layout ribbon. But watch for the snafus (see Troubleshooting).

Troubleshooting

Address most of these issues by pasting the table into Excel and using its more sophisticated formula functions.

The “ABOVE” parameter stops at empty cells, as shown in the demo. It’s possible to specify a row range instead e.g., 3:11) but it’s unclear how Word numbers the rows.

Check out all the other posts in this series about Working with Tables and download your free multimedia ebook of them all!



Got a gnarly Word problem? Submit your problem and we’ll try to answer it in the new Q&A thread.


Never miss a Word-Wrangling Wednesday tip. Sign up here to get them by email.

Enter your email address:

Delivered by FeedBurner

By practicing one tip each week, you can invest 13 hours this year into professional development. To search the blog, use the orange bar right above this.


© This blog and all materials in it are copyright Adrienne Montgomerie on the date of publication. All rights reserved. No portion may be stored or distributed without express written permission. Asking is easy!


Share this post

Leave a Reply