Spreadsheet: 819960d1677781171-formula-to-count-number-of-months-used-based-on-value-in-several-ranges-test
Sheet: Days2023

 |  | 2023 | PV
 |  |  | Fed to Grid | From Grid | PV Yield | House Consumption | Consumed From PV
 |  |  | kW | kW | kW | kW | kW
 |  | Months/Days: | 3
 |  | Total:
 |  | ~ Month:
 |  | ~ Day:
 |  |  | 0 | 46.18 | 1.71 | 46.18 | 1.71
 |  |  | 19.94 | 22.15 | 47.27 | 52.81 | 27.33
 |  |  | 19.44 | 1.56 | 52.1 | 20.51 | 32.66
 |  |  | 0 | 21.24 | 0 | 34.83 | 0
 |  |  | 15.1 | 0.28 | 49.28 | 27.81 | 34.18
 |  |  | 0.2 | 10.57 | 17.71 | 19.41 | 17.51
 |  |  | 0 | 39.35 | 1.07 | 39.35 | 1.07
 |  |  | 0 | 48.44 | 0.34 | 48.44 | 0.34
 |  |  | 2.89 | 27.53 | 4.88 | 41.18 | 1.99
 |  |  | 0.05 | 20.96 | 14.71 | 53.42 | 14.66
 |  |  | 0.17 | 9.77 | 48.86 | 41.49 | 48.69
 |  |  | 0.05 | 0.48 | 45.31 | 45.38 | 45.26
 |  |  | 17.29 | 0.5 | 49.48 | 30.52 | 32.19
 |  |  | 0.02 | 8.68 | 12.78 | 40.21 | 12.76
 |  |  | 1.75 | 17.97 | 29.14 | 37.86 | 27.39
 |  |  | 0.09 | 31.9 | 12.25 | 51.33 | 12.16
 |  |  | 0.16 | 30.05 | 24.99 | 54.9 | 23.83
 |  |  | 0.19 | 20.32 | 32.31 | 52.38 | 32.12
 |  |  | 0.09 | 29.13 | 23.28 | 52.17 | 23.19
 |  |  | 0.36 | 18.41 | 32.37 | 50.06 | 32.01
 |  |  | 0.5 | 14.1 | 32.95 | 37.19 | 32.45
 |  |  | 12.58 | 1.18 | 61.65 | 37.61 | 49.07
 |  |  | 22.45 | 2.53 | 61.71 | 38.09 | 39.26
 |  |  | 30.39 | 0.66 | 65.43 | 38.28 | 35.04
 |  |  | 25.31 | 0.23 | 65.39 | 40.47 | 40.08
 |  |  | 0.04 | 0.97 | 34.92 | 49.86 | 34.52
 |  |  | 2.75 | 8.46 | 64.26 | 59.34 | 61.51
 |  |  | 9.34 | 2.03 | 64.26 | 58.94 | 54.92
 |  |  | 7.01 | 0.8 | 67.99 | 54.19 | 60.98
 |  |  | 20.22 | 0.36 | 66.59 | 46.72 | 46.37
 |  |  | 0.09 | 0.46 | 68.71 | 85.84 | 68.62
Total January
 |  |  | 6.65 | 40.39 | 67.33 | 91.57 | 60.68
 |  |  | 15.42 | 24.63 | 68.44 | 70.68 | 53.02
 |  |  | 15.05 | 15.62 | 66.64 | 68.46 | 51.59
 |  |  | 16.63 | 10.04 | 69.68 | 64.01 | 53.05
 |  |  | 19.35 | 5.07 | 71.09 | 52.5 | 51.74
 |  |  | 18.12 | 4.01 | 71.21 | 56.95 | 53.09
 |  |  | 5.87 | 2.49 | 70.65 | 73.37 | 64.78
 |  |  | 0.13 | 13.23 | 43.76 | 57.26 | 43.63
 |  |  | 29.78 | 0.34 | 70.49 | 33.2 | 40.71
 |  |  | 12.94 | 1.73 | 59.49 | 59.97 | 46.55
 |  |  | 0.31 | 24.12 | 49.83 | 74.03 | 49.52
 |  |  | 0.28 | 31.77 | 26.4 | 64.77 | 26.12
 |  |  | 0.25 | 21.61 | 49.39 | 52.28 | 49.14
 |  |  | 0.06 | 7.88 | 34.76 | 60.57 | 34.7
 |  |  | 11.69 | 24.9 | 61.35 | 55.37 | 49.66
 |  |  | 16.75 | 6.32 | 69.66 | 60.64 | 52.91
 |  |  | 15.47 | 1.99 | 65.11 | 49.68 | 49.64
 |  |  | 0.03 | 2.15 | 34.94 | 51.25 | 34.91
 |  |  | 0.06 | 14.63 | 42.27 | 57.69 | 42.21
 |  |  | 0.04 | 26.83 | 27.29 | 57.54 | 27.25
 |  |  | 0.02 | 22.01 | 36.81 | 55.65 | 36.79
 |  |  | 0.72 | 21.84 | 36.95 | 59.82 | 36.23
 |  |  | 1.23 | 16.59 | 54.95 | 67.68 | 53.72
 |  |  | 14 | 55.17 | 44.74 | 102.7 | 44.6
 |  |  | 29 | 34.37 | 43.05 | 77.11 | 42.76
 |  |  | 15.57 | 28.02 | 72.01 | 66.01 | 56.44
 |  |  | 0.55 | 9.21 | 49.88 | 58.4 | 49.33
 |  |  | 11.9 | 7.24 | 64.01 | 60.96 | 52.11
 |  |  | 0 | 0 | 0 | 0 | 0
Total February
 |  |  | 25.47 | 15.17 | 79.72 | 71.05 | 54.25
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
Total March
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
Total April
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
Total May
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
Total June
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
Total July
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
Total August
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
Total September
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
Total October
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 |  | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
Total November
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0
Total December