Checkbox N/A % roll up

Luis Vega

HI,

 

Was hoping to modify this fomula to ignore N/A cells (in turn, removing the cell from the % rollup) in a checkbox column.

 

=ROUND(IF(COUNTIF(CHILDREN(), 1) / COUNT(CHILDREN()) > 0, COUNTIF(CHILDREN(), 1) / COUNT(CHILDREN()), 0) * 100, 0) + "%"

 

appreciate it!

J. Craig Williams

Luis,

 

This should work:

 

=ROUND(IF(COUNT(CHILDREN()) > 0, COUNTIF(CHILDREN(), 1) / (COUNT(CHILDREN()) - COUNTIF(CHILDREN(), "N/A")), 0) * 100, 0) + "%"

 

Note that I changed your IF condition as you likely don't need to determine if the count percentage > 0 but rather that you have children at all.

 

Craig

 

 

 

 

Luis Vega

Huge thanks Craig!