About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store



Past Tip of the Day


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.


By Bill Jelen on 15-Oct-2001 Consulting can be hired to implement this concept, or many other cool applications, with your data. provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.


Excel is a registered trademark of the Microsoft® Corporation.

All contents Copyright 1998-2008 by MrExcel Consulting.