Spreadsheet: 851176d1701385644-trying-to-use-averageif-and-a-cell-value-containing-a-date-export-scales-master
Sheet: RTU1

Sample Date & Time.1 | AVG Humidity | AVG Temperature
2023-03-06 00:00:00 | 27.42335368421053 | 66.53865052631579
2023-03-07 00:00:00 | 27.76057319587629 | 66.82410927835052
2023-03-08 00:00:00 | 27.75941875 | 66.64075833333334
2023-03-09 00:00:00 | 29.44589462365591 | 66.92103655913978
2023-03-10 00:00:00 | 29.03655102040817 | 66.63463775510203
2023-03-11 00:00:00 | 25.90940208333333 | 66.244165625
2023-03-12 00:00:00 | 24.62854673913044 | 66.26045
2023-03-13 00:00:00 | 33.16156354166667 | 65.81528229166666
2023-03-14 00:00:00 | 26.8932625 | 66.32123541666667
2023-03-15 00:00:00 | 24.02834782608696 | 66.64450217391304
2023-03-16 00:00:00 | 27.17393402061856 | 67.39029793814433
2023-03-17 00:00:00 | 34.79225454545455 | 67.10690808080808
2023-03-18 00:00:00 | 24.54634468085106 | 66.43069680851063
2023-03-19 00:00:00 | 19.58539081632653 | 66.13808775510203
2023-03-20 00:00:00 | 18.921028125 | 66.4441875
2023-03-21 00:00:00 | 20.21801145833333 | 66.886346875
2023-03-22 00:00:00 | 23.317440625 | 67.28198541666667
2023-03-23 00:00:00 | 36.74621979166667 | 68.44718645833333
2023-03-24 00:00:00 | 30.416571875 | 68.07041979166667
2023-03-25 00:00:00 | 29.09812916666667 | 67.41743020833333
2023-03-26 00:00:00 | 25.930290625 | 67.53208229166667
2023-03-27 00:00:00 | 27.6078 | 67.55476989247312
2023-03-28 00:00:00 | 28.72658282828283 | 67.85946363636364
2023-03-29 00:00:00 | 31.06907472527472 | 67.10618571428571
2023-03-30 00:00:00 | 24.11175445544555 | 66.8108099009901
2023-03-31 00:00:00 | 26.15361770833334 | 66.73198854166667
2023-04-01 00:00:00 | 36.32510104166667 | 68.216509375
2023-04-02 00:00:00 | 24.60146666666667 | 67.27673020833333
2023-04-03 00:00:00 | 25.874071875 | 68.20440729166667
2023-04-04 00:00:00 | 34.03810729166667 | 69.030946875
2023-04-05 00:00:00 | 44.2713688172043 | 69.48377311827957
2023-04-06 00:00:00 | 43.12406363636364 | 69.0824303030303
2023-04-07 00:00:00 | 24.5821125 | 67.101490625
2023-04-08 00:00:00 | 20.47585833333333 | 66.977975
2023-04-09 00:00:00 | 19.836025 | 67.62456145833333
2023-04-10 00:00:00 | 18.671721875 | 68.26619166666667
2023-04-11 00:00:00 | 21.170140625 | 68.79481354166667
2023-04-12 00:00:00 | 29.21740625 | 70.27529479166667
2023-04-13 00:00:00 | 34.45266666666667 | 70.85809375
2023-04-14 00:00:00 | 34.69454838709677 | 70.42540107526882
2023-04-15 00:00:00 | 41.24554489795918 | 70.06738673469388
2023-04-16 00:00:00 | 46.92305 | 70.069771875
2023-04-17 00:00:00 | 37.27732604166667 | 69.28293333333333
2023-04-18 00:00:00 | 29.51463541666667 | 68.908175
2023-04-19 00:00:00 | 29.4615 | 69.75844791666667
2023-04-20 00:00:00 | 32.13953958333333 | 70.43106458333334
2023-04-21 00:00:00 | 36.07050208333333 | 71.72518645833334
2023-04-22 00:00:00 | 42.72221041666667 | 71.36874479166667
2023-04-23 00:00:00 | 33.89706382978724 | 69.31168936170214
2023-04-24 00:00:00 | 31.63666363636364 | 69.24085757575757
2023-04-25 00:00:00 | 31.696153125 | 69.96001770833334
2023-04-26 00:00:00 | 38.06057916666667 | 69.80530416666667
2023-04-27 00:00:00 | 33.59889895833334 | 71.24526979166667
2023-04-28 00:00:00 | 37.95442903225806 | 71.10855913978494
2023-04-29 00:00:00 | 42.51665051546392 | 68.82201855670102
2023-04-30 00:00:00 | 48.09143636363636 | 67.95106767676768
2023-05-01 00:00:00 | 45.77807395833334 | 68.65181875
2023-05-02 00:00:00 | 43.20975 | 69.62731145833334
2023-05-03 00:00:00 | 43.17316041666667 | 69.35468333333333
2023-05-04 00:00:00 | 44.8360625 | 70.19518020833333
2023-05-05 00:00:00 | 42.89366354166667 | 70.51662604166667
2023-05-06 00:00:00 | 44.70338854166667 | 70.09495
2023-05-07 00:00:00 | 39.51137956989247 | 70.22941720430107
2023-05-08 00:00:00 | 44.26804315789474 | 71.61047473684211
2023-05-09 00:00:00 | 38.83229090909091 | 72.14869393939394
2023-05-10 00:00:00 | 34.25517291666667 | 72.12468125
2023-05-11 00:00:00 | 36.4505625 | 72.27904583333333
2023-05-12 00:00:00 | 40.07821473684211 | 72.41544736842106
2023-05-13 00:00:00 | 40.08015612244898 | 74.72952551020408
2023-05-14 00:00:00 | 40.3954 | 74.76034166666666
2023-05-15 00:00:00 | 33.26338124999999 | 73.440334375
2023-05-16 00:00:00 | 32.98000736842106 | 72.40178210526315
2023-05-17 00:00:00 | 30.43698350515464 | 71.69234432989691
2023-05-18 00:00:00 | 27.93875 | 71.69053854166667
2023-05-19 00:00:00 | 37.802290625 | 72.57535
2023-05-20 00:00:00 | 41.36250416666667 | 72.60748958333333
2023-05-21 00:00:00 | 46.97254842105263 | 71.72244315789473
2023-05-22 00:00:00 | 44.95808969072165 | 72.23221649484536
2023-05-23 00:00:00 | 45.362925 | 72.111009375
2023-05-24 00:00:00 | 45.91142765957447 | 72.45034361702128
2023-05-25 00:00:00 | 37.84402916666667 | 72.16118645833333
2023-05-26 00:00:00 | 35.47472040816326 | 72.30013979591837
2023-05-27 00:00:00 | 38.60589583333334 | 73.80303229166667
2023-05-28 00:00:00 | 39.82531458333333 | 75.42285729166667
2023-05-29 00:00:00 | 42.8673747368421 | 74.18751263157895
2023-05-30 00:00:00 | 42.40843877551021 | 73.80092857142857
2023-05-31 00:00:00 | 44.24703125 | 73.68262083333333
2023-06-01 00:00:00 | 44.17224166666666 | 73.51443541666667
2023-06-02 00:00:00 | 45.99485729166667 | 72.47801458333333
2023-06-03 00:00:00 | 47.36334895833333 | 75.89535416666666
2023-06-04 00:00:00 | 43.91655833333333 | 77.73612291666667
2023-06-05 00:00:00 | 37.74099270833333 | 72.72818854166667
2023-06-06 00:00:00 | 43.211821875 | 71.61691145833333
2023-06-07 00:00:00 | 37.88803404255319 | 72.47422234042553
2023-06-08 00:00:00 | 37.39296262626262 | 71.53908282828283
2023-06-09 00:00:00 | 42.16128125 | 70.97946458333334
2023-06-10 00:00:00 | 48.38492916666667 | 71.96776770833333
2023-06-11 00:00:00 | 46.81712395833333 | 74.12573125
2023-06-12 00:00:00 | 50.69619247311828 | 72.9630129032258
2023-06-13 00:00:00 | 47.90320707070707 | 71.63477070707071
2023-06-14 00:00:00 | 50.69668817204301 | 71.58005913978495
2023-06-15 00:00:00 | 49.27607244897959 | 71.7418306122449
2023-06-16 00:00:00 | 52.73273265306123 | 71.96107551020408
2023-06-17 00:00:00 | 55.62328333333333 | 72.93248854166667
2023-06-18 00:00:00 | 51.65615 | 74.612390625
2023-06-19 00:00:00 | 51.10298172043011 | 74.06445591397849
2023-06-20 00:00:00 | 52.8234090909091 | 74.44721414141414
2023-06-21 00:00:00 | 51.40799052631579 | 74.23194
2023-06-22 00:00:00 | 51.99659787234042 | 73.31302127659575
2023-06-23 00:00:00 | 56.29340303030303 | 72.54885050505051
2023-06-24 00:00:00 | 55.86590416666667 | 73.89130520833334
2023-06-25 00:00:00 | 57.83815833333333 | 75.48829375
2023-06-26 00:00:00 | 55.37353978494624 | 74.50329032258064
2023-06-27 00:00:00 | 55.14866185567011 | 73.4061144329897
2023-06-28 00:00:00 | 58.83677551020408 | 73.02603163265306
2023-06-29 00:00:00 | 56.04934895833333 | 73.39467395833333
2023-06-30 00:00:00 | 55.952625 | 73.94937826086957
2023-07-01 00:00:00 | 55.641701 | 76.795955
2023-07-02 00:00:00 | 55.59090625 | 77.54616979166667
2023-07-03 00:00:00 | 56.22315913978495 | 74.15226451612904
2023-07-04 00:00:00 | 58.10798282828283 | 74.01957575757575
2023-07-05 00:00:00 | 58.38133645833334 | 74.99777291666666
2023-07-06 00:00:00 | 57.961634375 | 75.60019895833334
2023-07-07 00:00:00 | 55.80529791666667 | 75.31129791666666
2023-07-08 00:00:00 | 54.59157311827957 | 77.1762311827957
2023-07-09 00:00:00 | 55.30493131313131 | 78.2022313131313
2023-07-10 00:00:00 | 54.87573789473684 | 74.62572
2023-07-11 00:00:00 | 53.57991263157895 | 74.18761368421053
2023-07-12 00:00:00 | 55.15598210526316 | 74.04245684210527
2023-07-13 00:00:00 | 57.89765353535353 | 73.90692929292929
2023-07-14 00:00:00 | 56.30862083333334 | 74.620203125
2023-07-15 00:00:00 | 56.13841875 | 77.288365625
2023-07-16 00:00:00 | 56.88110520833333 | 78.8943125
2023-07-17 00:00:00 | 54.81242604166667 | 75.47256666666667
2023-07-18 00:00:00 | 54.82461458333334 | 74.22476041666667
2023-07-19 00:00:00 | 54.56948958333334 | 74.04291458333333
2023-07-20 00:00:00 | 54.875603125 | 74.41051770833333
2023-07-21 00:00:00 | 55.56681041666667 | 73.92796041666666
2023-07-22 00:00:00 | 55.38374375 | 75.74183854166667
2023-07-23 00:00:00 | 55.02595416666666 | 77.3940625
2023-07-24 00:00:00 | 54.10992083333333 | 75.49660208333333
2023-07-25 00:00:00 | 53.571203125 | 74.69700833333333
2023-07-26 00:00:00 | 55.77733541666667 | 74.41491979166666
2023-07-27 00:00:00 | 55.386384375 | 74.34653125
2023-07-28 00:00:00 | 57.96536875 | 74.77872395833333
2023-07-29 00:00:00 | 56.476659375 | 77.17611979166666
2023-07-30 00:00:00 | 56.08968043478261 | 77.36702282608695
2023-07-31 00:00:00 | 52.34589292929293 | 74.70890606060607
2023-08-01 00:00:00 | 51.34740416666666 | 73.488203125
2023-08-02 00:00:00 | 51.55648333333333 | 73.39837916666667
2023-08-03 00:00:00 | 54.70424623655914 | 73.72835053763441
2023-08-04 00:00:00 | 56.3035 | 74.30242653061225
2023-08-05 00:00:00 | 54.054209375 | 76.57253229166666
2023-08-06 00:00:00 | 55.15885263157895 | 77.57964736842105
2023-08-07 00:00:00 | 55.58352127659575 | 75.25303191489363
2023-08-08 00:00:00 | 56.365577 | 73.917719
2023-08-09 00:00:00 | 58.11357604166667 | 73.54422291666667
2023-08-10 00:00:00 | 60.23294516129032 | 73.37106559139785
2023-08-11 00:00:00 | 57.88406 | 73.771358
2023-08-12 00:00:00 | 54.82281666666666 | 75.42369791666667
2023-08-13 00:00:00 | 56.95751041666666 | 75.39887916666666
2023-08-14 00:00:00 | 57.92093333333333 | 74.217809375
2023-08-15 00:00:00 | 59.14037395833333 | 73.66084166666667
2023-08-16 00:00:00 | 59.40096526315789 | 73.47543052631579
2023-08-17 00:00:00 | 59.15220824742268 | 72.87264020618557
2023-08-18 00:00:00 | 53.49655625 | 72.879615625
2023-08-19 00:00:00 | 55.78534791666667 | 73.63800625
2023-08-20 00:00:00 | 55.921009375 | 75.44739166666666
2023-08-21 00:00:00 | 57.977746875 | 74.40856770833334
2023-08-22 00:00:00 | 54.63409895833333 | 72.32260104166667
2023-08-23 00:00:00 | 56.40524270833333 | 71.68812708333333
2023-08-24 00:00:00 | 62.30336458333333 | 71.701103125
2023-08-25 00:00:00 | 65.08197083333333 | 71.933365625
2023-08-26 00:00:00 | 64.890203125 | 74.31387708333334
2023-08-27 00:00:00 | 61.97508854166666 | 75.9384625
2023-08-28 00:00:00 | 62.52225208333333 | 73.88659479166667
2023-08-29 00:00:00 | 60.421465625 | 72.90825729166667
2023-08-30 00:00:00 | 60.330309375 | 72.19226979166666
2023-08-31 00:00:00 | 54.99466304347826 | 71.83483913043479
2023-09-01 00:00:00 | 52.14615858585859 | 72.74975656565657
2023-09-02 00:00:00 | 53.25443645833333 | 74.6449875
2023-09-03 00:00:00 | 57.04261397849462 | 76.7641
2023-09-04 00:00:00 | 60.66477575757575 | 74.57290808080808
2023-09-05 00:00:00 | 62.12689791666666 | 74.28740208333333
2023-09-06 00:00:00 | 59.48976666666667 | 73.14984166666666
2023-09-07 00:00:00 | 60.59930531914894 | 72.79175744680852
2023-09-08 00:00:00 | 63.18120612244898 | 73.71601530612244
2023-09-09 00:00:00 | 58.13993020833333 | 74.76695104166667
2023-09-10 00:00:00 | 59.47469791666666 | 75.00683541666666
2023-09-11 00:00:00 | 63.23354680851064 | 72.62730531914893
2023-09-12 00:00:00 | 60.46150612244898 | 73.06884795918367
2023-09-13 00:00:00 | 56.40489375 | 72.63267916666666
2023-09-14 00:00:00 | 50.2666914893617 | 72.32106702127659
2023-09-15 00:00:00 | 47.36732040816327 | 72.31082857142857
2023-09-16 00:00:00 | 51.69326458333333 | 73.48995208333334
2023-09-17 00:00:00 | 50.86607291666667 | 74.030703125
2023-09-18 00:00:00 | 52.71007916666667 | 71.80083854166666
2023-09-19 00:00:00 | 51.06018709677419 | 72.01590967741936
2023-09-20 00:00:00 | 49.47553434343434 | 71.30110404040404
2023-09-21 00:00:00 | 50.07212916666666 | 72.68069375
2023-09-22 00:00:00 | 50.5863125 | 72.95552395833333
2023-09-23 00:00:00 | 48.51086875 | 72.95997395833334
2023-09-24 00:00:00 | 54.44604270833334 | 71.80229479166667
2023-09-25 00:00:00 | 57.681790625 | 72.40706979166667
2023-09-26 00:00:00 | 58.43695319148936 | 72.09393510638299
2023-09-27 00:00:00 | 51.24402857142857 | 71.76125918367347
2023-09-28 00:00:00 | 47.31860520833333 | 71.25644583333333
2023-09-29 00:00:00 | 55.692265625 | 71.30215
2023-09-30 00:00:00 | 57.598884375 | 71.907184375
2023-10-01 00:00:00 | 56.78209791666666 | 72.067303125
2023-10-02 00:00:00 | 58.46319479166667 | 71.275165625
2023-10-03 00:00:00 | 60.42068958333333 | 70.75100416666666
2023-10-04 00:00:00 | 59.779825 | 72.013528125
2023-10-05 00:00:00 | 56.65128229166667 | 71.00014270833333
2023-10-06 00:00:00 | 60.12664791666667 | 70.484734375
2023-10-07 00:00:00 | 51.58440833333333 | 69.254796875
2023-10-08 00:00:00 | 46.857915625 | 68.008384375
2023-10-09 00:00:00 | 45.59861458333333 | 68.86801770833333
2023-10-10 00:00:00 | 45.82150625 | 69.748625
2023-10-11 00:00:00 | 45.83978817204301 | 70.3551064516129
2023-10-12 00:00:00 | 45.53884583333333 | 70.04758020833333
2023-10-13 00:00:00 | 45.56626565656565 | 70.06777373737374
2023-10-14 00:00:00 | 47.99368 | 68.85153368421052
2023-10-15 00:00:00 | 46.11250638297872 | 67.44953617021277
2023-10-16 00:00:00 | 48.51888686868687 | 68.82272121212121
2023-10-17 00:00:00 | 50.84059791666667 | 69.39359270833333
2023-10-18 00:00:00 | 48.8106744680851 | 70.12670638297872
2023-10-19 00:00:00 | 47.24369285714286 | 69.63822244897959
2023-10-20 00:00:00 | 51.11546666666667 | 70.09369247311828
2023-10-21 00:00:00 | 48.85430808080808 | 68.85345959595959
2023-10-22 00:00:00 | 47.39555520833333 | 68.77143645833333
2023-10-23 00:00:00 | 45.32425208333333 | 69.5013375
2023-10-24 00:00:00 | 42.62076770833333 | 70.55598645833334
2023-10-25 00:00:00 | 41.536840625 | 71.24713229166667
2023-10-26 00:00:00 | 43.89666145833333 | 72.00817291666667
2023-10-27 00:00:00 | 52.854553125 | 71.07934895833334
2023-10-28 00:00:00 | 57.28958125 | 70.06315729166667
2023-10-29 00:00:00 | 46.72368229166667 | 67.88470729166667
2023-10-30 00:00:00 | 48.10855104166667 | 67.94053645833333
2023-10-31 00:00:00 | 44.97587604166667 | 68.08183229166667
2023-11-01 00:00:00 | 41.15963333333333 | 68.207109375
2023-11-02 00:00:00 | 38.31568135593221 | 68.25584745762711