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

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 |  |  | 8 | 4 | 3 | 3 | 1 | 8 | 7 | 6 | 8 | 6 | 6 | 5 | 2 | 1
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 |  |  | 3 | 11 | 1 | 1 | 5 | 6 | 1 | 7 | 9 | 8 | 6 | 6 | 2 | 2
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 |  |  | 7 | 7 | 6 | 0 | 6 | 3 | 6 | 12 | 3 | 4 | 6 | 6 | 2 | 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 |  |  | 9 | 9 | 1 | 4 | 6 | 10 | 8 | 9 | 6 | 5 | 0 | 0 | 0 | 1
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 |  |  | 5 | 11 | 2 | 2 | 8 | 8 | 5 | 4 | 12 | 6 | 2 | 0 | 0 | 3
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 |  |  | 8 | 11 | 9 | 6 | 1 | 1 | 9 | 7 | 4 | 5 | 3 | 2 | 2 | 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 |  |  | 10 | 16 | 4 | 8 | 3 | 8 | 3 | 7 | 3 | 5 | 1 | 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 |  |  | 7 | 12 | 2 | 3 | 6 | 8 | 7 | 9 | 5 | 5 | 1 | 0 | 0 | 3
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 |  |  | 14 | 10 | 2 | 8 | 6 | 1 | 6 | 7 | 6 | 4 | 1 | 0 | 0 | 3
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 |  |  | 7 | 13 | 4 | 3 | 2 | 5 | 9 | 6 | 4 | 5 | 3 | 2 | 3 | 2
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 |  |  | 5 | 8 | 3 | 5 | 5 | 4 | 13 | 6 | 3 | 3 | 5 | 5 | 3 | 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 |  |  | 8 | 9 | 1 | 6 | 7 | 4 | 6 | 5 | 3 | 4 | 5 | 5 | 3 | 2
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 |  |  | 6 | 6 | 7 | 3 | 3 | 4 | 6 | 8 | 4 | 3 | 5 | 5 | 3 | 5
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 |  |  | 7 | 7 | 6 | 8 | 7 | 7 | 3 | 3 | 4 | 9 | 2 | 0 | 0 | 5