Count Visible Rows in a Filtered List in Excel - EQ 99

VBA/Macros Course (40% Discount): https://www.teachexcel.com/vba-course...


Excel Quickie Playlist:    • Excel Quickies  
Excel File: https://www.teachexcel.com/excel-tuto...

How to use the COUNT or COUNTA function on a filtered list of data so that hidden rows are not included in the count.

This will work for filtered data as well as manually hidden rows in the worksheet.

I will show you two different functions to use to achieve this, the SUBTOTAL and the AGGREGATE function.

Additional Resources
Exclude Filtered or Hidden Cells from Calculations: https://www.teachexcel.com/excel-tuto...
SUBTOTAL Function (microsoft): https://support.microsoft.com/en-us/o...
AGGREGATE Function (microsoft): https://support.microsoft.com/en-us/o...

Excel Courses:
VBA/Macro Course: https://www.teachexcel.com/vba-course...
Building Professional Forms: https://www.teachexcel.com/premium-co...
Email Course: https://www.teachexcel.com/premium-co...

TeachExcel.com

#msexcel #excelquickie #tutorial