Channel: TeachExcel

Category: Education

Tags: count hidden datasubtotal functionaggregate functioncount filtered data excel

Description: VBA/Macros Course (40% Discount): teachexcel.com/vba-course-update.php?src=youtube_v_description_lTSg9ruV41U Excel Quickie Playlist: youtube.com/playlist?list=PLxhsXZXQXrUBRG1QskvchMBezTR9ZTWaj Excel File: teachexcel.com/excel-tutorial/1912/count-the-visible-rows-in-a-filtered-list-in-excel?src=yt 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: teachexcel.com/excel-tutorial/2222/exclude-cells-that-are-filtered-hidden-or-grouped-from-formulas?nav=youtube_v_lTSg9ruV41U SUBTOTAL Function (microsoft): support.microsoft.com/en-us/office/subtotal-function-7b027003-f060-4ade-9040-e478765b9939 AGGREGATE Function (microsoft): support.microsoft.com/en-us/office/aggregate-function-43b9278e-6aa7-4f17-92b6-e19993fa26df Excel Courses: - VBA/Macro Course: teachexcel.com/vba-course-update.php?src=youtube_v_description_lTSg9ruV41U - Building Professional Forms: teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=youtube_v_lTSg9ruV41U - Email Course: teachexcel.com/premium-courses/96/send-emails-from-excel-course?src=youtube_v_lTSg9ruV41U TeachExcel.com #msexcel #excelquickie #tutorial