In this short video I cover how to insert automated subtotals.
Its a built-in feature, that is easy to use.
Tag Archives: SUBTOTAL
Adding a message to grouping icons
A SUBTOTAL trick
It is best practice to use grouping to hide and unhide rows in Excel. I recently saw a technique that also displays a message.
Excel Subtotal Sort Magic
Sorting by subtotals is possible
Sometimes Excel surprises me. In this case it sorts in a way I didn’t expect, but in a good way. Thanks to Mr Excel for the tip.
Summing Coloured Cells in Excel
A SUBTOTAL trick worth learning
In my training sessions I sometimes get asked about summing cells based on their colour. A SUMIF based on colour.
Paste Only Subtotals in Excel
A useful technique
Excel’s SUBTOTAL function is my function of choice for all my subtotaling requirements. See my earlier post here on its features.
Excel’s automated subtotal feature can do most of the work for you and leave you with a nicely summarised list.
Quickly and easily hiding and unhiding rows and columns in Excel
Excel's Grouping technique
Hiding rows and columns is a common process in spreadsheets. Excel’s grouping feature can make the process easier and make it more apparent when rows or columns have been hidden.
SUBTOTAL Function- better than SUM
Summing visible cells only
The SUM function is the function of choice to add up values. But when it comes to subtotalling, SUM leaves a lot to be desired. There is a specific function for subtotalling called, funnily enough, SUBTOTAL.