When you filter data in Excel, the visible or filtered rows are in blue, and the data that doesn't meet the filter criteria are automatically hidden. This is great, except when you want to perform calculations on the filtered data. If you use the SUM, AVERAGE, MAX, MIN, or other functions, the answers will be incorrect. You need to use the SUBTOTAL function to get accurate results.
The SUBTOTAL Function, don't get confused with the Subtotal command on the Data tab
Chapters/Bookmarks
0:00 Intro
0:12 Data overview
0:52 Filter data
1:52 SUBTOTAL Function AVERAGE
2:40 SUBTOTAL Function with MAX
3:29 SUBTOTAL Function with MIN
4:23 SUBTOTAL Function with SUM
=SUBTOTAL(number,Range)
Examples of SUBTOTAL
=SUBTOTAL(1,H2:H36) will find the AVERAGE
=SUBTOTAL(4,H2:H36) will find the highest or MAX
=SUBTOTAL(5,H2:H36) will find the lowest or MIN
=SUBTOTAL(9,H2:H36) will find the total or SUM
CTRL+SHIFT+L keyboard shortcut to turn filters on and off.
#chrismenardtraining #chrismenard #exceltraining #microsoftexcel
And make sure you subscribe to my channel!
-- EQUIPMENT USED ---------------------------------
○ My camera – [ Ссылка ]
○ Microphone - [ Ссылка ]
○ Camera tripod – [ Ссылка ]
○ Studio lights - [ Ссылка ]
○ Dual monitor mount stand - [ Ссылка ]
○ Web camera – [ Ссылка ]
○ Shock mount - [ Ссылка ]
○ Boom Arm - [ Ссылка ]
-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – [ Ссылка ]
○ Screenshots – Snagit – [ Ссылка ]
○ YouTube keyword search – TubeBuddy – [ Ссылка ]
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
