Word allows you to total the data in your tables by clicking the Formulas button on the contextual Layout Ribbon. By default, Word will propose the =SUM(ABOVE) or =SUM(LEFT) formulas, which will sum the cells above the selected cell or the to the left of the selected cell. You can also use other aggregate functions in your formula, such as AVERAGE, MIN, MAX, and COUNT. Simply replace the word “SUM” with the word for the aggregate function you want to use.
It is important to note that when adding new rows or column to a table, the formula will not automatically update. To update the formula, right-click the formula and choose Update Field from the contextual menu.
To Total Rows and Columns in a Table
- Click in the cell where you want the total to appear.
- Click the contextual Layout tab under Table Tools.
- Click the Formula button on the Data group. Word will automatically propose a formula.
- To insert a different formula, delete the formula in the Formula box and type in a different formula.
- If desired, click the Number format drop-down list and choose the desired number format from the list.
- Click OK.
- To update a field after adding or removing rows or columns, right-click the formula and choose Update Field from the contextual menu.