Tom’s Tutorials For Excel: Subtotaling Filtered Data
SUBTOTAL function you can perform mathematical operations on visible filtered data.
SUBTOTAL function wants two pieces of information from you:
(1) The type of operation (SUM, AVERAGE, and so on) you want to perform.
(2) The range of cells you are subtotaling.
The following pictured examples show five common functions at work:
AVERAGE, SUM, COUNT, MIN, and
SUBTOTAL formulas are the same in all pictured examples.
In cell F1 for Average:
In cell I1 for Sum:
In cell L1 for Count:
In cell O1 for Min:
In cell R1 for Max: