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.
Help Article Resources
Check out the Formula Handbook template!