What is the purpose of the SUBTOTAL function versus SUM in Excel?

Question

Microsoft Excel — Medium

What is the purpose of the SUBTOTAL function versus SUM in Excel?

Accepted Answer

The SUBTOTAL function's flexibility in ignoring hidden or filtered rows, depending on the function number used, sets it apart from SUM. This distinction is crucial when working with dynamic datasets. Unlike SUM, which includes all cells, SUBTOTAL offers more control. Its functionality is not about dividing totals or using different syntax.