Please enable JavaScript to view the comments powered by Disqus.


Formula to manage serial number in a filtered list.

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. 

Used Functions

Category: Math and trigonometry

Returns a subtotal in a list or database



Lets chat on this