Youtor
Using Excels Subtotal Function with Filters in Excel
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=5iwJeXp4CGU
When using filters in Excel, the functions average, max, min, and sum will give you the wrong answer since they include the hidden rows. Use the Subtotal function to get the correct answer. • =Subtotal(1,range) will give you the Average for what is visible. • 1 is average • 4 is max • 5 is min • 9 is total • • Chris Menard - Microsoft Office Master Instructor. Contact Chris for training for your organization. • And make sure you subscribe to my channel! • - EQUIPMENT USED -------------------------------- • ○ My camera – https://amzn.to/3vdgF5E • ○ Microphone - https://amzn.to/3gphDXh • ○ Camera tripod – https://amzn.to/3veN6Rg • ○ Studio lights - https://amzn.to/3vaxyy5 • ○ Dual monitor mount stand - https://amzn.to/3vbZSjJ • ○ Web camera – https://amzn.to/2Tg75Sn • ○ Shock mount - https://amzn.to/3g96FGj • ○ Boom Arm - https://amzn.to/3g8cNi6 • - SOFTWARE USED -------------------------------- • ○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia • ○ Screenshots – Snagit – https://chrismenardtraining.com/snagit • ○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard • 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!
#############################
