To Insert a Footer Row in a Data Extraction Table

1. Click Insert tab Linking & Extraction panel Extract Data. Find
2. On the Refine Data page, right-click a column label to create a footer row for that column, and choose Insert Totals Footer.
3. From the flyout menu, choose Sum, Max, Min, or Average.