SUBTOTAL(...)
Formula to manage serial number in a filtered list.
Used Functions
Category: Math and trigonometry
Returns a subtotal in a list or database
Syntax
SUBTOTAL(function_num,ref1,[ref2],...)
Practice SUBTOTAL Formula at Sheetzoom
SUBTOTAL formula at Microsoft help
0
SUBTOTAL() function takes two argument, the first corresponds to a list of options, and the 3 represents COUNTA in this list, the second argument is the range of cell. The formula means subtotoal of COUNTA for the given range of cells. We have used B$2 to make range expand as we drag it down.