Excel Tutorial Subtotal Function

Rows hidden by a filter 1.

Excel tutorial subtotal function. To ignore rows hidden by a filter or to ignore manually hidden rows. Also to its ability to return a sum it can also give the user an average count max and several other results. In this tutorial we turn our attention to the subtotal function in excel. The subtotal function in excel allows users to create groups and then perform various other excel functions such as sum count average product max etc.

Returns a subtotal in a list or database. Subtotal can return a sum average count max and others see table below and subtotal function can either include or exclude values in hidden rows. You may think of a sum of selected values. Thus the subtotal function in excel helps in analyzing the data provided.

But the subtotal function is capable of much more. What is the subtotal function in excel. The excel subtotal function returns an aggregate result for supplied values. Use the subtotal function in excel instead of sum count max etc.