PlayInfoBox

Home /Utilities /How to Count Filtered Results in Excel

How to Count Filtered Results in Excel

Tap a step to see how to count exactly how many rows a filter is showing.

  1. Apply a filter with your condition

    Filter your data down to the rows you actually want to check.

  2. Select the filtered column

    Select the visible cell range in the column you want to count.

  3. Check the count in the status bar

    The "Count" automatically appears in the status bar at the bottom of the screen, calculated only from the visible, filtered cells.

  4. Or use the SUBTOTAL function

    Typing "=SUBTOTAL(103,range)" displays the filtered result count directly inside a cell instead of just the status bar.

  5. Why is this useful?

    When you need to know quickly how many items match a specific condition, this gives you the answer instantly without counting row by row.

Skip the Manual Counting

Scrolling through a filtered list and counting matching rows one by one is slow and easy to get wrong, especially with hundreds of rows. Excel already tracks this for you the moment you apply a filter — you just need to know where to look.

Status Bar vs. SUBTOTAL: Which to Use

The status bar count is fastest for a quick, one-time check, but it disappears once you click away. SUBTOTAL is better when you want the count to stay visible on the sheet, update automatically as the filter changes, or feed into another formula.

Frequently Asked Questions

Does the header row get included in the count?

No, the status bar count only reflects the actual data cells you have selected, so it is best to select just the data range and exclude the header row for an accurate number.

What if my column has a mix of numbers and text?

The status bar's "Count" tallies every non-empty cell regardless of type, but checking "Numerical Count" alongside it shows how many of those are specifically numeric values.