On the Data tab, click Filter in the Sort & Filter group. Excel adds the filter automatically. Before we experiment with the filtering, use any method you like to add a SUM () function to A9.