Why =SUM() fails on filtered tables: Master =SUBTOTAL(109, range) and =AGGREGATE(9, 5, range) to ignore hidden rows.
“Subtotal & AGGREGATE: Calculating Totals in Filtered Lists” is part of Level 2: Intermediate Excel — Lookups, Analytics & Pivot MIS. Free preview lessons are open to everyone; the remaining lessons are for enrolled learners.
Module 5: Corporate Charts & Data Visualization
Module 6: PivotTables, Slicers & Mini-Projects (Sales MIS + HR Attendance)
