Show the sum of ONLY visible cells using SUBTOTAL instead of SUM!

preview_player
Показать описание
Show the sum of ONLY visible cells using SUBTOTAL instead of SUM! Don't you hate it when you filter a spreadsheet and the total number is not only those numbers showing? You can now show the total sum of only the filtered data!
#excel #googlesheets #exceltipsandtricks
Рекомендации по теме