Spreadsheet: 98922d1297737982-excel-2007-countifs-does-not-work-across-a-range-book2
Sheet: CMS

 |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 |  |  |  |  |  | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12 | P13 | YTD |  | >90 | all scores | %
 |  |  |  | #>=90% | Blank
 |  |  |  |  | SH2
 |  |  |  |  |  | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12 | P13 | YTD
 | SH3 |  |  |  |  | 96 | 98.5
 | SH3 |  |  |  |  | 95.5 | 97.5
 | SH3 |  |  |  |  | 84.5 | 98
 | SH3 |  |  |  |  | 57 | 92.5
 | SH3 |  |  |  |  | 69 | 78
 | SH3 |  |  |  |  | 73 | 73.5
 | SH3 |  |  |  |  | 71 | 73
 | SH3 |  |  |  |  | 46 | 93.5
 | SH3 |  |  |  |  | 68.5 | 69
 | SH3 |  |  |  |  | 79 | 50.5
 | SH3 |  |  |  |  | 49.5 | 73
 | SH7 |  |  |  |  | 98 | 94
 | SH7 |  |  |  |  | 94 | 96
 | SH7 |  |  |  |  | 94 | 94
 | SH7 |  |  |  |  | 94 | 91.5
 | SH7 |  |  |  |  | 88 | 90
 | SH7 |  |  |  |  | 94 | 81
 | SH7 |  |  |  |  | 89 | 84
 | SH7 |  |  |  |  | 72 | 77.5
 | SH7 |  |  |  |  | 67.5 | 79.5
 | SH7 |  |  |  |  | 52 | 87
 | SH7 |  |  |  |  | 66.5 | 69.5
 | SH7 |  |  |  |  | 52 | 83.5
 | SH7 |  |  |  |  | 61 | 73.5
 | SH7 |  |  |  |  | 72 | 48.5
 | SH2 |  |  |  |  | 98 | 98
 | SH2 |  |  |  |  | 98 | 98
 | SH2 |  |  |  |  | 97.5 | 97
 | SH2 |  |  |  |  | 95 | 98
 | SH2 |  |  |  |  | 96.5 | 96
 | SH2 |  |  |  |  | 97 | 95
 | SH2 |  |  |  |  | 97 | 95
 | SH2 |  |  |  |  | 97.5 | 93.5
 | SH2 |  |  |  |  | 97.5 | 93
 | SH2 |  |  |  |  | 97.5 | 91.5
 | SH2 |  |  |  |  | 91 | 97
 | SH2 |  |  |  |  | 95 | 92.5
 | SH2 |  |  |  |  | 88 | 97.5
 | SH2 |  |  |  |  | 97.5 | 87.5
 | SH2 |  |  |  |  | 99 | 85.5
 | SH2 |  |  |  |  | 93.5 | 90
 | SH2 |  |  |  |  | 86 | 96
 | SH2 |  |  |  |  | 86 | 95.5
 | SH2 |  |  |  |  | 90 | 89.5
 | SH2 |  |  |  |  | 83 | 95.5
 | SH2 |  |  |  |  | 97 | 76
 | SH2 |  |  |  |  | 90.5 | 80.5
 | SH2 |  |  |  |  | 76 | 93
 | SH2 |  |  |  |  | 97 | 71.5
 | SH2 |  |  |  |  | 96 | 71.5
 | SH2 |  |  |  |  | 89 | 74
 | SH2 |  |  |  |  | 84.5 | 70.5
 | SH2 |  |  |  |  | 81 | 68.5
 | SH2 |  |  |  |  | 59 | 89
 | SH2 |  |  |  |  | 56.5 | 79
 | SH2 |  |  |  |  | 28 | 94
 | SH2 |  |  |  |  | 46 | 68.5
 | SH2 |  |  |  |  | 49 | 38.5
 | SH2
 | SH2 |  |  |  |  | 98 | 98
 | SH2 |  |  |  |  | 98 | 98
 | SH2 |  |  |  |  | 97 | 98
 | SH2 |  |  |  |  | 97.5 | 97
 | SH2 |  |  |  |  | 97 | 97
 | SH2 |  |  |  |  | 96.5 | 96.5
 | SH2 |  |  |  |  | 97.5 | 95.5
 | SH2 |  |  |  |  | 98.5 | 94.5
 | SH2 |  |  |  |  | 94 | 97
 | SH2 |  |  |  |  | 96.5 | 94.5
 | SH2 |  |  |  |  | 97 | 92.5
 | SH2 |  |  |  |  | 95 | 93.5
 | SH2 |  |  |  |  | 97.5 | 90.5
 | SH2 |  |  |  |  | 89 | 98
 | SH2 |  |  |  |  | 97 | 88
 | SH2 |  |  |  |  | 98 | 86.5
 | SH2 |  |  |  |  | 93 | 91
 | SH2 |  |  |  |  | 88.5 | 94
 | SH2 |  |  |  |  | 84.5 | 95.5
 | SH8 |  |  |  |  | 89 | 91
 | SH8 |  |  |  |  | 78 | 98.5
 | SH8 |  |  |  |  | 81.5 | 95
 | SH8 |  |  |  |  | 98 | 78
 | SH8 |  |  |  |  | 98 | 77
 | SH8 |  |  |  |  | 76.5 | 98
 | SH8 |  |  |  |  | 87 | 87.5
 | SH8 |  |  |  |  | 96 | 78
 | SH8 |  |  |  |  | 98 | 75
 | SH8 |  |  |  |  | 98 | 74.5
 | SH8 |  |  |  |  | 77.5 | 94.5
 | SH8 |  |  |  |  | 75 | 96.5
 | SH8 |  |  |  |  | 96.5 | 75
 | SH8 |  |  |  |  | 96 | 75
 | SH8 |  |  |  |  | 88 | 82.5
 | SH8 |  |  |  |  | 95 | 75
 | SH8 |  |  |  |  | 75 | 94.5
 | SH8 |  |  |  |  | 74.5 | 94
 | SH8 |  |  |  |  | 97.5 | 69
 | SH8 |  |  |  |  | 86 | 75.5
 | SH8 |  |  |  |  | 91.5 | 63
 | SH8 |  |  |  |  | 85.5 | 67
 | SH8 |  |  |  |  | 49.5 | 85
 | SH8 |  |  |  |  | 29 | 79
 | SH8 |  |  |  |  | 98 | 98.5
 | SH8 |  |  |  |  | 97.5 | 98.5
 | SH8 |  |  |  |  | 96.5 | 98.5
 | [NAME] |  |  |  |  | 96 | 98
 | [NAME] |  |  |  |  | 97.5 | 97
 | [NAME] |  |  |  |  | 96 | 98
 | [NAME] |  |  |  |  | 96 | 97.5
 | [NAME] |  |  |  |  | 96.5 | 97
 | [NAME] |  |  |  |  | 98 | 95.5
 | [NAME] |  |  |  |  | 98 | 94.5
 | [NAME] |  |  |  |  | 94 | 98
 | [NAME] |  |  |  |  | 94.5 | 97.5
 | [NAME] |  |  |  |  | 99 | 91
 | [NAME] |  |  |  |  | 96 | 93.5
 | [NAME] |  |  |  |  | 92 | 96.5
 | [NAME] |  |  |  |  | 93.5 | 95
 | [NAME] |  |  |  |  | 93 | 95
 | [NAME] |  |  |  |  | 91 | 96.5
 | [NAME] |  |  |  |  | 99 | 88
 | [NAME] |  |  |  |  | 98 | 91
 | [NAME] |  |  |  |  | 90.5 | 95.5
 | [NAME] |  |  |  |  | 89.5 | 95
 | [NAME] |  |  |  |  | 87.5 | 96
 | [NAME] |  |  |  |  | 88.5 | 95
 | [NAME] |  |  |  |  | 87.5 | 95.5
 | [NAME] |  |  |  |  | 82.5 | 95
 | [NAME] |  |  |  |  | 81.5 | 95.5
 | [NAME] |  |  |  |  | 88.5 | 88.5
 | [NAME] |  |  |  |  | 98 | 78
 | [NAME] |  |  |  |  | 81 | 94
 | [NAME] |  |  |  |  | 85 | 87
 | [NAME] |  |  |  |  | 96 | 74.5
 | [NAME] |  |  |  |  | 70.5 | 97
 | [NAME] |  |  |  |  | 68 | 95.5
 | [NAME] |  |  |  |  | 72 | 90
 | [NAME] |  |  |  |  | 96 | 61.5
 | [NAME] |  |  |  |  | 96.5 | 58.5
 | [NAME] |  |  |  |  | 71.5 | 81