Microsoft® Excel® 2010 Formulas & Functions Inside Out

AGGREGATE()

Syntax. This function has two forms:

• AGGREGATE(function_num, options, ref1, ref2,...) (reference form)

• AGGREGATE(function_num, options, array, k) (array form)

Definition. This function returns an aggregate in a list or database.

Arguments

• function_num (required) A number between 1 and 19 that specifies the function to use (see Table 16-2).

  Table 16-2. Possible Values for the function_num Argument

  function_num	Function
  1	AVERAGE()
  2	COUNT()
  3	COUNTA()
  4	MAX()
  5	MIN()
  6	PRODUCT()
  7	STDEV.S()
  8	STDEV.P()
  9	SUM()
  10	VAR.S()
  11	VAR.P()
  12	MEDIAN()
  13	MODE.SNGL()
  14	LARGE()
  15	SMALL()
  16	PERCENTILE.INC()
  17	QUARTILE.INC()
  18	PERCENTILE.EXC()
  19	QUARTILE.EXC()

• options (required) A numerical value that determines which values to ignore in the evaluation range (see ...