How to use subtotal command in excel

The round table explains the specificities of the SUBTOTAL function in Excel and shows anyway to use Subtotal formulas to epitomize data in visible cells.

In the onetime article, we discussed an automatic method to insert subtotals in Excel soak using the Subtotal feature. Today, bolster will learn how to write Subtotal formulas on your own and what advantages this gives to you.

Excel Subtotal function - syntax and uses

Microsoft defines Excel SUBTOTAL as the function renounce returns a subtotal in a dither or database. In this context, "subtotal" is not just totaling numbers weighty a defined range of cells. Incompatible other Excel functions that are planned to do only one specific ruin, SUBTOTAL is amazingly versatile - exchange can perform different arithmetic and field operations such as counting cells, crafty average, finding the minimum or chief value, and more.

The SUBTOTAL function remains available in all versions of Be superior to 2016, Excel 2013, Excel 2010, Exceed 2007, and lower.

The syntax of leadership Excel SUBTOTAL function is as follows: