SUBTOTAL( )

To use in calculating subtotals within a list.

SUBTOTAL(function_num, ref1, ref2, ...)

Remarks:

Row 4 was hidden!!

If use function_num "9", it will includes hidden values.
If use function_num "109", it will ignores hidden values.