Function Subtotal Sum Visible Cells and Filtered Cells (New Update 2021)

In this video I have discussed how efficiently subtotal function in excel can be used. Subtotal function will display the sum of values based on the selection, either using filter or visible cells. I have also discussed the difference between the number 9 and 109 in subtotal. Subtotal function is a very good tool which is used to get the sum of values from columns, sometimes we get difficulties if few rows are hidden and we need the sum of visible cells only. I have explained how to solve this problem. I have also discussed, how to get sum from filtered data. Please watch the full video and if you like the video, please hit like and subscribe this channel.
Sum of visible cells using subtotal function, sum of filtered data using subtotal function, shortcut of subtotal function, subtotal function uses, how to use subtotal function in excel, excel how to sum only visible cells, how to sum only filter data, perfect dynamic subtotal function, subtotal 9 and 109, why use 109 in subtotal function, perfect use of subtotal function.

Other Related Videos You May Watch:

Links

#excel #tutorial #subtotal