MTaylor’s Profile

Community member since August 2017

points
10

1

here are the formulas and a look at the Spreadhseet.

The Column labeled Column has the following formula

=SUM((COUNTIF(CHILDREN(Passed10), 1) / SUM(COUNT(CHILDREN(Passed10)))))

 

The current formula in the Status column for the Exception Rules row10 is =IF(Column10 = 1, "Pass", IF(Column10 = 0, "Not