Count Descendants


Trying to figure out formula to count descendants if value is greater than zero. This calculation is all in one column. Not sure were I'm going wrong but this seems like it should be a simple one. Any help would be appreciated.


  • KPH
    KPH ✭✭✭✭✭✭

    Does this do what you want:

    =COUNT(DESCENDANTS([Primary Column]@row))

    This counts the number of descendants of the current row. If a row has 0 descendants it returns 0.

    If you prefer blank to 0 you can put this formula within an IF to only display the answer if the answer is greater than 0.

    =IF(COUNT(DESCENDANTS([Primary Column]@row)) > 0, COUNT(DESCENDANTS([Primary Column]@row)))