Functions

Built-In Functions

Hierarchy Functions

NameInputsPurpose
ANCESTORCELLSdescendent cellReturns all ancestor cell values above the given cell in a row hierarchy.
CHILDCELLSparent cellReturns all first-level child cell values below the given parent cell in a row hierarchy.
DESCENDANTCELLSancestor cellReturns all descendant cell values below the given cell in the row hierarchy.
PARENTCELLchild cellReturns the parent cell value above the given cell in the row hierarchy.

Math Functions

NameInputsPurpose
SUMnumbersAdds numbers.
SUBTOTALfunction number, numbersPerforms a variety of functions based on the function number

Statistical Functions

NameInputsPurpose
AVERAGEnumbersCalculates the mean of a set of numbers.
AVERAGEAvaluesCalculates the mean of a set of values.

© 2020 – 2023 learnspreadsheet.com