Рет қаралды 1,615
SUM only visible cells in excel
To subscribe to the channel, click on this link
www.youtube.co...
In this educational video, we will show the difference between the functions sum, subtotal(sum 9), subtotal(sum109), aggregate
In Excel
We explain which of these functions interacts with the filter, which interacts with hiding rows, and which does not interact with the filter or with hiding rows and cells in Excel.