Sum the number of Grandchildren check boxes
I'm trying to figure out the formula for how to sum the number of check boxes from the parents. I have the children figured out but it is the summing of the parents that isn't working.
(See Picture) I would expect the Retail line to say 3 instead of zero. The formula that I thought would work is ="" + SUM(CHILDREN()) but that isn't work. Any suggestions for what else to use?