ANCESTORS Function

Used within another function to reference all of the ancestors in a cell’s hierarchy.
Sample Usage
COUNT(ANCESTORS([Task Name]4))
Syntax
ANCESTORS(
  • [
    reference
    ]
)
  • reference
    —[optional]
    The cell for which you want the ancestors. If no cell is specified, the function references the ancestors of the current cell.
Related Functions
CHILDREN
PARENT
IF
COUNTIF
COUNTIFS
SUMIF
SUMIFS
Was this article helpful?
YesNo