1. Create a constituent query to pull the appropriate constituents. Be sure to add Constituent Information, Age not blank as a filter.
  2. Create a constituent export using the query created in step 1. Select Comma-Separated Values (CSV) as the Export Format and export the Biographical, Age field.
  3. Open the file created in step 2 in Microsoft Excel
  4. Scroll down to the first row with no information and enter the following:
    =AVERAGE(A1:A#) where # is the number of the last row.
  5. Click in any other cell and Excel calculates the average

For example, to calculate the average age of anyone who ever had a membership:

  1. Create a constituent query and filter on:
    Membership, Import ID not blank
    AND Constituent Information, Age not blank
  2. Create a constituent export using the query created in step 1. Select Comma-Separated Values as the Export Format and export the Biographical, Age field.
  3. Open the file created in step 2 in Microsoft Excel
  4. Scroll down to the first row with no information. Let's say this is row 1492. (Row 1491 is the last row with information). Enter the following in cell A1492:
    =AVERAGE(A1:A1491)
  5. Click in any other cell and Excel calculates the average