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).
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.
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.
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!