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

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

Excel Courses:

#msexcel #excelquickie #tutorial

[constantinoscoveos]

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

[jpgpqvb]

Easy, Useful, and Awesome explanation.

[piotr]

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.

[coolfire]

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

[markkozar]

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

[HaivyGraceBalili]

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

[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.

[darrylmorgan]

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

[nadermounir]

Nice Video 📹 thank you for your hard work

[ShoaibQureshi-jddt]

How to add the Unique Command with this?

[narayanakoruprolu]

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

[mikesara]

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?