Formula to count visible rows in a filtered list

You have a filtered list and want to count visible rows in this list. In Excel, you can use the SUBTOTAL function to do that. The formula will automatically ignore rows that are hidden by a filter.

To count visible rows in a filtered list use formula: =SUBTOTAL(103,range)

  • 103 is Function_num
  • range is range of cells that ignores hidden values
  • SUBTOTAL function returns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is created, you can modify it by editing the SUBTOTAL function.