Скачать или смотреть Get the Sum of Filtered Data in Excel (Using SUBTOTAL Formula).

In this tutorial, you will learn to sum filter data. 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

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

#excel #excelcourse #tips #exceltutorial #free #onlineclasses #online