Using Excel's Subtotal Function with Filters in Excel
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 - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtraining.com/camtasia
○ Screenshots - Snagit - chrismenardtraining.com/snagit
○ KZread keyword search - TubeBuddy - 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!
Пікірлер: 26
This was helpful and solved my issue with subtotaling different filtered items within a column. I appreciate the time to produce the video.
@ChrisMenardTraining
5 жыл бұрын
Thank you.
Thank you, it took me a bit longer for the sum
Simple, short and excellent!
@ChrisMenardTraining
5 жыл бұрын
Thank you!
Thank you for this video, it worked beautifully and is the best explanation i have seen so far!
@ChrisMenardTraining
9 жыл бұрын
No problem. Glad it helped.
Thank you so much. Short and sweet, and to the point. You are good.
@ChrisMenardTraining
Жыл бұрын
Thanks, Ryan.
Very useful and quickly to the point. Thanks!
@ChrisMenardTraining
Жыл бұрын
Thank you.
Exactly what I was looking for at first search, thank you.
@ChrisMenardTraining
4 жыл бұрын
You are welcome.
Thank you. Simple and effective!!!
@ChrisMenardTraining
5 ай бұрын
Glad it was helpful!
Absolutely solved my problem. Thanks 1000x
@ChrisMenardTraining
8 ай бұрын
You're welcome!
Useful and to the point!
@ChrisMenardTraining
Жыл бұрын
Glad to hear that! Thank you!
thanks dear for this helpful video...
@ChrisMenardTraining
5 жыл бұрын
You're welcome!
Thank You
@ChrisMenardTraining
6 жыл бұрын
Thank you for the feedback.
MUITO OBRIGADO
Can I mention the filter name in Subtotal function, Instead of changing filters from the tab?