Spreadsheet: 837637d1690307385-averageifs-average-a-data-set-if-cell-next-to-it-is-equal-to-120-example
Sheet: Sheet2

2022-01-02 00:00:00 | DS | CW | W | 50 | 50.5253359 |  | 52.11362649 | 52.11362649 | 100
2022-01-02 00:00:00 | DS | CW | W | 50 | 50.5253359 |  | 80.24826344 | 80.24826344 | 200
2022-01-02 00:00:00 | DS | CW | W | 50 | 50.5253359 |  | 81.01518135 | 81.01518135 | 300
2022-01-02 00:00:00 | DS | CW | W | 63.9479566 | 63.02519 |  | 93.91692874 | 93.91692874 | 300
2022-01-02 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 92.81461238 | 92.81461238 | 200
2022-01-02 00:00:00 | DS | CW | W | 50.20801751 | 50.20801751 |  | 79.47664552 | 79.47664552 | 200
2022-01-02 00:00:00 | DS | CW | W | 60.363293 | 60.363293 |  | 50.5253359 | 50.5253359 | 300
2022-01-02 00:00:00 | DS | CW | W | 63.9479566 | 63.02519 |  | 50.52534095 | 50.52534095 | 300
2022-01-02 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 61.8535651 | 61.8535651 | 300
2022-01-02 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 62.0740274 | 62.0740274 | 300
2022-01-02 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 63.8377255 | 63.8377255 | 100
2022-01-02 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 82.67334832 | 82.67334832 | 100
2022-01-02 00:00:00 | DS | CW | W | 63.9479566 | 63.02519 |  | 95.23535195 | 95.23535195 | 100
2022-01-02 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 63.7274944 | 63.7274944 | 100
2022-01-02 00:00:00 | DS | CW | W | 50.20801751 | 50.20801751 |  | 90.94068315 | 90.94068315 | 100
2022-01-02 00:00:00 | DS | CW | W | 60.363293 | 60.363293 |  | 90.72022089 | 90.72022089 | 100
2022-01-02 00:00:00 | DS | CW | W | 63.9479566 | 63.02519 |  | 50.64894419 | 50.64894419 | 100
2022-01-02 00:00:00 | DS | UW | W | 50.5253359 | 50.5253359 |  | 90.16906523 | 90.16906523 | 300
2022-01-02 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 61.743334 | 61.743334 | 200
2022-01-02 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 88.07467374 | 88.07467374 | 200
2022-01-02 00:00:00 | DS | CW | W | 63.9479566 | 63.02519 |  | 90.94068315 | 90.94068315 | 200
2022-01-02 00:00:00 | DS | UW | W | 50.5253359 | 50.5253359 |  | 50.05278685 | 50.05278685 | 200
2022-01-02 00:00:00 | DS | CW | W | 50.20801751 | 50.20801751 |  | 90.94068315 | 90.94068315 | 200
2022-01-02 00:00:00 | DS | UW | W | 50.5253359 | 50.5253359 |  | 92.92484351 | 92.92484351 | 300
2022-01-02 00:00:00 | DS | CW | W | 60.363293 | 60.363293 |  | 92.15322559 | 92.15322559 | 100
2022-01-02 00:00:00 | DS | UW | W | 50.5253359 | 50.5253359 |  | 92.26345672 | 92.26345672 | 100
2022-01-02 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 62.9558764 | 62.9558764 | 300
2022-01-02 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 111.4436735 | 111.4436735 | 300
2022-01-02 00:00:00 | DS | CW | W | 50.20801751 | 50.20801751 |  | 53.01131518 | 53.01131518 | 300
2022-01-02 00:00:00 | DS | UW | W | 63.9479566 | 63.02519 |  | 94.75177274 | 94.75177274 | 300
2022-01-02 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 92.92484351 | 92.92484351 | 300
2022-01-02 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 108.5776641 | 108.5776641 | 300
2022-01-02 00:00:00 | DS | UW | W | 63.9479566 | 63.02519 |  | 95.5703957 | 95.5703957 | 200
2022-01-02 00:00:00 | DS | CW | W | 50.20801751 | 50.20801751 |  | 93.80669256 | 93.80669256 | 300
2022-01-02 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 62.9558764 | 62.9558764 | 300
2022-01-02 00:00:00 | DS | UW | W | 50.5253359 | 50.5253359 |  | 50.64894251 | 50.64894251 | 100
2022-01-02 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 92.26345672 | 92.26345672 | 100
2022-01-02 00:00:00 | DS | UW | W | 50.5253359 | 50.5253359 |  | 52.77501328 | 52.77501328 | 100
2022-01-02 00:00:00 | DS | CW | W | 50.20801751 | 50.20801751 |  | 60.646227 | 60.646227 | 200
2022-01-02 00:00:00 | DS | UW | W | 63.9479566 | 63.02519 |  | 90.94068315 | 90.94068315 | 100
2022-01-02 00:00:00 | DS | CW | W | 63.9479566 | 63.02519 |  | 105.601427 | 105.601427 | 300
2022-01-02 00:00:00 | DS | UW | W | 50.5253359 | 50.5253359 |  | 90.27925336 | 90.27925336 | 300
2022-01-02 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 108.6878953 | 108.6878953 | 300
2022-01-02 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 93.65346143 | 93.65346143 | 300
2022-01-02 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 53.01131518 | 53.01131518 | 300
2022-01-02 00:00:00 | DS | UW | W | 50.5253359 | 50.5253359 |  | 51.32616893 | 51.32616893 | 200
2022-01-02 00:00:00 | DS | CW | W | 50.20801751 | 50.20801751 |  | 60.085167 | 60.085167 | 300
2022-01-02 00:00:00 | DS | UW | W | 63.9479566 | 63.02519 |  | 91.38160936 | 91.38160936 | 300
2022-01-02 00:00:00 | DS | CW | W | 63.9479566 | 63.02519 |  | 91.93276501 | 91.93276501 | 300
2022-01-02 00:00:00 | DS | UW | W | 50.5253359 | 50.5253359 |  | 92.04250446 | 92.04250446 | 300
2022-01-02 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 62.9558764 | 62.9558764 | 300
2022-01-02 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 51.5466312 | 51.5466312 | 200
2022-01-02 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 107.2548906 | 107.2548906 | 200
2022-01-02 00:00:00 | DS | UW | W | 63.9479566 | 63.02519 |  | 88.40537218 | 88.40537218 | 200
2022-01-02 00:00:00 | DS | CW | W | 63.9479566 | 63.02519 |  | 93.58623151 | 93.58623151 | 300
2022-01-02 00:00:00 | DS | CW | W | 50.20801751 | 50.20801751 |  | 52.00339536 | 52.00339536 | 300
2022-01-02 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 62.1842585 | 62.1842585 | 300
2022-01-02 00:00:00 | DS | UW | W | 50.5253359 | 50.5253359 |  | 94.90900387 | 94.90900387 | 100
2022-01-02 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 61.4126406 | 61.4126406 | 100
2022-01-02 00:00:00 | DS | CW | W | 63.9479566 | 63.02519 |  | 95.5703957 | 95.5703957 | 200
2022-01-02 00:00:00 | DS | UW | W | 50.5253359 | 50.5253359 |  | 87.63374922 | 87.63374922 | 200
2022-01-02 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 116.5143056 | 116.5143056 | 200
2022-01-02 00:00:00 | DS | CW | W | 50.20801751 | 50.20801751 |  | 114.5301452 | 114.5301452 | 200
2022-01-02 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 114.4150141 | 114.4150141 | 200
2022-01-03 00:00:00 | DS | CW | W | 63.9479566 | 63.02519 |  | 107.916279 | 107.916279 | 200
2022-01-03 00:00:00 | DS | UW | W | 63.9479566 | 63.02519 |  | 92.70437957 | 92.70437957 | 300
2022-01-03 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 90.27925336 | 90.27925336 | 100
2022-01-03 00:00:00 | DS | CW | W | 50.20801751 | 50.20801751 |  | 50.75917364 | 50.75917364 | 300
2022-01-03 00:00:00 | DS | UW | W | 50.5253359 | 50.5253359 |  | 63.7274944 | 63.7274944 | 300
2022-01-03 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 52.22385762 | 52.22385762 | 300
2022-01-03 00:00:00 | DS | UW | W | 50.5253359 | 50.5253359 |  | 86.64166904 | 86.64166904 | 300
2022-01-03 00:00:00 | DS | CW | W | 63.9479566 | 63.02519 |  | 90.94068315 | 90.94068315 | 100
2022-01-03 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 120.262164 | 120.262164 | 200
2022-01-03 00:00:00 | DS | UW | W | 63.9479566 | 63.02519 |  | 53.0113135 | 53.0113135 | 100
2022-01-03 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 107.0344283 | 107.0344283 | 200
2022-01-03 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 105.0502679 | 105.0502679 | 200
2022-01-03 00:00:00 | DS | OAW | W | 50.20801751 | 50.20801751 |  | 107.4753528 | 107.4753528 | 200
2022-01-03 00:00:00 | DS | UW | W | 50.5253359 | 50.5253359 |  | 104.7195745 | 104.7195745 | 100
2022-01-03 00:00:00 | DS | CW | W | 50.5253359 | 50.5253359 |  | 87.52351809 | 87.52351809 | 200