Скачать или смотреть How to sum only filtered (visible) cells in Excel?

How to sum only filtered (visible) cells in Excel?

To sum only the visible cells after applying a filter in Excel, use the `SUBTOTAL` function. This function ignores hidden rows. Use the formula `=SUBTOTAL(109, range)` where `range` is the range of cells you want to sum. The `109` argument tells `SUBTOTAL` to calculate the sum while excluding values in hidden rows. If you use `9` instead of `109`, it will include manually hidden rows, but still ignore filtered rows. This function dynamically adjusts the sum as you apply different filters to your data, ensuring you're always summing only the currently visible cells.

--------------

Video link:    • How to sum only filtered (visible) cells i...  
Channel link:    / @heyinsights  

Have questions or thoughts? Leave a comment below. Thank you! 😃