Count Filtered Rows With this Easy Formula

Подписаться 375 тыс.

Просмотров 7 тыс.

50% 1

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: ru-vid.com...
#Excel #ExcelTips #ExcelTutorial #SumitBansal

Опубликовано:

7 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 23

@trumpexcel 5 месяцев назад

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 4 месяца назад

Thank You Sumit!!

@nadermounir8228 5 месяцев назад

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

@trumpexcel 5 месяцев назад

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 🙂

@ShubhamSharma-ls6hj 5 месяцев назад

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

@trumpexcel 5 месяцев назад

Thanks for the kind words Shubham 😊

@MrDhunpagla 5 месяцев назад

Thanks for this tip... really useful 😊

@IvanCortinas_ES 5 месяцев назад

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

@trumpexcel 5 месяцев назад

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

@Satwant2463 5 месяцев назад

Lucid and simple presentation. Thank you.

@trumpexcel 5 месяцев назад

Glad you found it useful 😊

@johnborg5419 5 месяцев назад

Thanks. Very informative

@trumpexcel 5 месяцев назад

Glad you found it useful John 🙂

@girishpadshala9689 5 месяцев назад

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

@trumpexcel 5 месяцев назад

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

@KuldeepSingh-nq1vi 5 месяцев назад

Really very informative video... ❤

@trumpexcel 5 месяцев назад

Thanks Kuldeep...Glad you found it helpful 🙂

@misdin1 5 месяцев назад

Niiice tip 😊 thank you very much

@trumpexcel 5 месяцев назад

Thanks Marcos... Glad you found it helpful 🙂

@ifassafi4549 5 месяцев назад

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 5 месяцев назад

Thanks 😊 Have a look at this - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-SQbU5F8aVkQ.htmlsi=GaJxTg7txbnWPH3S