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


Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/

⚙️ Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial