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

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

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

50% 1

VBA/Macros Course (40% Discount): www.teachexcel.com/vba-course...
Excel Quickie Playlist: • Excel Quickies
Excel File: 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: www.teachexcel.com/excel-tuto...
SUBTOTAL Function (microsoft): support.microsoft.com/en-us/o...
AGGREGATE Function (microsoft): support.microsoft.com/en-us/o...
Excel Courses:
- VBA/Macro Course: www.teachexcel.com/vba-course...
- Building Professional Forms: www.teachexcel.com/premium-co...
- Email Course: www.teachexcel.com/premium-co...
TeachExcel.com
#msexcel #excelquickie #tutorial

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

6 авг 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@constantinoscoveos9233 Год назад

Fantastic Solution !!! Thank you !!! Costas from Greece

@markkozar Год назад

Nice! Very well presented, and thanks for enlightening me to the 'aggregate' function... cheers!

@user-jp1gp2qv8b Год назад

Easy, Useful, and Awesome explanation.

@rajendransix Год назад

was searching and got it thanks

@TheMarkGross Год назад

Very helpful.

@Life_Needs13 4 месяца назад

vert helpful thanks alot

@rajeshsapiens6680 2 месяца назад

Very helpful😍

@Markasjanvarious Год назад

Thank you 😊

@wayneedmondson1065 2 года назад

Nice one! Thanks and thumbs up!!

@TeachExcel 2 года назад

Thanks Wayne :)

@sabuein 2 года назад

Thank you.

@nadermounir8228 2 года назад

Nice Video 📹 thank you for your hard work

@TeachExcel 2 года назад

Thank you Nader! You're very welcome :)

@darrylmorgan 2 года назад

Totally Agree SUBTOTAL() And AGGREGATE() Are Really Awesome Functions..Thank You Sir :)

@TeachExcel 2 года назад

I feel like we should just randomly tell people to use AGGREGATE() until everyone knows it without question lol.

@piotr4248 2 года назад

Great lesson, and what would be helpful is ... labelling the cell the formula is being developed for. That's very critical for the viewer to be clear about what we are doing, while the formula building by itself is another layer of difficulty.

@TeachExcel 2 года назад

Thanks for the input! I'll try to make things clear)

@coolfire8470 2 года назад

Exemple; I have 30 rows with different items names, I filter only specific items with 10 rows now automatically shows sum of 10 rows in empty row, but it shows 30 rows total. Solve my problem please

@machineworld4804 Год назад

Can it work to alphanumeric value?

@HaivyGraceBalili Месяц назад

what are the difference between aggregate and subtotal? seems look the same function as you illustrated.

@narayanakoruprolu1506 2 года назад

If it comes repeat numbers in coloum .., is it count double times...

@mikesara7032 2 года назад

I'm trying to figure out how to count the amount of times the number changes, for example in column A i have 252 values of 7 and 8, 7 = 73 and 8 = 178, what i want to do is see the number of times the values changes from 7 to 8, i did it manually and it came up to 49 times, but i would like to know what kind of function can i use for such task, can you please help me?

@07punit 2 года назад

@ShoaibQureshi-jd4dt 10 месяцев назад

How to add the Unique Command with this?

@PriyankaChoudhary-er1ht Год назад

👏 👏

@MIMGURU 2 года назад

Wow

@kimdburns Год назад

I hate when I see comments about how great something worked and it does not work at all for me. Not even a little. I have 7000+ rows I subtotaled, then turned to a table, and the result I get with all functions is 0 rows. Even if I reveal all of the rows.