To calculate the averages in Table 1, use this method:
- For the month of January in the Average column, click Ctrl+F9 to get this field: { }.
- In the brackets, type = 5.5/4:
- With your cursor in the brackets, click F9 to get the average: 1.38.
- To double check, right-click in the field and select Toggle Field Codes from the drop down to see the equation, then toggle back for the average.
- Copy and paste the field code to the rest of the average cells and select Update Field from the dropdown list for each one.
| Month | Week 1 (in.) | Week 2 (in.) | Week 3 (in.) | Week 4 (in.) | Total | Average |
| January | 2 | 0 | 1.5 | 2 | 5.5 | 1.38 |
| February | 0 | 1 | 0 | 1 | 2 | 0.5 |
| March | 2 | 1 | 4 | 3 | 10 | 2.5 |
| 1st Q Total | 4 | 2 | 5.5 | 6 | 17.5 | 4.38 |
