Ways to count data in a Word table

ways to count data in a Word table

For example, the financial staff needs to count the income and expenditure of each month in the first half, calculate the sum of the revenue, expense columns, and calculate the net income for each month (that is, the difference between the revenue column and the expense column, as shown in Figure 1), at which point you can follow the steps below.

Figure 1 needs to calculate the data in a Word table

1. Place the cursor in a cell that needs to be entered in the sum of the income column, the last cell in the Revenue column, in the Data Options group on the Layout tab, click the Formula button to open the Formula dialog box, as shown in Figure 2.

Figure 2 Opening the Formula dialog box

2, as you can see in this dialog, the Formula text box automatically enters the formula "=sum (ABOVE)" that calculates the sum of the Revenue column, and we can format it in the Numbering format drop-down list box. When the settings are complete, click OK to get the results of the statistics, as shown in Figure 3.

Figure 3 Inserting a formula into a table and formatting the results

3, we can not only let Word automatically insert the formula, but also by manually entering a reference to the cell to calculate the data in the table. For example, when calculating net income for January, you can use the formula "C2-D2" to calculate the difference between income and expenditure for January, as shown in Figure 4.

Figure 4 Referencing data in a table in a formula