Spreadsheet: 839617d1692113323-formula-to-average-multiple-ranges-containing-negative-numbers-and-zeros-sample-69-4-
Sheet: Sheet2

[NAME]
Buy & Hold:  S&P 500 TR (Total Return Index) (SPXTR)
44562 | 9986.7 |  | : Start Date / Value
Date | Close Price | Daily P/L | Daily P/L % | Acct P/L %
44562 | 9986.7 | 0 | 0 | 0
44563 | 9986.7 | 0 | 0 | 0
44564 | 10050.41 | 63.70999999999913 | 0.006379484714670424 | 0.006379484714670424
44565 | 10044.75 | -5.659999999999854 | -0.000563161104870334 | 0.005812730932139672
44566 | 9850.7 | -194.0499999999993 | -0.01931854949102758 | -0.01361811208907847
44567 | 9841.92 | -8.780000000000655 | -0.0008913072167460844 | -0.0144972813842411
44568 | 9803.85 | -38.06999999999971 | -0.003868147678501726 | -0.01830935143741179
44569 | 9803.85 | 0 | 0 | -0.01830935143741179
44570 | 9803.85 | 0 | 0 | -0.01830935143741179
44571 | 9789.72 | -14.13000000000102 | -0.001441270521274909 | -0.0197242332301963
44572 | 9879.39 | 89.67000000000007 | 0.009159608242115206 | -0.0107452912373458
44573 | 9907.38 | 27.98999999999978 | 0.002833170873910209 | -0.007942563609600922
44574 | 9767.35 | -140.0299999999988 | -0.01413390825828815 | -0.02196421240249535
44575 | 9775.53 | 8.180000000000291 | 0.0008374840668144677 | -0.02114512301360811
44576 | 9775.53 | 0 | 0 | -0.02114512301360811
44577 | 9775.53 | 0 | 0 | -0.02114512301360811
44578 | 9775.53 | 0 | 0 | -0.02114512301360811
44579 | 9595.93 | -179.6000000000004 | -0.01837240538364675 | -0.03912904162536177
44580 | 9503.14 | -92.79000000000087 | -0.00966972456030847 | -0.04842039913084415
44581 | 9398.96 | -104.1800000000003 | -0.01096269233116636 | -0.0588522735237868
44582 | 9221.28 | -177.6799999999985 | -0.01890421919020812 | -0.07664393643545916
44583 | 9221.28 | 0 | 0 | -0.07664393643545916
44584 | 9221.28 | 0 | 0 | -0.07664393643545916
44585 | 9246.84 | 25.55999999999949 | 0.002771849461246106 | -0.07408453242812947
44586 | 9134.33 | -112.5100000000002 | -0.01216739989012465 | -0.08535051618652816
44587 | 9120.75 | -13.57999999999993 | -0.001486699079188066 | -0.08671032473189348
44588 | 9072.24 | -48.51000000000022 | -0.005318641559082337 | -0.09156778515425525
44589 | 9294.21 | 221.9699999999993 | 0.02446694531890684 | -0.06934122382769098
44590 | 9294.21 | 0 | 0 | -0.06934122382769098
44591 | 9294.21 | 0 | 0 | -0.06934122382769098
44592 | 9469.92 | 175.7100000000009 | 0.01890531847246845 | -0.05174682327495575
January |  | -516.7800000000007 | -0.002587213255715093 | -0.05174682327495575
44593 | 9534.95 | 65.03000000000065 | 0.006867006268268439 | -0.04523516276647942
44594 | 9624.89 | 89.93999999999869 | 0.00943266613878402 | -0.03622918481580515
44595 | 9390.57 | -234.3199999999997 | -0.02434521329594413 | -0.05969239087987033
44596 | 9440.58 | 50.01000000000022 | 0.00532555531772834 | -0.0546847306918202
44597 | 9440.58 | 0 | 0 | -0.0546847306918202
44598 | 9440.58 | 0 | 0 | -0.0546847306918202
44599 | 9405.84 | -34.73999999999978 | -0.003679858652752244 | -0.05816335726516272
44600 | 9484.95 | 79.11000000000058 | 0.008410732055829206 | -0.05024182162275827
44601 | 9623.84 | 138.8899999999994 | 0.01464319790826514 | -0.03633432465178693
44602 | 9450.72 | -173.1200000000008 | -0.01798866149063168 | -0.05366938027576691
44603 | 9271.8 | -178.9200000000001 | -0.01893189090355021 | -0.07158520832707516
44604 | 9271.8 | 0 | 0 | -0.07158520832707516
44605 | 9271.8 | 0 | 0 | -0.07158520832707516
44606 | 9236.86 | -34.93999999999869 | -0.003768416057291863 | -0.07508386153584268
44607 | 9383.57 | 146.7099999999991 | 0.01588310313244968 | -0.06039332311974936
44608 | 9393.09 | 9.520000000000437 | 0.001014539242527144 | -0.05944005527351383
44609 | 9195.35 | -197.7399999999998 | -0.02105164541168026 | -0.07924038971832541
44610 | 9130.81 | -64.54000000000087 | -0.007018764919225573 | -0.08570298497001023
44611 | 9130.81 | 0 | 0 | -0.08570298497001023
44612 | 9130.81 | 0 | 0 | -0.08570298497001023
44613 | 9130.81 | 0 | 0 | -0.08570298497001023
44614 | 9038.32 | -92.48999999999978 | -0.01012944087107275 | -0.09496430252235483
44615 | 8871.95 | -166.369999999999 | -0.01840718186565634 | -0.111623459200737
44616 | 9005.37 | 133.4200000000001 | 0.01503840756541685 | -0.09826369070864248
44617 | 9207.85 | 202.4799999999996 | 0.02248436210838639 | -0.07798872500425569
44618 | 9207.85 | 0 | 0 | -0.07798872500425569
44619 | 9207.85 | 0 | 0 | -0.07798872500425569
44620 | 9186.37 | -21.47999999999956 | -0.002332792128455564 | -0.08013958564891305
44620 | 9186.37 | 0 | 0 | -0.08013958564891305
February |  | -283.5499999999993 | -0.001502857676768706 | -0.02994217480189899
44621 | 9044.47 | -141.9000000000015 | -0.01544679781023423 | -0.09434848348303257
44622 | 9213.39 | 168.9200000000001 | 0.01867660570492246 | -0.07743398720298009
44623 | 9166.13 | -47.26000000000022 | -0.005129490882291993 | -0.08216628115393489
44624 | 9094.04 | -72.08999999999833 | -0.007864824086064493 | -0.08938488189291756
44625 | 9094.04 | 0 | 0 | -0.08938488189291756
44626 | 9094.04 | 0 | 0 | -0.08938488189291756
44627 | 8825.72 | -268.3200000000015 | -0.0295050384647529 | -0.1162526159792525
44628 | 8762.11 | -63.60999999999876 | -0.00720734399006526 | -0.1226220873762104
44629 | 8988.65 | 226.5399999999991 | 0.02585450308202009 | -0.09993791743018224
44630 | 8950.9 | -37.75 | -0.0041997407842112 | -0.1037179448666728
44631 | 8835.4 | -115.5 | -0.01290373035113787 | -0.1152833268246769
44632 | 8835.4 | 0 | 0 | -0.1152833268246769
44633 | 8835.4 | 0 | 0 | -0.1152833268246769
44634 | 8771.75 | -63.64999999999964 | -0.007203974919075496 | -0.1216568035487199
44635 | 8959.74 | 187.9899999999998 | 0.02143129934163648 | -0.1028327675808827
44636 | 9160.51 | 200.7700000000004 | 0.02240801630404459 | -0.08272902960938053
44637 | 9274.17 | 113.6599999999999 | 0.0124076061267331 | -0.07134789269728745
44638 | 9382.43 | 108.2600000000002 | 0.01167328181389819 | -0.06050747494167246
44639 | 9382.43 | 0 | 0 | -0.06050747494167246
44640 | 9382.43 | 0 | 0 | -0.06050747494167246
44641 | 9378.84 | -3.590000000000146 | -0.0003826300862356709 | -0.0608669530475533
44642 | 9484.86 | 106.0200000000004 | 0.01130416981204503 | -0.05025083360869958
44643 | 9368.98 | -115.880000000001 | -0.01221736535910926 | -0.06185426617401155
44644 | 9504.19 | 135.2100000000009 | 0.01443166705447135 | -0.04831525929486218
44645 | 9552.4 | 48.20999999999913 | 0.00507249960280667 | -0.0434878388256382
44646 | 9552.4 | 0 | 0 | -0.0434878388256382
44647 | 9552.4 | 0 | 0 | -0.0434878388256382
44648 | 9620.66 | 68.26000000000022 | 0.007145848163812259 | -0.03665274815504629
44649 | 9738.6 | 117.9400000000005 | 0.01225903420347466 | -0.02484304124485569
44650 | 9678.3 | -60.30000000000109 | -0.006191855092107807 | -0.0308810718255281
44651 | 9527.46 | -150.8400000000001 | -0.01558538173026256 | -0.04598516026315014
March |  | 341.0899999999983 | 0.001688102506709397 | 0.03713000891538206