Spreadsheet: 839691d1692165771-formula-to-average-multiple-ranges-containing-negative-numbers-and-zeros-sample-69-test
Sheet: Sheet1

[NAME]
Buy & Hold:  S&P 500 TR (Total Return Index) (SPXTR) |  |  |  |  |  |  |  |  |  |  | :items Ex 0 |  | :Item Count |  |  | :Item Count Ex Zero |  |  |  | :Item Count
2022-01-01 00:00:00 | 9986.7 |  | : Start Date / Value |  |  |  |  |  |  |  | K8:K53 | ABS Values | M8:M53 |  |  | P8:P53 | P8:P102 |  | +/- Values | T8:T53
 |  |  |  |  |  |  |  |  |  | ABS Values | ABS Avg | [NAME] | ABS Avg |  | +/- Values | Average | Average |  | [NAME] | Average
Date | Close Price | Daily P/L | Daily P/L % | Acct P/L % |  | Excel 365/2021 |  | All Excel |  | Column C | Column K | Column C | Column M |  | Column C | Column P | Column P |  | Column C | Column T
2022-01-01 00:00:00
2022-01-02 00:00:00 | 9986.7
2022-01-03 00:00:00 | 10050.41
2022-01-04 00:00:00 | 10044.75
2022-01-05 00:00:00 | 9850.7
2022-01-06 00:00:00 | 9841.92
2022-01-07 00:00:00 | 9803.85
2022-01-08 00:00:00 | 9803.85
2022-01-09 00:00:00 | 9803.85
2022-01-10 00:00:00 | 9789.72
2022-01-11 00:00:00 | 9879.39
2022-01-12 00:00:00 | 9907.38
2022-01-13 00:00:00 | 9767.35
2022-01-14 00:00:00 | 9775.53
2022-01-15 00:00:00 | 9775.53
2022-01-16 00:00:00 | 9775.53
2022-01-17 00:00:00 | 9775.53
2022-01-18 00:00:00 | 9595.93
2022-01-19 00:00:00 | 9503.14
2022-01-20 00:00:00 | 9398.96
2022-01-21 00:00:00 | 9221.28
2022-01-22 00:00:00 | 9221.28
2022-01-23 00:00:00 | 9221.28
2022-01-24 00:00:00 | 9246.84
2022-01-25 00:00:00 | 9134.33
2022-01-26 00:00:00 | 9120.75
2022-01-27 00:00:00 | 9072.24
2022-01-28 00:00:00 | 9294.21
2022-01-29 00:00:00 | 9294.21
2022-01-30 00:00:00 | 9294.21
2022-01-31 00:00:00 | 9469.92
January
2022-02-01 00:00:00 | 9534.95
2022-02-02 00:00:00 | 9624.89
2022-02-03 00:00:00 | 9390.57
2022-02-04 00:00:00 | 9440.58
2022-02-05 00:00:00 | 9440.58
2022-02-06 00:00:00 | 9440.58
2022-02-07 00:00:00 | 9405.84
2022-02-08 00:00:00 | 9484.95
2022-02-09 00:00:00 | 9623.84
2022-02-10 00:00:00 | 9450.72
2022-02-11 00:00:00 | 9271.8
2022-02-12 00:00:00 | 9271.8
2022-02-13 00:00:00 | 9271.8 |  |  |  |  |  |  |  |  |  |  |  | TEST |  |  |  |  |  |  | TEST
2022-02-14 00:00:00 |  |  |  |  |  | Column B values deleted below here |  |  |  |  |  |  | Sum |  |  |  |  |  |  | Sum
2022-02-15 00:00:00 |  |  |  |  |  | resulting in blank cells for C, D, E columns |  |  |  |  |  | 29 | Count |  |  |  |  |  | 29 | Count
2022-02-16 00:00:00 |  |  |  |  |  | but formulas remain in C, D, E cells. |  |  |  |  |  |  | Quotient |  |  |  |  |  |  | Quotient
2022-02-17 00:00:00
2022-02-18 00:00:00
2022-02-19 00:00:00
2022-02-20 00:00:00
2022-02-21 00:00:00
2022-02-22 00:00:00
2022-02-23 00:00:00
2022-02-24 00:00:00
2022-02-25 00:00:00
2022-02-26 00:00:00
2022-02-27 00:00:00
2022-02-28 00:00:00
2022-02-28 00:00:00
February
2022-03-01 00:00:00
2022-03-02 00:00:00
2022-03-03 00:00:00
2022-03-04 00:00:00
2022-03-05 00:00:00
2022-03-06 00:00:00
2022-03-07 00:00:00
2022-03-08 00:00:00
2022-03-09 00:00:00
2022-03-10 00:00:00
2022-03-11 00:00:00
2022-03-12 00:00:00
2022-03-13 00:00:00
2022-03-14 00:00:00
2022-03-15 00:00:00
2022-03-16 00:00:00
2022-03-17 00:00:00
2022-03-18 00:00:00
2022-03-19 00:00:00
2022-03-20 00:00:00
2022-03-21 00:00:00
2022-03-22 00:00:00
2022-03-23 00:00:00
2022-03-24 00:00:00
2022-03-25 00:00:00
2022-03-26 00:00:00
2022-03-27 00:00:00
2022-03-28 00:00:00
2022-03-29 00:00:00
2022-03-30 00:00:00
2022-03-31 00:00:00
March