Spreadsheet: 815313d1674865174-average-of-column-within-a-specific-range-book4_52779
Sheet: Sheet1

426.4686826536884
14.71879350147398
863.4867441532036 |  |  | 365 | ExcelVersion < 365
381.2917539616936 |  | Range |  | Average
701.2447061176455 |  | 1. <90 | 52.12642028511117 |  | =AVERAGE(IF(MATCH($A$1:$A$373,{0,90,120,130,140,180})=ROW(A1),$A$1:$A$373))
495.4323277311715 |  | 2. 90 - 119 | 104.8324670409039 |  |  | [NAME]…. Confirmed with Control + Shift + Enter
703.884334504287 |  | 3. 120 - 129 | 124.5225818433594 |  |  | Copied down.
494.0313525529098 |  | 4. 130 - 139 | 136.0072187716859
642.5037993047406 |  | 5. 140 - 179 | 164.080607400954
333.6861010229686 |  | 6. >180 | 585.6401128166843
430.489865452907
50.21072789122039 |  |  | Cell D4 single cell [NAME]. Spill Range automatic
366.9728794402612 |  |  | =REDUCE("Average",SEQUENCE(6),LAMBDA(x,y,VSTACK(x,AVERAGE(FILTER(A1:A373,MATCH(A1:A373,{0,90,120,130,140,180})=y)))))
595.4334336773484
406.7934941270088
336.3282527431149
61.78463496850873
987.0822017095225
499.4611835513448
148.2584871120563
299.5451473752058
982.4765358808257
123.0848473750172
49.15748993963576
356.6917799894799
346.7381670510056
642.3808605278064
309.2854954404788
390.0524050767743
329.6737304101932
13.19492575257641
468.2120727584384
89.64327499318325
388.9647645275023
521.4821791535369
769.6189064330807
651.7809309629325
311.2443722003786
9.8349087120021
382.3158783578942
424.0145942154355
824.0414343194867
385.531569202423
598.0035025805159
854.9010713217958
432.1862993340462
84.28561197304096
180.7643022212738
483.6508368253126
580.8300843568537
196.902753065105
343.762993378831
496.2297892132819
859.3659706975008
297.4922407922925
892.4697662950604
746.0112398983553
833.2669128134519
740.0628468373304
433.3733085370282
92.16332460806132
724.1502334882751
66.47568383987957
678.4251705087293
708.7213935684274
367.501965719752
841.5670447702851
58.95496726949823
78.29834039282701
518.6232863980473
538.8827511478428
607.6706122980736
216.0474382346827
923.8195989269599
406.2941994321855
452.5789528332801
95.0523902477216
734.7742985989291
507.3454206489357
403.7515656570372
114.2732779242069
465.4039897216431
117.5119782150413
574.9849081559415
173.0521699497249
530.1905983090934
947.944643925858
52.69464957264602
854.0819008856108
862.055589460038
300.0256598781289
200.7740164424452
508.7846695733136
767.9371715564525
96.21128973654147
93.8029321366558
331.5904038931018
347.7784985039349
394.816836067879
776.9277269343152
147.247405951862
887.628689504086
682.2218458997777
426.2394795218914
229.9506192837928
212.0490271874785
714.094995860801
680.3104490299233
696.9137815138627
887.8184903761038
679.8716304292853
700.8469625062061
4.654920958540143
998.7256413596241
579.2985707339076
43.87961833526033
872.2797004635739
330.3267591258383
746.7081857939644
96.11144924949654
334.5469799183953
185.1526837417531
502.9147146671552
235.573242352124
825.0204109797077
58.37097566135186
365.2484449077465
608.9409992169537
26.50648685308376
416.3090327079055
178.4974988670364
478.7253163846474
564.808568955641
542.8893139290893
61.48133929271038
882.1872261716074
978.6314128653248
598.3454182239997
867.7265147334334
617.931358184275
749.8876406993064
418.8215525449175
176.2429795712905
408.0787537605488
484.076554673287
681.9164861855224
163.7888484226
510.8359391262804
119.5393729193337
950.1309986268539
259.1412518230003
923.3520084161532
165.1781110606462
304.331935705142
365.3749278228566
871.4109971392841
242.9792152122596
21.12944982498444
703.8962486947055
507.1290477354943
71.90708739201801
892.0397115107601
321.2795911414801
766.1520491599748
660.6077404998534
367.664416771055
259.8047251970011
869.8604753788486
257.7331837351955
832.2418138464482
889.2793534379919
690.1363866354156
110.4086094583294
686.7112441508691
905.4996917874769
737.5480850073367
242.1439938625493
104.4444079267929
379.6569192538145
226.4239749922549
737.7248587960077
786.4271233035853
85.46927573550134
777.2138343147207
754.170278501007
770.3468669115375
296.6969355720639
11.32439416887365
467.8286162674351
874.5423280867644
482.5593108073028
303.8510941759434
298.8999816227903
97.16325725486507
567.745316243794
36.70532274865435
863.5431199150041
26.85121482781072
419.7419127453845
341.1015604363751
878.6987276914767
267.7821269185376
475.2959453863109
616.7976062489965
136.0072187716859
175.3509519521971
862.2511204856933
615.2550538182287
729.1131092303758
650.5911099688003
913.4285063687703
388.6849383324473
276.6707260212659
925.6734884460567
255.8651855922964
359.975786772637
263.6440182483124
603.856051196868
861.3926895584191
671.1986429725799
970.902585248382
411.9847845922681
623.2743990445259
77.65531280699444
181.5888524229475
404.028135717845
401.296897710911
701.0948358215139
810.6416404395026
161.1363695563692
815.3231167550067
396.6306469131841
198.091832987234
530.4139620628357
478.4874358748086
63.80478524847278
672.9160615781178
521.0371617110374
769.7708715861847
558.2765427470999
411.2435971409844
668.092558855001
989.254897698706
716.1462003229965
453.5969473047716
907.5535252248577
64.5957302976229
651.8582037657359
586.7716032072839
767.4504732858973
319.0514893599131
641.2916492419158
464.905112192259
781.741706216919
706.8262027758202
253.8890671139167
391.4934221942153
708.3853874247276
572.3419619118753
160.8220165431931
218.7194654926711
991.6635996259834
171.2114338740898
950.3411716396622
466.28952136954
26.78768848001667
722.0008921959355
989.8621761907938
212.7503535480518
526.3480061951175
184.1012383522224
800.1143452418878
49.92968743416692
792.7236700491044
377.3052305827919
962.4493556569786
685.7368994616882
760.7317709549425
736.7866451774868
460.9811819264876
947.60766576032
402.9382411969279
170.9789468679998
56.16840930916989
507.5279221229091
89.93686490357177
853.686129421441
968.8567178556144
54.72281515964905
379.0374123324629
675.839042085342
961.3485580366603
437.3037398383524
640.1482581329701
255.450433785611
354.3720014814648
217.5601265888839
632.6575898797798
869.5014425342324
577.4827485332579
403.5316044490323
621.7297547717853
852.5778894738555
727.7553584533648
439.2816236178863
541.5430115473863
303.1656101523382
954.0752069723809
52.37598044754777
819.9425706987975
701.5330250148394
992.4850274911239
688.9178081069298
492.3702081135942
189.0236719333009
757.5174361880852
119.0804264658554
107.0593553888488
836.3599765591196
618.674526005743
923.7808274405961
580.5072949551931
416.5752600379441
634.1583087145893
765.1498180358369
347.8103619086411
83.7820228915681
814.2699955311906
378.5479496270384
634.6054529725378
875.3785178351441
334.9823959285989
814.3462529662954
970.6090477154572
590.3938034705554
756.4169251758519
850.608321834781
567.8552173801824
601.0239807371073
720.3269185270831
89.65331020322398
468.4462561551117
123.4507093049229
274.7447455137528
150.2455043401093
736.5919598577999
750.1639518786576
465.0828223486658
609.0038934335785
273.976770644797
257.2751061725961
969.7726105505013
863.6645043431163
124.8258408029679
935.2295610161376
481.8624903030354
126.7289298905296
677.6804311381323
674.2915123959339
439.6464320041455
256.4057361657552
343.8646548286707
568.3656670319189
362.817349913783
798.6973972340452
200.4157303799178
375.2521381573287
969.5531175966719
37.47800819160474
424.5615445224466
862.377764061817
724.1043398985303
155.1177795441819