Using Formulas in Tables

Word enables you to do different types of calculations in your tables. It certainly does not provide the large number of functions you find in Excel, but it provides functions calculations that include average, sum, maximum, and minimum.

Word (like Excel) also has the capability to take an educated guess on the type of calculation you want to make in a table. For example, if you insert a formula at the bottom of a column of numbers, Word assumes that you want to act upon the data above the current cell and suggests the formula =SUM(ABOVE). This is because Sum is also the default formula.

In some cases, Word might not be able to help you by recognizing the group of cells you want to include in the calculation, so you have ...

Get Office 2013 In Depth now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.