- Create a new membership query with the following criteria:
Current, Standing equals Active
- Run the query.
- Save and close the query.
- Create a new Membership Export in Comma Separated Values (CSV) format.
- Select the query created from the previous steps on the General tab.
- On the Output tab, select the following fields:
Constituent, Constituent Information, Name
- Export the data to Excel.
- Open the spreadsheet in Excel and sum the column for Total Members.