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 ...

The subtotal function in Excel is a handy way to calculate smaller amounts, separate from the final total. It's relatively easy to use in a spreadsheet, and it allows you to organize your data. The ...

Excel Tip: SUBTOTAL and SUM - what's the difference? 9th Sep 2014 From the Not Just Numbers blog: I'm sure most of you are familiar with the SUM command for totalling ranges of cells, but have you ...

Excel's Subtotal feature can render quick results when you need simple grouping calculations. Susan Harkins shows you how this powerful feature works.

There's more to Excel's Subtotal feature than you might realize. You can add multiple subtotaling functions to the same row, and you can add multiple rows.

In Excel, however, you can use outlines (and the accompanying Subtotal tool) to break data down into logical subdivisions that you can quickly view or hide, depending on how you want to review the ...

Most people run into the =SUBTOTAL function when it is added through the use of the Data Subtotals command in Excel. However, the SUBTOTAL function has another neat trick when used in combination with ...

However, the SUBTOTAL function has another neat trick when used in combination with the Filter dropdowns in Excel 2007/2010 or the AutoFilter dropdowns in Excel 97-2003. Easy Way to Apply a Filter ...