Subtotal Is Useful

=Subtotal() does subtotalling like you'd do by hand, unlike =sum(), in that it doesn't double-count earlier subtotals.

It also has a lot of extra functionality besides summing.