MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Subtotal Without Grouping

October 15, 2001 - by Bill Jelen

Carol asks:

I have a column of numbers that I want to add. But I want subtotals for each person who may have more than one number. Is there a way to add each individual person's numbers without selecting each group for each person and manually adding.

Yes, the feature is called Data - Subtotals. You will find the Subtotals command on the Data menu. Select your data, then choose Data - Subtotals. In the Subtotal dialog box, you will answer three questions:

  • At each change in: Name
  • Use function: Sum
  • Add Subtotal to: Amount


For more details and an image about Data Subtotals, read method #4 in Tip 035.

Bill Jelen is the author / co-author of
Microsoft Excel 2019 Pivot Table Data Crunching

Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you’ve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel in Office 365.