SUM is the spreadsheet equivalent of an open invite: it welcomes everything into the total, whether it belongs there or not.

So, select any cell in your formatted Excel table, and in the Insert Tab on the ribbon, click the top half of the split "PivotChart" button.