Sum filtered data

1. In the design window, make sure the spreadsheet is activated. For instructions, see Help for your design program.
2. Filter the data to display the rows you want to sum.

   How?

   Apply a filter

   1. In the design window, make sure the spreadsheet is activated. For instructions, see Help for your design program.
   2. Click a cell within the list that you want to filter, or select the specific range of cells that you want to filter.
   3. On the toolbar, click AutoFilter so that it is selected.
   4. Click the arrow in the column that contains the data you want to display.

   5. To display only the items you want to see, clear the Show All check box, and then select the check box for each item you want to display.

   Remove a filter

   • On the toolbar, click AutoFilter so that it is no longer selected.

3. Click the cell below the data you want to sum.
4. Click AutoSum on the toolbar, and then press ENTER.

Note   The AutoSum button sums only the data in visible rows. To include all rows in the sum, show all rows and then sum the rows.