Functions

Built-In Functions

Hierarchy Functions

Name	Inputs	Purpose
ANCESTORCELLS	descendent cell	Returns all ancestor cell values above the given cell in a row hierarchy.
CHILDCELLS	parent cell	Returns all first-level child cell values below the given parent cell in a row hierarchy.
DESCENDANTCELLS	ancestor cell	Returns all descendant cell values below the given cell in the row hierarchy.
PARENTCELL	child cell	Returns the parent cell value above the given cell in the row hierarchy.

Math Functions

Name	Inputs	Purpose
SUM	numbers	Adds numbers.
SUBTOTAL	function number, numbers	Performs a variety of functions based on the function number

Statistical Functions

Name	Inputs	Purpose
AVERAGE	numbers	Calculates the mean of a set of numbers.
AVERAGEA	values	Calculates the mean of a set of values.