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

Tip

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