Formula -weighted for specific criteria
I have a complicated request. I want to create a formula that will provide a % when a row is designated as a "critical path" item. See screenshot. As a box is checked in the column for each cabin name, I want to get the % to update for those critical checked boxes.
Is there a way to do this? I already have a formula that takes into account the entire sheet, all checkboxes and the formula of percent complete for all boxes checked. But want to separately tally the critical ones too.