Spreadsheet: 851188d1701406610-trying-to-use-averageif-and-a-cell-value-containing-a-date-export-scales-master-1-
Sheet: RTU1

Date | Avg Humidity | [NAME]
2023-03-06 00:00:00 |  | 66.53865052631576
2023-03-07 00:00:00 | 27.76057319587628 | 66.82410927835049
2023-03-08 00:00:00 | 27.75941874999999 | 66.64075833333337
2023-03-09 00:00:00 | 29.44589462365592 | 66.92103655913978
2023-03-10 00:00:00 | 29.03655102040817 | 66.63463775510198
2023-03-11 00:00:00 | 25.90940208333334 | 66.24416562499997
2023-03-12 00:00:00 | 24.62854673913044 | 66.26045
2023-03-13 00:00:00 | 33.16156354166669 | 65.81528229166665
2023-03-14 00:00:00 | 26.8932625 | 66.32123541666665
2023-03-15 00:00:00 | 24.02834782608695 | 66.64450217391308
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.54634468085105 | 66.43069680851069
2023-03-19 00:00:00 | 19.58539081632653 | 66.13808775510205
2023-03-20 00:00:00 | 18.92102812500001 | 66.44418750000004
2023-03-21 00:00:00 | 20.21801145833334 | 66.88634687500006
2023-03-22 00:00:00 | 23.31744062499999 | 67.28198541666669
2023-03-23 00:00:00 | 36.74621979166667 | 68.44718645833329
2023-03-24 00:00:00 | 30.41657187500001 | 68.07041979166664
2023-03-25 00:00:00 | 29.09812916666667 | 67.41743020833333
2023-03-26 00:00:00 | 25.93029062500001 | 67.53208229166668
2023-03-27 00:00:00 | 27.60779999999999 | 67.55476989247316
2023-03-28 00:00:00 | 28.72658282828284 | 67.8594636363636
2023-03-29 00:00:00 | 31.06907472527473 | 67.10618571428574
2023-03-30 00:00:00 | 24.11175445544554 | 66.81080990099015
2023-03-31 00:00:00 | 26.15361770833333 | 66.73198854166671
2023-04-01 00:00:00 | 36.32510104166668 | 68.21650937500003
2023-04-02 00:00:00 | 24.60146666666665 | 67.2767302083333
2023-04-03 00:00:00 | 25.874071875 | 68.20440729166658
2023-04-04 00:00:00 | 34.03810729166668 | 69.03094687499994
2023-04-05 00:00:00 | 44.2713688172043 | 69.48377311827953
2023-04-06 00:00:00 | 43.12406363636361 | 69.08243030303029
2023-04-07 00:00:00 | 24.5821125 | 67.10149062500001
2023-04-08 00:00:00 | 20.47585833333334 | 66.97797500000003
2023-04-09 00:00:00 | 19.836025 | 67.62456145833335
2023-04-10 00:00:00 | 18.67172187499999 | 68.26619166666661
2023-04-11 00:00:00 | 21.17014062499999 | 68.7948135416666
2023-04-12 00:00:00 | 29.21740625000001 | 70.27529479166667
2023-04-13 00:00:00 | 34.45266666666667 | 70.85809374999998
2023-04-14 00:00:00 | 34.69454838709676 | 70.42540107526881
2023-04-15 00:00:00 | 41.24554489795918 | 70.06738673469383
2023-04-16 00:00:00 | 46.92304999999999 | 70.069771875
2023-04-17 00:00:00 | 37.27732604166668 | 69.2829333333333
2023-04-18 00:00:00 | 29.51463541666667 | 68.908175
2023-04-19 00:00:00 | 29.4615 | 69.75844791666665
2023-04-20 00:00:00 | 32.13953958333334 | 70.43106458333334
2023-04-21 00:00:00 | 36.07050208333334 | 71.72518645833333
2023-04-22 00:00:00 | 42.72221041666666 | 71.36874479166666
2023-04-23 00:00:00 | 33.89706382978723 | 69.31168936170211
2023-04-24 00:00:00 | 31.63666363636364 | 69.24085757575757
2023-04-25 00:00:00 | 31.69615312500001 | 69.96001770833335
2023-04-26 00:00:00 | 38.06057916666668 | 69.80530416666664
2023-04-27 00:00:00 | 33.59889895833334 | 71.24526979166667
2023-04-28 00:00:00 | 37.95442903225806 | 71.10855913978492
2023-04-29 00:00:00 | 42.51665051546392 | 68.82201855670097
2023-04-30 00:00:00 | 48.09143636363638 | 67.95106767676769
2023-05-01 00:00:00 | 45.77807395833333 | 68.65181874999998
2023-05-02 00:00:00 | 43.20975000000001 | 69.62731145833332
2023-05-03 00:00:00 | 43.17316041666666 | 69.35468333333334
2023-05-04 00:00:00 | 44.8360625 | 70.1951802083333
2023-05-05 00:00:00 | 42.8936635416667 | 70.51662604166668
2023-05-06 00:00:00 | 44.70338854166667 | 70.09494999999997
2023-05-07 00:00:00 | 39.51137956989246 | 70.22941720430106
2023-05-08 00:00:00 | 44.26804315789477 | 71.61047473684212
2023-05-09 00:00:00 | 38.83229090909091 | 72.14869393939395
2023-05-10 00:00:00 | 34.25517291666667 | 72.12468125000002
2023-05-11 00:00:00 | 36.4505625 | 72.27904583333336
2023-05-12 00:00:00 | 40.0782147368421 | 72.41544736842107
2023-05-13 00:00:00 | 40.08015612244896 | 74.72952551020411
2023-05-14 00:00:00 | 40.39539999999999 | 74.76034166666666
2023-05-15 00:00:00 | 33.26338124999999 | 73.44033437500002
2023-05-16 00:00:00 | 32.98000736842106 | 72.40178210526317
2023-05-17 00:00:00 | 30.43698350515465 | 71.69234432989691
2023-05-18 00:00:00 | 27.93875000000002 | 71.69053854166667
2023-05-19 00:00:00 | 37.80229062499998 | 72.57535000000001
2023-05-20 00:00:00 | 41.36250416666667 | 72.60748958333336
2023-05-21 00:00:00 | 46.97254842105263 | 71.72244315789473
2023-05-22 00:00:00 | 44.95808969072166 | 72.23221649484539
2023-05-23 00:00:00 | 45.362925 | 72.11100937499998
2023-05-24 00:00:00 | 45.91142765957446 | 72.45034361702129
2023-05-25 00:00:00 | 37.84402916666668 | 72.16118645833335
2023-05-26 00:00:00 | 35.47472040816326 | 72.30013979591835
2023-05-27 00:00:00 | 38.60589583333333 | 73.80303229166665
2023-05-28 00:00:00 | 39.82531458333333 | 75.42285729166667
2023-05-29 00:00:00 | 42.86737473684212 | 74.18751263157894
2023-05-30 00:00:00 | 42.40843877551022 | 73.80092857142859
2023-05-31 00:00:00 | 44.24703124999999 | 73.68262083333332
2023-06-01 00:00:00 | 44.17224166666665 | 73.51443541666664
2023-06-02 00:00:00 | 45.99485729166668 | 72.47801458333336
2023-06-03 00:00:00 | 47.36334895833333 | 75.89535416666665
2023-06-04 00:00:00 | 43.91655833333334 | 77.73612291666664
2023-06-05 00:00:00 | 37.74099270833333 | 72.72818854166668
2023-06-06 00:00:00 | 43.21182187499999 | 71.61691145833332
2023-06-07 00:00:00 | 37.88803404255319 | 72.47422234042556
2023-06-08 00:00:00 | 37.39296262626263 | 71.53908282828283
2023-06-09 00:00:00 | 42.16128125 | 70.97946458333332
2023-06-10 00:00:00 | 48.38492916666666 | 71.96776770833335
2023-06-11 00:00:00 | 46.81712395833335 | 74.12573125000002
2023-06-12 00:00:00 | 50.69619247311828 | 72.96301290322583
2023-06-13 00:00:00 | 47.90320707070708 | 71.63477070707067
2023-06-14 00:00:00 | 50.696688172043 | 71.58005913978492
2023-06-15 00:00:00 | 49.27607244897958 | 71.74183061224493
2023-06-16 00:00:00 | 52.73273265306124 | 71.96107551020411
2023-06-17 00:00:00 | 55.62328333333334 | 72.93248854166667
2023-06-18 00:00:00 | 51.65615 | 74.61239062500002
2023-06-19 00:00:00 | 51.10298172043011 | 74.06445591397853
2023-06-20 00:00:00 | 52.82340909090911 | 74.44721414141412
2023-06-21 00:00:00 | 51.4079905263158 | 74.23194000000002
2023-06-22 00:00:00 | 51.99659787234042 | 73.31302127659575
2023-06-23 00:00:00 | 56.293403030303 | 72.54885050505055
2023-06-24 00:00:00 | 55.86590416666664 | 73.89130520833335
2023-06-25 00:00:00 | 57.83815833333333 | 75.48829374999998
2023-06-26 00:00:00 | 55.37353978494627 | 74.50329032258064
2023-06-27 00:00:00 | 55.14866185567013 | 73.40611443298967
2023-06-28 00:00:00 | 58.83677551020409 | 73.02603163265307
2023-06-29 00:00:00 | 56.04934895833332 | 73.39467395833336
2023-06-30 00:00:00 | 55.952625 | 73.94937826086958
2023-07-01 00:00:00 | 55.641701 | 76.79595500000003
2023-07-02 00:00:00 | 55.59090625000001 | 77.54616979166663
2023-07-03 00:00:00 | 56.22315913978495 | 74.15226451612901
2023-07-04 00:00:00 | 58.10798282828283 | 74.01957575757577
2023-07-05 00:00:00 | 58.38133645833332 | 74.99777291666665
2023-07-06 00:00:00 | 57.96163437499999 | 75.60019895833334
2023-07-07 00:00:00 | 55.80529791666665 | 75.3112979166667
2023-07-08 00:00:00 | 54.59157311827956 | 77.17623118279572
2023-07-09 00:00:00 | 55.30493131313133 | 78.20223131313128
2023-07-10 00:00:00 | 54.87573789473682 | 74.62572000000003
2023-07-11 00:00:00 | 53.57991263157894 | 74.18761368421052
2023-07-12 00:00:00 | 55.15598210526315 | 74.04245684210528
2023-07-13 00:00:00 | 57.89765353535353 | 73.90692929292933
2023-07-14 00:00:00 | 56.30862083333333 | 74.62020312499997
2023-07-15 00:00:00 | 56.13841875000002 | 77.28836562500001
2023-07-16 00:00:00 | 56.88110520833333 | 78.8943125
2023-07-17 00:00:00 | 54.81242604166669 | 75.4725666666667
2023-07-18 00:00:00 | 54.82461458333336 | 74.22476041666668
2023-07-19 00:00:00 | 54.56948958333333 | 74.04291458333337
2023-07-20 00:00:00 | 54.875603125 | 74.41051770833336
2023-07-21 00:00:00 | 55.56681041666669 | 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.4966020833333
2023-07-25 00:00:00 | 53.57120312499999 | 74.69700833333334
2023-07-26 00:00:00 | 55.77733541666666 | 74.41491979166672
2023-07-27 00:00:00 | 55.38638437499998 | 74.34653125
2023-07-28 00:00:00 | 57.96536875 | 74.77872395833333
2023-07-29 00:00:00 | 56.47665937499999 | 77.17611979166666
2023-07-30 00:00:00 | 56.08968043478259 | 77.36702282608698
2023-07-31 00:00:00 | 52.34589292929292 | 74.70890606060601
2023-08-01 00:00:00 | 51.34740416666666 | 73.48820312500003
2023-08-02 00:00:00 | 51.55648333333334 | 73.39837916666667
2023-08-03 00:00:00 | 54.70424623655913 | 73.72835053763446
2023-08-04 00:00:00 | 56.30349999999999 | 74.30242653061224
2023-08-05 00:00:00 | 54.05420937500001 | 76.57253229166666
2023-08-06 00:00:00 | 55.15885263157896 | 77.57964736842102
2023-08-07 00:00:00 | 55.58352127659574 | 75.25303191489358
2023-08-08 00:00:00 | 56.36557700000001 | 73.91771899999999
2023-08-09 00:00:00 | 58.11357604166667 | 73.5442229166667
2023-08-10 00:00:00 | 60.23294516129036 | 73.37106559139788
2023-08-11 00:00:00 | 57.88405999999999 | 73.77135800000005
2023-08-12 00:00:00 | 54.8228166666666 | 75.42369791666668
2023-08-13 00:00:00 | 56.95751041666662 | 75.39887916666667
2023-08-14 00:00:00 | 57.92093333333333 | 74.217809375
2023-08-15 00:00:00 | 59.14037395833336 | 73.66084166666667
2023-08-16 00:00:00 | 59.40096526315789 | 73.47543052631582
2023-08-17 00:00:00 | 59.15220824742268 | 72.87264020618557
2023-08-18 00:00:00 | 53.49655625000002 | 72.879615625
2023-08-19 00:00:00 | 55.78534791666669 | 73.63800625
2023-08-20 00:00:00 | 55.921009375 | 75.4473916666667
2023-08-21 00:00:00 | 57.97774687499999 | 74.40856770833335
2023-08-22 00:00:00 | 54.63409895833335 | 72.32260104166667
2023-08-23 00:00:00 | 56.40524270833333 | 71.68812708333334
2023-08-24 00:00:00 | 62.3033645833333 | 71.70110312499999
2023-08-25 00:00:00 | 65.08197083333332 | 71.93336562500001
2023-08-26 00:00:00 | 64.890203125 | 74.31387708333331
2023-08-27 00:00:00 | 61.97508854166666 | 75.93846250000003
2023-08-28 00:00:00 | 62.52225208333334 | 73.88659479166667
2023-08-29 00:00:00 | 60.421465625 | 72.90825729166669
2023-08-30 00:00:00 | 60.33030937499999 | 72.19226979166665
2023-08-31 00:00:00 | 54.99466304347825 | 71.83483913043479
2023-09-01 00:00:00 | 52.14615858585857 | 72.74975656565658
2023-09-02 00:00:00 | 53.25443645833334 | 74.6449875
2023-09-03 00:00:00 | 57.04261397849465 | 76.76409999999997
2023-09-04 00:00:00 | 60.66477575757573 | 74.57290808080808
2023-09-05 00:00:00 | 62.12689791666668 | 74.2874020833333
2023-09-06 00:00:00 | 59.48976666666668 | 73.14984166666669
2023-09-07 00:00:00 | 60.59930531914892 | 72.79175744680853
2023-09-08 00:00:00 | 63.18120612244896 | 73.71601530612247
2023-09-09 00:00:00 | 58.13993020833332 | 74.76695104166666
2023-09-10 00:00:00 | 59.47469791666668 | 75.00683541666665
2023-09-11 00:00:00 | 63.23354680851062 | 72.62730531914895
2023-09-12 00:00:00 | 60.46150612244897 | 73.06884795918366
2023-09-13 00:00:00 | 56.40489374999999 | 72.63267916666662
2023-09-14 00:00:00 | 50.2666914893617 | 72.32106702127658
2023-09-15 00:00:00 | 47.36732040816326 | 72.31082857142863
2023-09-16 00:00:00 | 51.69326458333334 | 73.48995208333334
2023-09-17 00:00:00 | 50.86607291666666 | 74.03070312500002
2023-09-18 00:00:00 | 52.7100791666667 | 71.80083854166668
2023-09-19 00:00:00 | 51.06018709677416 | 72.01590967741939
2023-09-20 00:00:00 | 49.47553434343435 | 71.30110404040404
2023-09-21 00:00:00 | 50.07212916666668 | 72.68069375
2023-09-22 00:00:00 | 50.58631249999999 | 72.95552395833336
2023-09-23 00:00:00 | 48.51086875000001 | 72.95997395833336
2023-09-24 00:00:00 | 54.44604270833334 | 71.80229479166668
2023-09-25 00:00:00 | 57.681790625 | 72.40706979166667
2023-09-26 00:00:00 | 58.43695319148937 | 72.09393510638303
2023-09-27 00:00:00 | 51.24402857142856 | 71.76125918367349
2023-09-28 00:00:00 | 47.31860520833335 | 71.25644583333334
2023-09-29 00:00:00 | 55.69226562500003 | 71.30215
2023-09-30 00:00:00 | 57.59888437500002 | 71.90718437500003
2023-10-01 00:00:00 | 56.78209791666666 | 72.06730312500007
2023-10-02 00:00:00 | 58.46319479166667 | 71.27516562500004
2023-10-03 00:00:00 | 60.42068958333335 | 70.75100416666662
2023-10-04 00:00:00 | 59.779825 | 72.01352812499998
2023-10-05 00:00:00 | 56.65128229166664 | 71.00014270833339
2023-10-06 00:00:00 | 60.12664791666665 | 70.48473437500002
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.8680177083333
2023-10-10 00:00:00 | 45.82150624999999 | 69.74862499999999
2023-10-11 00:00:00 | 45.83978817204301 | 70.3551064516129
2023-10-12 00:00:00 | 45.53884583333331 | 70.04758020833331
2023-10-13 00:00:00 | 45.56626565656567 | 70.06777373737373
2023-10-14 00:00:00 | 47.99368 | 68.85153368421057
2023-10-15 00:00:00 | 46.11250638297872 | 67.44953617021275
2023-10-16 00:00:00 | 48.51888686868687 | 68.82272121212115
2023-10-17 00:00:00 | 50.84059791666667 | 69.39359270833329
2023-10-18 00:00:00 | 48.81067446808512 | 70.12670638297871
2023-10-19 00:00:00 | 47.24369285714286 | 69.63822244897958
2023-10-20 00:00:00 | 51.11546666666666 | 70.09369247311831
2023-10-21 00:00:00 | 48.85430808080806 | 68.85345959595955
2023-10-22 00:00:00 | 47.39555520833335 | 68.77143645833333
2023-10-23 00:00:00 | 45.32425208333331 | 69.50133749999996
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.00817291666671
2023-10-27 00:00:00 | 52.85455312499999 | 71.07934895833334
2023-10-28 00:00:00 | 57.28958125000002 | 70.06315729166661
2023-10-29 00:00:00 | 46.72368229166666 | 67.88470729166674
2023-10-30 00:00:00 | 48.10855104166667 | 67.94053645833334
2023-10-31 00:00:00 | 44.97587604166667 | 68.08183229166674
2023-11-01 00:00:00 | 41.15963333333333 | 68.207109375
2023-11-02 00:00:00 | 38.31568135593221 | 68.2558474576271
 | #[NAME]! | #[NAME]!
 | #[NAME]! | #[NAME]!
 | #[NAME]! | #[NAME]!
 | #[NAME]! | #[NAME]!
 | #[NAME]! | #[NAME]!
 | #[NAME]! | #[NAME]!