Show All

Sum filtered data

1. Filter the data to display the rows you want to sum.

   How?

   Apply a filter

   1. Click a cell within the list that you want to filter, or select the specific range of cells that you want to filter.
   2. On the toolbar, click AutoFilter so that it is selected.
   3. Click the arrow in the column that contains the data you want to display.

   4. 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.

2. Click the cell below the data you want to sum.
3. Click AutoSum on the spreadsheet 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.