HOW TO USE SUBTOTAL FUNCTION IN EXCEL

Subtotal Function In Excel


SUBTOTAL FUNCTION IN EXCEL


Subtotal is a most useful function against AVERAGE, COUNT, COUNTA, MAX, MIN, PRODUCT,... more option. Subtotal has a ability to use a verity of functions, In additional, the subtotal function can either exclude and include values are not visible in rows. you can also use SUBTOTAL to find sum of filtered values.


Subtotal Function_num are


Function
Include hidden
Ignore hidden
AVERAGE
1
101
COUNT
2
102
COUNTA
3
103
MAX
4
104
MIN
5
105
PRODUCT
6
106
STDEV
7
107
STDEVP
8
108
SUM
9
109
VAR
10
110
VARP
11
111

Subtotal Function Vs Sum

you have two Cells A10 and A20 using sum formulas. If you apply one more sum  function in Cell A30 E.g =Sum(A1:A29) these two cell values include in results. but if do you use SUBTOTAL function in A10 and A20 cells and you also apply SUBTOTAL in cell A20 e.g =subtotal(109,A1:A29), these formula is not included A10 and A20 value in result.

Subtotal Ignore Hidden Rows

In case you have to filtered your data. SUBTOTAL ignores all cells that  are hidden. All cells will not be included in calculation that are filtered out.

Must Watch Video For Easy Learning and understanding


EmoticonEmoticon