Countif on Checkbox column type

dolores_ken

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.

Thanks!

Paul Newcome

You would change the second portion COUNT to a COUNTIFS and include the criteria.

 

=ROUND(100 * (COUNTIFS(ES2:ES36, 1) / COUNTIFS(ES2:ES36, <> "N/A"))) + "%"

dolores_ken

Thanks Paul, I did so but still get an error.

See the screenshot below. Thanks!