Spreadsheet: 836647d1689562455-need-help-on-countifs-index-and-match-count-index-and-match
Sheet: Summary

 | 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
# | Name/Date | 2023-07-01 00:00:00 |  |  | 2023-07-02 00:00:00 |  |  | 2023-07-03 00:00:00 |  |  | 2023-07-04 00:00:00 |  |  | 2023-07-05 00:00:00 |  |  | 2023-07-06 00:00:00 |  |  | 2023-07-07 00:00:00 |  |  | 2023-07-08 00:00:00 |  |  | 2023-07-09 00:00:00 |  |  | 2023-07-10 00:00:00 |  |  | 2023-07-11 00:00:00 |  |  | 2023-07-12 00:00:00 |  |  | 2023-07-13 00:00:00 |  |  | 2023-07-14 00:00:00
 | Task | SE | ICP | MI | SE | ICP | MI | SE | ICP | MI | SE | ICP | MI | SE | ICP | MI | SE | ICP | MI | SE | ICP | MI | SE | ICP | MI | SE | ICP | MI | SE | ICP | MI | SE | ICP | MI | SE | ICP | MI | SE | ICP | MI | SE | ICP | MI
x | Contoh | 62 | 11.67 | 76.33 | 48.89 | 11.47 | 44.95
1 | Citra Ayunda | 17.57 | 47.38 | 38.44 | 15.27 | 48.4 | 17.78 | 19.65 | 40.51 | 11.54 |  |  |  | 12.54 | 39.16 |  | 10.85 | 40.46 | 10.34 |  |  |  | 18.39 | 41.57 | 13.34 | 13.19 | 37.81 | 11.07 | 11.51 | 39.51 |  |  |  |  | 13.52 | 43.35 | 11.4 | 9.86 | 39.26 | 12.5 | 23.11 | 48.69 | 10.84
2 | Friska Fatmawati |  |  |  | 30.33 | 78.79 | 24.92 | 30.53 | 71.63 | 25.27 | 26.25 | 49.25 | 24.02 |  |  |  | 24.16 | 80.41 | 23.32 | 23.7 | 77.32 | 20.12 | 21.98 | 69.18 | 18.77 |  |  |  | 20.36 | 68.86 | 19.66 | 21.34 | 73.89 | 17.77 |  |  |  | 22.21 | 65.03 | 18.08
3 | [NAME] | 19.26 | 70.71 | 20.1 |  |  |  |  |  |  | 18.09 | 55.61 | 15.75 | 17.24 | 50.84 | 15.81 | 15.14 | 54.82 | 14.74 | 14.47 | 56.19 | 13.46 | 14.51 | 61.45 | 20.2 |  |  |  |  |  |  | 15.24 | 54.4 | 13.54 | 14.56 | 53.81 | 14.34 | 15.28 | 53.22 | 12.99
4 | [NAME] |  |  |  | 19.49 | 52.98 | 16.91 | 19.05 | 50.9 | 18.55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22.11 | 51.17 | 21.22 | 19.34 | 49.89 | 18.92 | 22.44 | 48.49 | 22.63 | 22.08 | 50.16 | 19.77 |  |  |  | 26.64 | 46.73 | 24.39
5 | [NAME] | 24.87 | 68.87 | 19.63 |  |  |  | 22.75 | 52.52 | 20.08 | 16.13 | 38.43 | 13.8 | 18.83 | 47.49 | 14.24 | 15.61 | 56.27 | 15.86 |  |  |  |  |  |  | 14.99 | 68.74 | 13.48 | 16.14 | 40.26 | 14.47 | 15.47 | 47.98 | 14.61 |  |  |  | 17.15 | 41.59 | 13.22 | 18.12 | 41.08 | 12.04
6 | [NAME] |  |  |  | 21.57 | 40.78 | 15.81 | 33.38 | 44.12 | 34.65 |  |  |  | 17.55 | 49.99 | 14.42 | 17.17 | 50.59 | 15.37 | 14.67 | 49.05 | 13.6 | 16.57 | 56.02 | 14.02 |  |  |  |  |  |  | 14.05 | 39.96 | 13.4 | 14.1 | 50.16 | 12.22 | 14.23 | 42.61 | 11.44 | 14.83 | 41.59 | 13.87
7 | [NAME] | 72.46 | 284.58 |  | 73.58 | 153.46 |  | 79.54 | 154 |  |  |  |  | 61.16 | 128.2 |  | 93.31 | 173.74 |  | 86.89 | 174.11 |  |  |  |  | 69.06 | 189.4 |  | 81.87 | 151.69 |  | 45.78 | 98.85 | 86.36 |  |  |  | 51.17 | 112.85 |  | 54.88 | 101.96
8 | [NAME] |  |  |  | 51.83 | 99.17 |  | 47.42 | 107.23 |  | 19.49 | 77.12 |  | 19.69 | 77.7 |  | 21.29 | 85.31 |  |  |  |  |  |  |  | 17.7 | 114.47 |  | 30.78 | 66.67 |  | 27.99 | 64.74 |  | 19.47 | 68.1 |  |  |  |  | 17.68 | 54.32
9 | Ana Qonitatilla
10 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 180.26 |  |  | 89.79
11 | Ananda R.T. | 32.81 | 83.2 |  |  |  |  |  |  |  | 35.12 | 64.39 |  | 37.62 | 79.86 |  | 29.23 | 56.45 |  | 37.55 | 68.01 |  |  |  |  | 30.01 | 104.54 |  | 23.58 | 87.19 |  | 35.49 | 90.5 |  |  |  |  | 37.9 | 93.61 |  | 30.81 | 60.37
12 | Andri Prasetiyo | 54.2 | 161 | 31.12 |  |  |  | 23.39 | 73.48 | 21.92 | 24.11 | 91.47 | 14.77 | 23.41 | 59.98 | 21.4 | 22.16 | 83.23 | 17.89 |  |  |  |  |  |  | 21.84 | 80.5 | 17.34 | 20.47 | 62.16 | 17.38 | 21.57 | 65.71 | 19.19 |  |  |  | 21.1 | 68.51 | 19.67 | 20.17 | 58.9 | 17.42
13 | Ario Arfanto | 30.74 | 84.99 |  |  |  |  |  |  |  | 27.84 | 64.35 |  | 29.07 | 76.58 |  | 25.8 | 68.57 |  | 24.71 | 61.96 |  |  |  |  | 27.19 | 94.41 |  | 25.65 | 51.99 |  | 24.88 | 51.87 |  |  |  |  | 22.32 | 50.32 |  | 25.5 | 67.65
14 | [NAME] | 81.44 | 71.74 | 25.84 |  |  |  | 30.93 | 68.9 | 35.26 | 27.7 | 78.42 | 30.94 |  |  |  | 29.38 | 78.77 | 30.85 | 33.51 | 71.53 | 32.44 |  |  |  | 32.73 | 118.53 | 30.51 | 32.53 | 59.4 | 29.28
15 | [NAME] | 46 | 222.72 |  |  |  |  | 44.71 | 92.77 |  | 40.66 | 94.63 |  | 39.28 | 119.75 |  | 38.48 | 121.39 |  |  |  |  |  |  |  | 52.44 | 134.7 |  | 55.18 | 113.45 |  | 44.05 | 95.03 |  | 43.67 |  |  |  |  |  | 50.81 | 110.43
16 | Devinta Nanda | 19.29 | 39.58 | 17.62 |  |  |  |  |  |  | 15.54 | 38.9 | 13.11 | 15.5 | 37.56 |  | 18.26 | 37.59 |  | 12.42 | 37.26 | 15.46 |  |  |  | 13.84 | 39.32 | 15.02 | 11.11 | 39.84 | 14.49 | 13.14 | 41.14 | 8.79 | 12.66 | 41.23 | 13.86
17 | [NAME] | 19.9 | 63.78 | 21.34 |  |  |  | 20.75 | 58.84 | 27.47 | 20.77 | 52.43 | 16.45 | 21.07 | 60.74 | 22.63 | 20.71 | 53.43 | 18.26 |  |  |  |  |  |  | 21.95 | 65.97 | 15.42 | 19.98 | 52.81 | 25.75 | 23.5 | 60.82 | 21.62 |  |  |  | 20.95 | 53.91 | 20.68 | 20.73 | 63.6 | 16.79
18 | [NAME] | 83.6 | 132.15 |  |  |  |  | 39.29 | 136.06 |  | 29.97 | 122.02 |  |  |  |  | 32.55 | 120.82 |  | 35.71 | 121.23 |  |  |  |  | 32.23 | 119.04 |  | 28.25 | 111.17 |  |  |  |  | 31.66 | 111.09 |  | 42.05 | 111.22 |  | 35.46 | 108.46
19 | [NAME] |  |  |  | 87.18 |  |  | 40.24 | 178.19 |  |  |  |  | 41.92 | 7.72 |  | 52.31 | 37.56 |  | 36.97 | 38.95 |  | 37.63 | 78.73 |  |  |  |  |  |  |  | 37.04 |  |  | 40.11 |  |  | 45.23 | 88.83 |  | 47.95 | 84.74
20 | Dwi Aqlami | 138.52 |  |  |  |  |  | 132.17 | 240.76 |  | 123.16 | 245.32 |  |  |  |  | 98.26 | 322.82 |  | 98.83 | 228.93 |  | 83.16 | 235.38 |  |  |  |  | 79.32 | 208.35 |  | 77.98 | 169.31 |  | 74.16 | 222.25 |  | 67.12 | 206.3
21 | Dwi Kusumastuti | 96.59 | 310.77 |  |  |  |  |  |  |  | 83.47 | 230.43 |  | 60.61 | 248.01 |  | 72.99 | 161.89 |  | 69.58 | 148.29 |  |  |  |  | 57.49 | 257.94 |  |  | 123.99 |  |  |  |  | 81.98 | 236.93 |  | 94.42 | 172.28 |  | 69.05 | 242.48
22 | Dwi Shani |  |  |  | 78.14 | 296.07 |  | 57.19 | 468.81 |  | 48.25 | 139.69 |  |  |  |  | 44.68 | 106.31 |  | 42.22 | 131.97 |  | 43.56 | 141.98 |  |  |  |  | 47.03 | 168.76 |  |  | 151.2 |  |  |  |  |  | 127.01
23 | [NAME] |  |  |  | 28.05 | 69.06 |  | 26.95 | 68.7 |  |  |  |  | 33.43 | 69.11 |  | 34.49 | 68.58 |  | 35.07 | 69.46 |  |  |  |  | 23.96 | 69.32 |  | 31.86 | 65.86 |  | 23.49 | 62.56 |  |  |  |  | 32.06 | 64.2 |  | 24.78 | 60.37
24 | [NAME] |  |  |  | 39.99 | 71.48 |  | 33.81 | 97.19 |  | 27.72 | 48.64 |  |  |  |  | 24.4 | 69.4 |  | 23.86 | 77.05 |  | 24.16 | 66.19 |  |  |  |  | 25.07 | 68.74 |  | 22.65 | 63.77 |  | 23.28 | 57.2 |  | 27.35 | 45.13
25 | [NAME] |  |  |  | 26.16 | 59.8 |  | 23.99 | 62.08 |  | 22.27 | 53.85 |  |  |  |  | 22.58 | 53.77 |  | 22.07 | 54.83 |  | 23.11 | 55.14 |  |  |  |  | 25.16 | 53.38 |  | 21.54 | 53.52 |  | 18.95 | 51.9 |  | 22.81 | 51.63
26 | [NAME] |  |  |  | 265.48 | 441.72 |  | 415 | 388.3 |  |  |  |  | 55.94 | 272.1 |  | 54.08 | 175.53 |  | 44.27 | 161.47 |  |  |  |  | 39.28 | 154.33 |  | 39.3 | 95.63 |  | 40.02 | 138.39 |  | 42.15 | 179.34 |  |  |  |  | 40.9 | 57.97
27 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40.92 | 164.99 |  | 44.06 | 118.8 |  | 41.12 | 123.21 |  |  |  |  | 40.95 | 119.26 |  | 40.27 | 105.95 |  |  |  |  | 41.64 | 95.68 |  | 43.23 | 108.77
28 | [NAME] | 32.01 | 92.87 |  |  |  |  |  |  |  | 28.49 | 65.81 |  | 27.61 | 121.18 |  | 24.78 | 84.61 |  | 24.3 | 72.74 |  |  |  |  | 23.21 | 121.32 |  | 22.84 | 71.74 |  | 21.46 | 77.2 |  |  |  |  | 20.93 | 74.02 |  | 20.16 | 63.19
29 | Mellenia Harianto |  |  |  | 238.91 |  |  | 85.18 |  |  | 36.54 |  |  |  |  |  | 34.7 |  |  | 30.09 |  |  | 27.07 | 197.81 |  |  |  |  | 29.03 | 131.91 |  | 29.74 | 138.43 |  | 31.81 | 189.3 |  | 29.29
30 | [NAME] |  |  |  | 48.17 | 529.67 |  | 123.32 | 253.41 |  | 28.17 | 155.45 |  |  |  |  | 27.69 | 32.17 |  | 36.89 | 55.12 |  | 34.95 | 23.68 |  |  |  |  | 38.71 | 31.99 |  | 34.32 | 30 |  | 38.64 | 22.87 |  | 11.93 | 6.96
31 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 131.12 |  |  | 38.28 |  |  | 33.35
32 | [NAME] | 39.96 | 84.24 |  |  |  |  | 39.77 | 105.25 |  | 28.91 | 74.43 |  | 36.33 | 69.93 |  |  |  |  | 26.78 | 65.21 |  | 28.56 | 75.57 |  |  |  |  | 30.67 | 75.01 |  | 43.98 | 97.6 |  | 25.22 | 64.39 |  |  |  |  | 37.7 | 76.27
33 | [NAME] | 46.44 | 71.29 | 36.11 |  |  |  |  |  |  | 24.83 | 46.65 | 26.42 | 31.69 | 60.92 | 28.87 | 28.68 | 60.78 | 30.31 | 36.23 | 68.43 | 31.6 |  |  |  | 29.76 | 82.77 | 29.74 | 29.11 | 52.73 | 25.43 | 32.76 | 54.47 | 27.19 |  |  |  | 29.95 | 57.13 | 27.89 | 30.27 | 64.58 | 28.9
34 | [NAME] | 53.78 | 351.41 |  |  |  |  | 49.67 | 141.6 |  | 40.56 | 128 |  | 32.46 | 144.83 |  | 38.71 | 121.13 |  |  |  |  |  |  |  | 35.54 | 156.13 |  | 38.42 | 142.36 |  | 33.31 | 159.67 |  | 34.59 | 112.61 |  |  |  |  | 39.1 | 115.11
35 | [NAME] |  |  |  | 50.23 | 43.51 | 44.88 | 49.68 | 52.85 | 17.24 | 38.87 | 45.51 | 23.92 |  |  |  | 41.3 | 66.99 | 43.16 | 38.58 | 61.15 | 36.19 | 43.32 | 70.91 | 36.54 |  |  |  |  |  |  | 38.48 | 54.69 | 30.19 | 33.33 | 76.49 | 30.01 | 39.45 | 58.9 | 37.16 | 36.89 | 57.04 | 29.02
36 | [NAME] |  |  |  | 23.58 | 77.35 |  | 20.32 | 79.66 |  | 22.89 | 81.87 |  | 24.69 | 100.76 |  | 24.37 | 70.32 |  |  |  |  |  |  |  | 20.78 | 108.79 |  | 23.28 | 79.65 |  | 23.09 | 71.8 |  |  |  |  | 21.12 | 66.8 |  | 25.05 | 67.53
37 | Nurhidayat Aldila | 39.81 | 62.86 |  |  |  |  | 41.86 | 67.01 |  | 35.27 | 66.29 |  | 36 | 68.25 |  |  |  |  | 41.17 | 73.23 |  | 46.66 | 69.47 |  |  |  |  |  |  |  | 45.8 | 68.98 |  | 41.61 | 66.74 |  | 48.47 | 68.07 |  | 35.17 | 61.27
38 | [NAME] |  |  |  | 31.72 | 98.28 |  | 25.1 | 92.16 |  | 20.02 | 96.73 |  | 27.54 | 86.28 |  | 21.59 | 87.95 |  |  |  |  |  |  |  | 23.42 | 122.21 |  | 24.51 | 94.86 |  | 25.31 | 91.61 |  | 25.28 | 98.97 |  |  |  |  | 33.75 | 95.82
39 | Rayoga Rahmansyah | 31.74 | 69.1 |  |  |  |  | 41.28 | 67.1 |  | 29.59 | 72.54 |  | 33.34 | 62.09 |  |  |  |  | 35.91 | 61.06 |  | 25.15 | 61.42 |  |  |  |  |  |  |  | 31.69 | 61.1 |  | 28.9 | 61.54 |  | 31.63 | 60.54 |  | 27.59 | 61.78
40 | [NAME] | 161.34 | 459.06 |  |  |  |  | 915.9 | 325.6 |  | 152.32 | 287.8 |  | 109.16 | 546.99 |  |  |  |  | 79.04 | 287.36 |  | 51.49 | 220.18 |  |  |  |  | 46.91 | 223.59 |  | 42.22 | 183.16 |  |  |  |  | 43.16 | 230.53 |  | 45.96 | 128.39
41 | [NAME] |  |  |  | 533.66 |  |  |  |  |  | 76.92 |  |  | 85.8 |  |  |  |  |  | 82.46 |  |  | 65.68 | 478.44 |  |  |  |  |  |  |  | 63.27 | 269.8 |  | 81.77 | 345.54 |  | 68.74 |  |  | 72.69 | 307.83
42 | [NAME] |  |  |  | 43.05 | 142.2 |  | 37.18 | 124.64 |  | 27.25 | 153.99 |  |  |  |  | 26.73 | 141.18 |  | 23.32 | 128.59 |  | 29.48 | 112.28 | 30.95 |  |  |  |  |  |  | 31.97 | 127.57 |  | 31.23 | 121.57 | 30.94 |  |  |  | 24.05 | 114.74 | 28.33
43 | [NAME] |  |  |  | 28.25 | 50.3 |  | 22.19 | 52.42 |  | 17.94 | 55.8 |  | 24.79 | 59.04 |  |  |  |  | 21.91 | 52.1 |  | 23.73 | 54.72 |  |  |  |  | 22.53 | 50.65 |  | 21.19 | 53.91 |  |  |  |  | 24.99 | 54.33 |  | 24.24 | 52.99
44 | Wahyu Bimantara |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 520.36 |  |  | 450.7 |  |  | 427.88 |  |  | 451.27 |  |  |  |  |  | 406.13 | 1036.1
45 | [NAME] |  |  |  | 34.25 | 63.6 |  | 31.74 | 63.85 |  | 33.06 | 47.83 |  | 29.29 | 51.74 |  |  |  |  | 27.82 | 49.39 |  | 26.2 | 51.38 |  |  |  |  |  |  |  | 26.31 | 48.67 |  | 25.43 | 47.8 |  | 27.28 | 55.5 |  | 25.6 | 50
46 | [NAME] | 35.45 | 113.74 |  |  |  |  | 36.21 | 106.88 |  | 37.11 | 123.57 |  | 31.28 | 86.23 |  | 27.6 | 91.74 |  |  |  |  |  |  |  | 26.23 | 109.94 |  | 31.73 | 99.83 |  | 29.99 | 94.59 |  |  |  |  | 29.88 | 115.99 |  | 29.34 | 92.4
47 | [NAME] | 99.81 | 282.02 |  |  |  |  |  |  |  | 65.67 | 174.02 |  | 81.17 | 154.6 |  | 61.86 | 148.21 |  | 52.22 | 98.95 |  |  |  |  | 46.52 | 224.11 |  | 46.15 | 133.61 |  |  |  |  | 49.2 | 131.62 |  | 49.48 | 118.26 |  | 43.05 | 107.97
48 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15.99 | 41.14 | 15.64 | 15.37 | 40.74 | 14.03 | 14.11 | 40.32 | 14.27 |  |  |  | 10.83 | 41.08 | 10.79 | 13.07 | 40.94 | 12.47 | 14.76 | 41.81 | 12.67 | 12.13 | 39.08 | 14.06
49 | [NAME] | 33.97 | 93.04 |  |  |  |  | 35.89 | 83.98 |  | 28.44 | 62.29 |  |  |  |  | 30.42 | 61.89 |  | 26.41 | 68.56 |  |  |  |  | 30.58 | 99.75 |  | 26.16 | 72.93 |  | 27.97 | 77.4 |  |  |  |  | 25.94 | 71.14 |  | 26.75 | 69.5
50 | [NAME] | 21.26 | 40.9 | 85.17 |  |  |  |  |  |  | 12.74 | 26.75 | 32.52 | 12.33 | 36 | 64.88 | 12.47 | 26.31 | 11.46 | 11.77 | 36.95 | 13.18 |  |  |  | 11.95 | 41.63 | 11.25 | 11.81 | 27.74 | 10.07 |  |  |  | 12.15 | 35.95 | 12.2 | 10.89 | 34.24 | 12.12 | 10.54 | 35.24 | 10.84
51
52
53
54
55