Return cell value generated by SUM formula as a number

Zyang

Is there a way to return the numerical value of a cell that contains a formula that is counting the number of checked boxes in its children cells?  My current formula in the cell is: ="Complete: " + SUM(COUNTIF(CHILDREN(), 1) + COUNTIF(CHILDREN(Complete96), 1))

in order to count the number of checked boxes in all children across multiple hierarchies, i.e., "Complete: #" 

I tried the N() and Abs() functions with no success. 

Thank you!

Andrée Starå

Hi,

Depending on your sheet structure I would recommend to sum the children of each section and then sum the children from the first parent. You would have to put the formula in each parent (except the top one that will be just for summing the children) to count the checked boxes.

If you could share a screenshot, I can help more efficiently.

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

="Complete: " + SUM(VALUE(COUNTIF(CHILDREN(), 1)) + VALUE(COUNTIF(CHILDREN(Complete96), 1)))

 

Try using the VALUE function to ensure the individual portions are actually generating numbers to add together within your SUM() instead of a text string.