Count Filtered Rows With this Easy Formula

Рет қаралды 5,969

Күн бұрын

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 - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial #SumitBansal

Пікірлер: 23

@trumpexcel 4 ай бұрын

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: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course

@jhankhanajani9314 3 ай бұрын

Thank You Sumit!!

@nadermounir8228 4 ай бұрын

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

@trumpexcel 4 ай бұрын

Glad you liked it... Also, thought I would let you know that my name is Sumit. Trumpexcel is the name of the site and channel I run 🙂

@MrDhunpagla 4 ай бұрын

Thanks for this tip... really useful 😊

@IvanCortinas_ES 4 ай бұрын

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

@trumpexcel 4 ай бұрын

Thanks for commenting Iván. True, SUBTOTAL is a powerful function, and has these little things that make it very useful in many cases.

@johnborg5419 4 ай бұрын

Thanks. Very informative

@trumpexcel 4 ай бұрын

Glad you found it useful John 🙂

@Satwant2463 4 ай бұрын

Lucid and simple presentation. Thank you.

@trumpexcel 4 ай бұрын

Glad you found it useful 😊

@ShubhamSharma-ls6hj 4 ай бұрын

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

@trumpexcel 4 ай бұрын

Thanks for the kind words Shubham 😊

@KuldeepSingh-nq1vi 4 ай бұрын

Really very informative video... ❤

@trumpexcel 4 ай бұрын

Thanks Kuldeep...Glad you found it helpful 🙂

@girishpadshala9689 4 ай бұрын

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

@trumpexcel 4 ай бұрын

Thanks Girish... Glad you found the video helpful 🙂

@misdin1 4 ай бұрын

Niiice tip 😊 thank you very much

@trumpexcel 4 ай бұрын

Thanks Marcos... Glad you found it helpful 🙂

@ifassafi4549 4 ай бұрын

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.

@trumpexcel 4 ай бұрын

Thanks 😊 Have a look at this - kzfaq.info/get/bejne/ibeSiJh3nce6m4U.htmlsi=GaJxTg7txbnWPH3S