There are several reasons to use SUBTOTAL instead of SUM when inserting subtotals in your spreadsheet.

Microsoft Excel's 11 summary functions range from basic computations to statistical calculations. You can add the sum of your values, count all or only numeric values, average them, find the ...