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.
SUBTOTAL function refers to the type of operational function as a function number. There are eleven functions offered by the
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:
Example 1 — The data range unfiltered:
Example 2 — Column A filtered between dates:
Example 3 — Column B filtered for a single item:
Example 4 — Column C filtered for numbers greater than 40:
Leave a Reply