Spreadsheet: 73269d1273885500-counting-in-different-ranges-in-same-worksheet-exampleforum89
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1,2 | 3,4 | 5,6 | 7,8 | 9,10 | 11,12 | 13,14 | 15,16 | 17,18 | 19,20 | 21,22 | 23,24 | 25,26 | 27,28 | 29,30 | 31,32 | 33,34 | 35,36 | 37,38 | 39,40 | 41,42 | 43,44 | 45,46 | 47,48 | 49,50 | 51,52 | 53,54 | 55,56 | 57,58 | 59,60 | 61,62 | 63,64 | 65,66 | 67,68 | 69,70
6 | 1 | 31 | 38 | 42 | 15 | 16 | 36 | 41 | 1 | 16 | 41 | 44 | 47 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 41 | 44 | 47 | 27 | 28 | 29 | 1 | 11 | 22 | 27 | 28 | 29 | 1 | 10 | 12 | 16 | 48 | 2 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 5 | 58 | 59 | 53 | 6 | 28 | 31 | 38 | 42 | 59 | 60 | 61 | 62 | 7 | 4 | 5 | 41 | 48 | 68 |  |  | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
25 | 26 | 41 | 44 | 47 | 6 | 70 | 8 | 69 | 25 | 7 | 8 | 27 | 41 | 48 | 10 | 12 | 16 | 48 | 2 | 6 | 37 | 38 | 24 | 25 | 7 | 8 | 27 | 41 | 48 | 27 | 41 | 43 | 50 | 5 | 8 | 37 | 38 | 39 | 40 | 41 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 53 | 25 | 26 | 41 | 44 | 47 | 59 | 60 | 61 | 62 | 3 | 7 | 9 | 34 | 39 | 30 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 | 11 | 25 | 31 | 50 | 26 | 36 | 37 | 38 | 42 | 3 | 12 | 15 | 34 | 39 | 21 | 22 | 37 | 43 | 5 | 8 | 37 | 38 | 24 | 25 | 3 | 12 | 15 | 34 | 1 | 9 | 10 | 27 | 35 | 6 | 8 | 37 | 38 | 39 | 40 | 41 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 53 | 7 | 11 | 25 | 31 | 50 | 59 | 60 | 61 | 62 | 1 | 2 | 5 | 30 | 36 | 33 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | 9 | 35 | 39 | 42 | 1 | 6 | 27 | 39 | 47 | 1 | 16 | 26 | 30 | 1 | 6 | 17 | 18 | 4 | 7 | 33 | 37 | 39 | 24 | 25 | 1 | 16 | 26 | 30 | 36 | 25 | 33 | 41 | 44 | 47 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 10 | 28 | 40 | 47 | 48 | 47 | 6 | 70 | 8 | 27 | 28 | 29 | 14 | 21 | 22 | 37 | 43 | 5 | 8 | 9 | 3 | 5 | 43 | 44 | 25 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 | 12 | 21 | 26 | 44 | 1 | 9 | 20 | 23 | 30 | 9 | 21 | 30 | 43 | 5 | 6 | 67 | 68 | 15 | 24 | 28 | 44 | 47 | 24 | 25 | 9 | 21 | 30 | 43 | 44 | 18 | 29 | 39 | 41 | 5 | 8 | 37 | 7 | 8 | 27 | 41 | 48 | 43 | 3 | 7 | 25 | 45 | 50 | 49 | 50 | 51 | 52 | 41 | 44 | 47 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 6 | 4 | 9 | 40 | 43 | 68 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
12 | 17 | 31 | 32 | 40 | 11 | 18 | 35 | 38 | 42 | 6 | 15 | 16 | 40 | 5 | 8 | 1 | 10 | 12 | 16 | 48 | 2 | 6 | 37 | 38 | 6 | 15 | 16 | 5 | 8 | 8 | 6 | 10 | 21 | 45 | 49 | 47 | 3 | 12 | 15 | 34 | 39 | 43 | 1 | 10 | 12 | 32 | 33 | 49 | 50 | 51 | 52 | 53 | 12 | 17 | 31 | 32 | 40 | 59 | 60 | 61 | 62 | 7 | 2 | 4 | 35 | 43 | 27 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6 | 7 | 13 | 28 | 47 | 2 | 3 | 15 | 18 | 32 | 7 | 9 | 18 | 35 | 6 | 8 | 14 | 21 | 22 | 37 | 43 | 5 | 8 | 37 | 38 | 7 | 9 | 18 | 3 | 9 | 20 | 5 | 6 | 16 | 23 | 27 | 37 | 1 | 16 | 26 | 30 | 36 | 43 | 6 | 10 | 16 | 26 | 49 | 49 | 50 | 51 | 27 | 28 | 29 | 1 | 10 | 12 | 16 | 48 | 2 | 6 | 37 | 1 | 4 | 9 | 31 | 36 | 41 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | 24 | 31 | 47 | 6 | 70 | 8 | 69 | 25 | 26 | 1 | 7 | 17 | 31 | 1 | 9 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 1 | 7 | 17 | 4 | 9 | 10 | 15 | 16 | 21 | 36 | 38 | 37 | 9 | 21 | 30 | 43 | 44 | 43 | 10 | 29 | 30 | 45 | 49 | 49 | 50 | 51 | 27 | 28 | 29 | 14 | 21 | 22 | 37 | 43 | 5 | 8 | 37 | 2 | 9 | 8 | 38 | 50 | 68 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | 8 | 11 | 17 | 50 | 8 | 16 | 19 | 43 | 45 | 2 | 4 | 9 | 38 | 6 | 7 | 17 | 18 | 1 | 4 | 10 | 19 | 23 | 24 | 25 | 2 | 4 | 9 | 1 | 7 | 21 | 1 | 3 | 21 | 32 | 39 | 37 | 6 | 15 | 16 | 40 | 43 | 43 | 1 | 3 | 6 | 18 | 24 | 49 | 50 | 51 | 41 | 44 | 47 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 1 | 3 | 66 | 67 | 68 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6 | 7 | 32 | 37 | 47 | 2 | 6 | 9 | 14 | 26 | 6 | 9 | 14 | 26 | 2 | 5 | 17 | 18 | 14 | 47 | 6 | 70 | 8 | 69 | 25 | 26 | 41 | 44 | 3 | 9 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 7 | 9 | 18 | 35 | 43 | 43 | 5 | 11 | 22 | 35 | 38 | 49 | 50 | 51 | 52 | 53 | 6 | 7 | 32 | 37 | 47 | 59 | 60 | 61 | 62 | 63 | 3 | 5 | 27 | 30 | 36 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | 12 | 24 | 27 | 36 | 8 | 12 | 19 | 33 | 34 | 12 | 19 | 33 | 34 | 5 | 8 | 17 | 18 | 6 | 10 | 21 | 45 | 49 | 24 | 25 | 26 | 27 | 28 | 2 | 6 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 1 | 7 | 17 | 31 | 36 | 43 | 2 | 25 | 32 | 38 | 41 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 6 | 7 | 32 | 33 | 36 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 | 4 | 10 | 19 | 23 | 6 | 70 | 8 | 69 | 14 | 21 | 22 | 37 | 43 | 1 | 7 | 17 | 18 | 5 | 6 | 16 | 23 | 27 | 24 | 25 | 26 | 27 | 28 | 6 | 8 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 2 | 4 | 9 | 38 | 50 | 43 | 10 | 19 | 34 | 45 | 47 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 1 | 5 | 17 | 25 | 40 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14 | 15 | 28 | 35 | 40 | 6 | 70 | 8 | 69 | 10 | 11 | 12 | 13 | 14 | 5 | 6 | 17 | 18 | 15 | 16 | 21 | 36 | 38 | 24 | 25 | 26 | 27 | 28 | 3 | 4 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 3 | 4 | 8 | 44 | 50 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 2 | 6 | 66 | 67 | 68 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | 10 | 13 | 24 | 47 | 17 | 18 | 25 | 34 | 48 | 18 | 25 | 34 | 48 | 2 | 6 | 17 | 18 | 14 | 18 | 19 | 31 | 47 | 6 | 70 | 8 | 69 | 25 | 26 | 41 | 44 | 47 | 27 | 28 | 29 | 14 | 21 | 22 | 37 | 43 | 5 | 8 | 37 | 11 | 13 | 24 | 44 | 49 | 49 | 50 | 51 | 52 | 27 | 28 | 29 | 1 | 10 | 12 | 16 | 48 | 2 | 6 | 37 | 1 | 5 | 66 | 67 | 68 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0