Formula to capture % of boxes not checked

Biiams

For new hire training there are several items they must complete for training requirements to be met. I am trying to figure out a way to show % uncomplete for all open training items (boxes in red that are not checked). Is there a formula to capture % not completed for the entire grid and then a % not complete for each row (employee)?

Paul Newcome

You would first do this on a row by row basis in a helper column with this:

=COUNTIFS([1st Checkbox]@row:[Last Checkbox]@row, @cell = "") / COUNTIFS([1st Checkbox]@row:[Last Checkbox]@row, OR(@cell = "", @cell <> ""))

Then to get the total for the entire sheet, you would average this new helper column.