Almost every month, I suggest the Subtotal feature to a reader. It's an easy-to-use feature that summarizes data by groups. You define the group and the summarizing function; Excel does the rest. This ...

Excel's subtotaling feature is a great tool for inserting subtotaling formulas in into your data. The down side is that the subtotal rows are often difficult to discern from the rest of the data.

If you have three or more rows of data, chances are, you'll need to summarize those values in some way. Summarizing is one of the most common tasks we perform in Excel. The term summarize implies a ...

Here are a few quick methods of analyzing records to find out what's been paid and how much customers owe. If you work with transaction records, you probably need a way to track what’s outstanding and ...

Three ways to return the average age for a group using Excel Your email has been sent Summarizing data is a common task in Excel, and there's usually more than one way to do so. Susan Harkins explains ...