Below is an example of calculating a formula for each column in the grid using a named range.

  1. Add a new named range with properties:
      • Name: GridData
      • Scope: Workbook
      • Whole Grid - Data
  2. The formula =SUM(GridData B:B) will give the Sum of column B. You can fill the formula across to compute other columns