Subtotal is used to perform statistical functions on a filtered list
the number part determines which function it does - e.g.
If you have a table with sales of ice cream day by day and you want t
look at average sales for mondays
Using autofilter you set select the entries for Mondays
=subtotal(1,sales) would give the average ice cream sales for mondays
Changing the filter would give tuesdays or wednesdays etc. A full lis
of the available subtotal functions can be found in Hel
