Spreadsheet: 692207d1598179206-formula-issues-viewable-cells-help-sample-excel-file
Sheet: Sheet1

 |  |  |  |  |  |  |  | 0 to 4 | Normal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 11 | 8
 |  |  |  |  |  |  |  | 5 to 6 | Good |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 6 | 5 |  |  | COUNTIFS(AF8:AF49,">=0",AF8:AF49,"<=4")
 |  |  |  |  |  |  |  | 7 to 10 | Bad |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 7 | 6
 |  |  |  |  |  | 11 to 13 | 11 to 13 | 11 to 16 | Sever |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 7 | 14
COUNT |  |  |  | 42 |  |  |  | 14+ | Ext severe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 11 | 9
42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42
Name | Age | Sex | School year | School type | Classes | Computers | So you use | are you trained | Do you want to be trained | rate 1 | rate 2 | rate 3 | rate 4 | rate 5 | rate 6 | rate 7 | rate 8 | rate 9 | rate 10 | rate 11 | rate 12 | rate 13 | rate 14 | rate 15 | rate 16 | rate 17 | rate 18 | rate 19 | rate 20 | rate 21 | Solution 1 | Solution 2 | Solution 3
George | 26-35 years | Male | First | Public | 52 | 1 | No | No | Yes | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 36 | 36 | 36
[NAME] | 36-45 years | Female | Second | Private | 64 | 2 | No | No | Yes | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 13 | 13 | 13
Fred | 26-35 years | Male | Third | Public | 7 | 3 | Yes | No | No | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 23 | 23 | 2
[NAME] | Less than 25 years | Female | Fourth | Private | 45 | 4 | No | No | No | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 27 | 27
George | 36-45 years | Female | Fith | Public | 836 | 5 | Yes | Yes | Yes | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 2
[NAME] | 26-35 years | Female | Sixth | Private | 665.5 | 6 | No | No | No | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 5 | 1
Fred | 56-65 years | Female | First | Public | 52 | 7 | No | Yes | No | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 2
[NAME] | 36-45 years | Female | Fith | Private | 64 | 8 | No | No | Yes | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 3 | 3 | 18
George | 26-35 years | Female | Third | Public | 7 | 9 | No | No | No | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 4 | 4
[NAME] | 46-55 years | Female | Fourth | Private | 45 | 10 | No | Yes | Yes | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 5 | 5 | 5
Fred | 56-65 years | Female | Fith | Public | 836 | 11 | No | No | No | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 6 | 6 | 6
[NAME] | 36-45 years | Female | Sixth | Private | 52 | 12 | Yes | No | No | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 9 | 9
George | 46-55 years | Female | First | Public | 64 | 13 | Yes | No | Yes | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 7 | 7
[NAME] | 36-45 years | Female | Second | Private | 7 | 14 | No | No | No | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 7 | 7 | 8
Fred | 56-65 years | Male | Third | Public | 45 | 15 | No | No | No | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 4 | 11
[NAME] | 36-45 years | Male | Fourth | Private | 836 | 16 | No | No | No | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 3
George | 56-65 years | Female | Fith | Public | 45 | 17 | No | No | No | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 17 | 17 | 17
[NAME] | 46-55 years | Female | Eight | Private | 836 | 18 | No | No | No | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 14 | 14
Fred | 36-45 years | Female | First | Public | 52 | 19 | Yes | No | No | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 16 | 16 | 16
[NAME] | 56-65 years | Female | Second | Private | 64 | 20 | No | No | Yes | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 12 | 12 | 12
George | 46-55 years | Female | Third | Public | 7 | 21 | No | No | Yes | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 1 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 11 | 11
[NAME] | More than 65 years | Male | Fourth | Private | 45 | 22 | No | Yes | No | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 5 | 5
Fred | 56-65 years | Female | Fith | Public | 836 | 23 | No | No | No | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 9 | 9
[NAME] | 46-55 years | Female | Sixth | Private | 52 | 24 | No | No | No | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 23 | 23 | 23
George | 56-65 years | Male | First | Public | 64 | 25 | No | No | No | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 5 | 5
[NAME] | 46-55 years | Female | Second | Private | 7 | 26 | No | No | No | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 12
Fred | 36-45 years | Male | Third | Public | 45 | 27 | No | No | No | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 3
[NAME] | 56-65 years | Female | Fourth | Private | 836 | 28 | No | No | No | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 16 | 16
George | 26-35 years | Male | Fith | Public | 52 | 29 | No | No | No | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 12 | 12
[NAME] | More than 65 years | Female | Sixth | Private | 64 | 30 | No | No | No | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 11 | 11
Fred | 26-35 years | Female | First | Public | 7 | 31 | No | No | No | 0 | 2 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 5 | 5 | 23
[NAME] | 56-65 years | Female | Second | Private | 45 | 32 | No | No | No | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 9 | 9 | 9
George | 46-55 years | Female | Third | Public | 836 | 33 | No | No | No | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 23 | 23 | 23
[NAME] | 26-35 years | Male | Fourth | Private | 52 | 34 | No | Yes | No | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 21 | 8 | 12
Fred | 56-65 years | Female | Fith | Public | 64 | 35 | No | No | Yes | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 19 | 19 | 19
[NAME] | 56-65 years | Male | Sixth | Private | 7 | 36 | No | No | No | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 12 | 12
George | 26-35 years | Male | First | Public | 45 | 37 | No | No | Yes | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13 | 13 | 13
[NAME] | 46-55 years | Female | Second | Private | 836 | 38 | No | No | No | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 7 | 7
Fred | 36-45 years | Female | Third | Public | 52 | 39 | No | No | No | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 21 | 6
[NAME] | 26-35 years | Female | Fourth | Private | 64 | 40 | Yes | No | Yes | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 2
George | 36-45 years | Male | Fith | Public | 7 | 41 | No | No | No | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 12
[NAME] | 46-55 years | Female | Sixth | Private | 45 | 42 | No | Yes | No | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18