Subtotal Without Grouping
October 15, 2001 - by Bill Jelen
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.