I am trying to combine multiple countifs and am not getting my desired amount. What I am trying to do is take multiple sets of criteria (departments) from the same column and then look at an additional column for a "YES" response and then divide all of those counts by a total count of all the...