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. On the toolbar, click AutoFilter How?
Apply a filter
so that it is selected.
Remove a filter
so that it is no longer selected.
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.