Get the Sum of Filtered Data in Excel (Using SUBTOTAL Formula) скачать в хорошем качестве

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