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!
