Excel offers many functions for dealing with basic math, dates and times, and text. This chapter describes the functions found under the Date & Time icon and the Math & Trig icon on the Formulas tab.
A few of the new functions in Excel 2010 fall into this chapter:
AGGREGATE—Provides a way to ignore error values, other subtotals, and/or filtered rows in 17 other functions. Whereas
SUBTOTAL provided a way to ignore rows hidden in a filter for 11 functions, the
AGGREGATE function adds median, mode, percentile, large, small, and quartile functions. Also, the ability to use an array gives you the possibility of extending the
SUMIFS concept to min, max, median, and so on.