Skip to content
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. |
© 2020 – 2023 learnspreadsheet.com