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.

a map "locator pin" styled as the MS Word logo

Check out all the other posts in this series about Working with Tables and learn all about them in the multimedia ebook self-study course!



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



Learn with us! Join a course today.

© 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!


Leave a Reply