Formula - Adding count of parent and children rows

KasandraC

Hi!

I am trying to add the sum of the parent row that has "2024 in the years active + the children row that has "2024".

The current formula only counts children, but would like to add the parent row's active year too: =COUNTIFS(CHILDREN([AM/PM Years Active]@row), HAS(@cell, "2024"))

Paul Newcome

Are you able to provide some screenshots for context?

KasandraC

Thank you! Please see here - I am trying to add the subrows of BeeKeeperAI plus the main row that are active so if the subrow was active the highlighted cell should show 2 instead, since its not active in 2024, it shows 0 but I'm trying to get it to show 1 to count the main Beekeeper row as well.

Paul Newcome

Try this:

=IFERROR(COUNTIFS(CHILDREN([Years Active]@row), HAS(@cell, "2024")), 0) + IF(HAS([Years Active]@row, "2024"), 1, 0)