Count Filtered Rows With this Easy Formula

Опубликовано: 15 Январь 2025
на канале: TrumpExcel
14,128
266

In this short video, I will show you how to count filtered rows in Excel with a simple formula using SUBTOTAL.

While this cannot be done using regular COUNT functions, the SUBTOTAL function allows you to ignore the filtered rows and only count or sum the rows that are visible after filtering.

00:00 Intro
00:12 Count Filtered Rows Using SUBTOTAL
01:40 Difference between 3 and 103 in SUBTOTAL
02:24 Get Count of Filtered Rows in the Status Bar

☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB

✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-c...
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...

#Excel #ExcelTips #ExcelTutorial #SumitBansal