Get the Sum of Filtered Data in Excel (Using SUBTOTAL Formula)

When you filter data, getting the SUM of only the visible part of the data can be a challenge. If you use SUM function for it, it will show you the SUM of the entire range (visible as well as hidden).

In such cases, when you want to get the sum of filtered data only (i.e., the cells that are visible), you can use the SUBTOTAL function. SUBTOTAL function can ignore hidden rows (either through filters or done manually) and can give you the following values:
-- SUM
-- AVERAGE
-- COUNT
-- COUNTA
-- MAX
-- MIN
-- PRODUCT
-- STDEV.P
-- STDEV.S
-- VAR.S
-- VAR.P

This video is a part of my 'Excel is two-minute' series, where I share simple and quick tips to help you speed up your work and be more efficient

⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[valleyseniorliving]

You are one of the best teachers that I've found when it comes to Excel. Thank you for what you do.

[mohanshanmugalingam]

Excellent explanation. Great Job.. All the best

[Phagocytosis]

Perfect, exactly what I was looking for, quick and simple. Thank you so much!

[mil]

Great video. Super clear and short without any fluff. Thank you.

[fewlinesbiju]

Simple and very effective tips... Thanks Sumit !!!

[bigdoggetom]

Subscribing just for this video. Clear, concise, and accurate. Perfect

[kartikkulkarni]

Love the simplicity of your explanation..!!

[shubhamguptaU]

I really likes your useful tips, even whenever i bored or have nothing to do and wanted to do something useful, one of your channel I prefer to watch

[bkblrchannel]

Thanks for the Quick & Clear explanation & demo. Very useful for quick learning

[sheriframzy]

Simple clear easy to follow explanation. Thank you

[ermwert]

Very straight forward and easy to understand. Keep up..

[Gilgamesh]

Awesome!! Clear and concise instructions. Subscribed.

[igorsljivic]

Thank you! You've saved me HOURS of work on my project

[filly]

Thanks so much! This was driving me crazy. Worked great!!

[jamesash]

This is amazing, the exact solution to today's sheets problem. Thank you so much, friend.

[karthikrajgopal]

Excellent video,
Short and crisp..
Keep it up..

[theresheblows]

You explained it very well and simply. Get my up vote and I will recommend you.

[sajidimam]

Thanks a lot..Absolutely to the point and easily explained...

[rhyoncalebfozsantos]

This is exactly what I was looking for. Thank you!

[InspiringThings]

You saved me hours of research! Thanks!!!!