SUBTOTAL Formula in Excel for Filtered Data / Table. (SUBTOTAL is not only TOTAL, but more of it)

    In Excel, We can filter data as we need by selecting criteria. sometime we need to do some calculation on that filtered data. SUBTOTAL formula can help you in that.

First we will understand how to use SUBTOTAL formula by selecting various function according to your need in data.

Function List:

Function	Number
AVERAGE	1 or 101
COUNT	2 or 102
COUNTA	3 or 103
MAX	4 or 104
MIN	5 or 105
PRODUCT	6 or 106
STDV	7 or 107
STDEVP	8 or 108
SUM	9 or 109
VAR	10 or 110

Now, you are ready with formula. in below step you will see the real usage of this formula.

SUBTOTAL do the calculation on visible / filtered data only.

You can make it more advance by using slicer on your data.

(No need to worry if you dont know slicer or table, Just CLICK HERE)

I hope you find this useful and will you this tomorrow in your office.