Count visible rows in a filtered list in Excel

In this video, I will help you learn how to count visible rows in a filtered list in Excel. To count the number of visible rows in a filtered list, you can use the SUBTOTAL function.

Quick Look at the SUBTOTAL Function
The SUBTOTAL function is a handy function when dealing with summarized data in a filtered range. It’s highly flexible because you can pick what kind of calculation you want with a specific function number.

Here’s the quick overview of SUBTOTAL Function:
Syntax: SUBTOTAL(function_num,ref1,[ref2],...)

- Function_num: Choose the type of calculation, like 1 for average or 9 for sum.
- Ref1, Ref2, ...: These are the ranges you want to work with.

The best part is that the SUBTOTAL skips over hidden or filtered-out rows for certain function numbers. For example, if you’re summing up a filtered table, it only considers the visible rows. Perfect for tables and reports!

By the end of this video, you’ll know exactly how to use the SUBTOTAL function to count filtered rows in Excel.

#exceltips #excel #exceltipsandtricks #excelformula #exceltutorial #excelformulas