It’s not always all about the final result of a calculation. Sometimes you need to draw subtotals, for example in monthly or quarterly statements. For these situations, Excel offers a useful function named SUBTOTALS, with which you can group data and display preliminary results. In this Special Topic we will show you how to correctly apply this function and how to add groups of figures to subtotals quickly and reliably.

Published on: 10.12.2013

To acces the videos for this Special Topic you must have subscribed to Excel !


Excel 2016

Grouping Data:  
This video will give you an introduction to the subtotal function in order to perform calculations such as minimum, maximum, product or sum for groups of data. (2 Min.)



Excel 2013

Grouping Data:  
This video will give you an introduction to the subtotal function in order to perform calculations such as minimum, maximum, product or sum for groups of data. (2 Min.)



Excel 2010

Grouping Data:  
This video will give you an introduction to the subtotal function in order to perform calculations such as minimum, maximum, product or sum for groups of data. (2 Min.)



Excel 2007

Grouping Data:  
This video will give you an introduction to the subtotal function in order to perform calculations such as minimum, maximum, product or sum for groups of data. (2 Min.)