Spreadsheet: 126687d1319824078-count-cells-in-a-row-depending-on-value-in-different-row-corresponding-column-act-practicenonames
Sheet: lookup

english | scale score | Item # | UM1,RH2 | UMCORRECT | UMSUB | RHCORRECT | RHSUB |  |  | mathematics | scale score |  | reading | scale score |  | science | scale score
75 | 36 | 75 | 2 | 40 | 18 | 35 | 18 |  |  | 60 | 36 |  | 40 | 36 |  | 40 | 36
74 | 35 | 74 | 2 | 39 | 18 | 34 | 17 |  |  | 59 | 35 |  | 39 | 35 |  | 39 | 35
73 | 35 | 73 | 2 | 38 | 18 | 33 | 17 |  |  | 58 | 34 |  | 38 | 34 |  | 38 | 33
72 | 34 | 72 | 1 | 37 | 17 | 32 | 16 |  |  | 57 | 33 |  | 37 | 33 |  | 37 | 32
71 | 34 | 71 | 2 | 36 | 16 | 31 | 15 |  |  | 56 | 33 |  | 36 | 32 |  | 36 | 30
70 | 33 | 70 | 2 | 35 | 16 | 30 | 15 |  |  | 55 | 32 |  | 35 | 31 |  | 35 | 29
69 | 32 | 69 | 2 | 34 | 15 | 29 | 14 |  |  | 54 | 31 |  | 34 | 30 |  | 34 | 28
68 | 31 | 68 | 1 | 33 | 14 | 28 | 13 |  |  | 53 | 30 |  | 33 | 29 |  | 33 | 28
67 | 31 | 67 | 1 | 32 | 13 | 27 | 13 |  |  | 52 | 30 |  | 32 | 29 |  | 32 | 27
66 | 30 | 66 | 1 | 31 | 13 | 26 | 12 |  |  | 51 | 29 |  | 31 | 28 |  | 31 | 26
65 | 29 | 65 | 1 | 30 | 12 | 25 | 12 |  |  | 50 | 29 |  | 30 | 27 |  | 30 | 26
64 | 28 | 64 | 2 | 29 | 12 | 24 | 11 |  |  | 49 | 28 |  | 29 | 26 |  | 29 | 25
63 | 28 | 63 | 1 | 28 | 11 | 23 | 11 |  |  | 48 | 28 |  | 28 | 25 |  | 28 | 25
62 | 27 | 62 | 1 | 27 | 11 | 22 | 10 |  |  | 47 | 27 |  | 27 | 25 |  | 27 | 24
61 | 26 | 61 | 1 | 26 | 10 | 21 | 10 |  |  | 46 | 27 |  | 26 | 24 |  | 26 | 24
60 | 26 | 60 | 2 | 25 | 10 | 20 | 10 |  |  | 45 | 27 |  | 25 | 23 |  | 25 | 23
59 | 25 | 59 | 1 | 24 | 9 | 19 | 9 |  |  | 44 | 26 |  | 24 | 23 |  | 24 | 22
58 | 25 | 58 | 1 | 23 | 9 | 18 | 9 |  |  | 43 | 26 |  | 23 | 22 |  | 23 | 22
57 | 24 | 57 | 1 | 22 | 8 | 17 | 8 |  |  | 42 | 26 |  | 22 | 21 |  | 22 | 21
56 | 24 | 56 | 1 | 21 | 8 | 16 | 8 |  |  | 41 | 25 |  | 21 | 20 |  | 21 | 21
55 | 23 | 55 | 2 | 20 | 8 | 15 | 8 |  |  | 40 | 25 |  | 20 | 20 |  | 20 | 20
54 | 23 | 54 | 2 | 19 | 7 | 14 | 7 |  |  | 39 | 24 |  | 19 | 19 |  | 19 | 20
53 | 22 | 53 | 2 | 18 | 7 | 13 | 7 |  |  | 38 | 24 |  | 18 | 18 |  | 18 | 19
52 | 22 | 52 | 2 | 17 | 6 | 12 | 6 |  |  | 37 | 24 |  | 17 | 17 |  | 17 | 18
51 | 21 | 51 | 1 | 16 | 6 | 11 | 6 |  |  | 36 | 23 |  | 16 | 17 |  | 16 | 18
50 | 21 | 50 | 1 | 15 | 5 | 10 | 5 |  |  | 35 | 23 |  | 15 | 16 |  | 15 | 17
49 | 21 | 49 | 1 | 14 | 5 | 9 | 5 |  |  | 34 | 22 |  | 14 | 15 |  | 14 | 16
48 | 20 | 48 | 2 | 13 | 5 | 8 | 4 |  |  | 33 | 22 |  | 13 | 14 |  | 13 | 15
47 | 20 | 47 | 1 | 12 | 4 | 7 | 4 |  |  | 32 | 21 |  | 12 | 14 |  | 12 | 14
46 | 20 | 46 | 2 | 11 | 4 | 6 | 3 |  |  | 31 | 21 |  | 11 | 13 |  | 11 | 13
45 | 19 | 45 | 2 | 10 | 3 | 5 | 3 |  |  | 30 | 20 |  | 10 | 12 |  | 10 | 12
44 | 19 | 44 | 2 | 9 | 3 | 4 | 2 |  |  | 29 | 20 |  | 9 | 12 |  | 9 | 11
43 | 19 | 43 | 2 | 8 | 2 | 3 | 2 |  |  | 28 | 19 |  | 8 | 11 |  | 8 | 10
42 | 18 | 42 | 2 | 7 | 2 | 2 | 1 |  |  | 27 | 19 |  | 7 | 10 |  | 7 | 10
41 | 18 | 41 | 2 | 6 | 2 | 1 | 1 |  |  | 26 | 19 |  | 6 | 10 |  | 6 | 9
40 | 17 | 40 | 2 | 5 | 2 | 0 | 1 |  |  | 25 | 18 |  | 5 | 8 |  | 5 | 8
39 | 17 | 39 | 2 | 4 | 1 |  |  |  |  | 24 | 18 |  | 4 | 7 |  | 4 | 7
38 | 16 | 38 | 1 | 3 | 1 |  |  |  |  | 23 | 17 |  | 3 | 6 |  | 3 | 6
37 | 16 | 37 | 1 | 2 | 1 |  |  |  |  | 22 | 17 |  | 2 | 4 |  | 2 | 1
36 | 16 | 36 | 2 | 1 | 1 |  |  |  |  | 21 | 17 |  | 1 | 2 |  | 1 | 3
35 | 15 | 35 | 1 | 0 | 1 |  |  |  |  | 20 | 16 |  | 0 | 1 |  | 0 | 1
34 | 15 | 34 | 2 |  |  |  |  |  |  | 19 | 16
33 | 15 | 33 | 1 |  |  |  |  |  |  | 18 | 16
32 | 14 | 32 | 1 |  |  |  |  |  |  | 17 | 16
31 | 14 | 31 | 1 |  |  |  |  |  |  | 16 | 15
30 | 14 | 30 | 1 |  |  |  |  |  |  | 15 | 15
29 | 13 | 29 | 1 |  |  |  |  |  |  | 14 | 15
28 | 13 | 28 | 2 |  |  |  |  |  |  | 13 | 14
27 | 12 | 27 | 2 |  |  |  |  |  |  | 12 | 14
26 | 12 | 26 | 2 |  |  |  |  |  |  | 11 | 14
25 | 11 | 25 | 1 |  |  |  |  |  |  | 10 | 13
24 | 11 | 24 | 1 |  |  |  |  |  |  | 9 | 13
23 | 10 | 23 | 1 |  |  |  |  |  |  | 8 | 12
22 | 10 | 22 | 2 |  |  |  |  |  |  | 7 | 12
21 | 9 | 21 | 1 |  |  |  |  |  |  | 6 | 11
20 | 9 | 20 | 1 |  |  |  |  |  |  | 5 | 10
19 | 8 | 19 | 2 |  |  |  |  |  |  | 4 | 9
18 | 8 | 18 | 1 |  |  |  |  |  |  | 3 | 8
17 | 8 | 17 | 1 |  |  |  |  |  |  | 2 | 6
16 | 7 | 16 | 2 |  |  |  |  |  |  | 1 | 4
15 | 7 | 15 | 1 |  |  |  |  |  |  | 0 | 1
14 | 7 | 14 | 1
13 | 6 | 13 | 2
12 | 6 | 12 | 1
11 | 6 | 11 | 1
10 | 5 | 10 | 2
9 | 5 | 9 | 1
8 | 5 | 8 | 2
7 | 4 | 7 | 2
6 | 4 | 6 | 1
5 | 3 | 5 | 2
4 | 3 | 4 | 1
3 | 2 | 3 | 1
2 | 1 | 2 | 2
1 | 1 | 1 | 1
0 | 1 | 0