Example: calculate an average of all the data shown in the grid

Below is an example of calculating an average of all the data shown in the grid using a named range. 

1. Add a new named range with the properties:

• Name: GridData
• Scope: Workbook
• Whole Grid - Data

1. The formula =Average(GridData) placed anywhere in the workbook will now calculate the grid's average value.