excel count visible rows code example

Example: excel count visible rows

# number of visible (filtered) cells in range B5:B14.  '3' is for COUNTA
=SUBTOTAL(3,B5:B14)