How to Add a Total or Subtotal Row to a Table in Excel First, click anywhere in the data Then in the Ribbon, go to the Data tab, and in Outline click on Subtotal The pop-up screen for Subtotal appears, and here you can specify how to group data In the first section (At each change in:) set Month, as you want to add a subtotal for each month