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.



Please wait...

Subscribe to ExcelMOOC posts

Want to be notified when our Excel article is published? Enter your email address and name below to know all new Excel features and cool tips