Unlike other Excel functions that are designed to do only one specific thing, SUBTOTAL is amazingly versatile - it can perform different arithmetic and logical operations such as counting cells, calculating average, finding the minimum or maximum value, and more.
In this context, 'subtotal' is not just totaling numbers in a defined range of cells. Microsoft defines Excel SUBTOTAL as the function that returns a subtotal in a list or database. Today, you will learn how to write Subtotal formulas on your own and what advantages this gives to you. In the previous article, we discussed an automatic way to insert subtotals in Excel by using the Subtotal feature.
The tutorial explains the specificities of the SUBTOTAL function in Excel and shows how to use Subtotal formulas to summarize data in visible cells.
