Subtotal Sum function vs Sum function in excel.
#excel #exceltips #exceltricks
Here's a brief explanation of the difference between SUM and SUBTOTAL functions in Excel:
SUM Formula: Adds all numbers in a specified range, regardless of any filtering. It totals everything, visible or hidden.
SUBTOTAL (SUM): Only sums the visible cells in a filtered range, ignoring hidden rows. This is especially useful when you're working with filtered data and need to exclude hidden or collapsed rows from the calculation.
In short, use SUM for an overall total, and SUBTOTAL when you want to sum only the visible data after applying filters.
#exceltipsandtricks #formula #tutorial #shorts #excelshorts