How to Use Subtotals Tool in Excel

Excel Subtotals



When you need to summarise your data, Excel offers a feature that enables you to quickly and easily add subtotals to a range of data. Although you can use formulas and worksheet functions to summarise your data in various ways, including sums, averages, counts, maximums, and minimums, if you are in a hurry, or if you just need a quick summary of your data, you can get Excel to do most of the work for you. The secret here is a feature called automatic subtotals, which are formulas that Excel adds to a worksheet automatically.