Hello! I am hoping someone can help me. I am building a sheet that has several layers of parent and children sets using many different column properties to meet a specific client need. I have to use checkboxes to signify the type of business and then need to show total numbers by region, by country, and then by category. I was able to use the =COUNTIFS(CHILDREN(), 1) + "" formula to total the checkboxes under the region parent row but now that I am trying to total the regional rows to show a SUM in the country (and then again for category), I am running into issues.
When using a simple =SUM(CHILDREN()) formula, nothing happens and the empty checkbox just remains. When I tried manually totaling each cell, I have gotten errors as well as an odd situation where instead of i.e. 1 + 2 + 3 totaling 6, it produced 123. Any help would be greatly appreciated!
