Count Filtered Rows With this Easy Formula

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

#Excel #ExcelTips #ExcelTutorial #SumitBansal

[trumpexcel]

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.

Also, I have made all of my Excel courses available for free. You can check these out using the below links:

[nadermounir]

Very insightful Video. Thank you trump for this nice video 📹 👍

[IvanCortinas_ES]

Thanks Sumit, SUBTOTAL is a function that must be taken into consideration.

[Satwant]

Lucid and simple presentation. Thank you.

[ShubhamSharma-lshj]

Make the complex topic short and simple, amazing talent you are having brother ❤

[MrDhunpagla]

Thanks for this tip... really useful 😊

[girishpadshala]

Thanks, today I knew difference between subtotal - 3 & 103, useful, thanks again Sumit Bansal.

[getallinone]

Your writing content coverup the h Excel sheet 😊😊😊

[ifassafi]

Excellent teacher! So, lets see if u mind helping me with this: I have 100 rows. I want data on the 1st row moved to the 100th row, , data on the secon row to the 99th row, 3rd row to the 98th row, 4th to the 97th and so on- all the way until the bottom row (100th) ends up on the 1st row.