Groups and Subtotals

In Excel groups and subtotals let you can hide data and summarize groups. Use groups and subtotals in Excel to better read data too.


  1. Open our practice workbook.
  2. Click on the Challenge tab in the bottom-left of the workbook.
  3. Sort the workbook by Grade from smallest to largest.
  4. Use the Subtotal command to group at each change in Grade. Use the SUM function and add subtotals to Amount Raised.
  5. Select Level 2 so that you only see the subtotals and grand total.
  6. When you're finished, your workbook should look like this:

    Grouping and Subtotals Challenge