Microsoft Office Tutorials and References
In Depth Information
Using AGGREGATE to Ignore Error Cells or Filtered Rows
Figure 11.4.
Figure 11.4. Using a
Using a 2 oor 3 as the
as the options
options argument for
argument for AGGREGATE
the function to ignore error cells in a range.
You can also use the function to ignore cells hidden by a filter. Whereas the
old SUBTOTAL function enabled you to do this for 11 calculation functions,
the AGGREGATE function adds eight new functions to the list.
Table 11.5 shows the 19 functions available in the AGGREGATE function.
This list mirrors the 11 functions available in SUBTOTAL (arranged alpha-
betically to match those in the SUBTOTAL function) and then eight new func-
tions arranged in order of popularity.
Search JabSto ::

Custom Search