Countif on Checkbox column type

Hi, I am trying to get the % of tasks complete.

The column is a checkbox type.

This allows me to get the number as long as all columns are 1 (checked) or 0 (unchecked) 

=ROUND(100 * (COUNTIFS(ES2:ES36, 1) / COUNT(ES2:ES36))) + "%"


I need to add a Count if ES2:ES36 contains only 1 or 0, so if the column is set to N/A then the formula does not count it as part of the total.


Screen Shot 2019-10-04 at 15.51.12.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!