SUBTOTAL
Totals or averages only the rows left visible after a filter, with the function chosen by a number first, then the range: 1 AVERAGE, 2 COUNT, 3 COUNTA, 4 MAX, 5 MIN, 9 SUM.
When to use
Use it instead of SUM or AVERAGE under a filtered list, because those still include hidden rows. Point it at the whole column range so the total does not miss rows when the filter changes.
See Lec 01.