Get the Sum of Filtered Data in Excel (Using SUBTOTAL Formula)
331.6 هزار بار بازدید -
5 سال پیش
-
When you filter data, getting
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
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
5 سال پیش
در تاریخ 1398/07/09 منتشر شده
است.
331,610
بـار بازدید شده