Spreadsheet: 679863d1590662912-skipping-results-from-if-within-average-example3
Sheet: Sheet1

 | Real World Example :-)
 |  | January | February | March | April | May | June | July | August | September | October | November | December | Year
 | 2015 | 895.965 | 539.381 | 718.215 | 530.197 | 426.422 | 385.983 | 311.227 | 317.951 | 434.068 | 693.821 | 582.281 | 816.084 | 6651.595
 |  | 98.52150537634408 | 99.55357142857143 | 100 | 98.05555555555556 | 90.05376344086021 | 96.94444444444444 | 97.04301075268818 | 99.05913978494624 | 100 | 99.05913978494624 | 100 | 97.98387096774194 | 98.02283346134152
 |  | 189.8 | 92.9 | 123.4 | 93.7 | 99.2 | 68.6 | 99.4 | 45.8 | 73.9 | 50.8 | 168.5 | 201.1 | 108.925
 |  | 909.4105866302865 | 541.7997488789238 | 718.215 | 540.710821529745 | 473.5193552238807 | 398.148653295129 | 320.7103711911357 | 320.9708873812755 | 434.068 | 700.4108873812754 | 582.281 | 832.8758518518517 | 6773.121163363504
 |  | 479.1415103426167 | 583.2074799557845 | 582.0218800648298 | 577.0659781534098 | 477.3380597014926 | 580.3916228791968 | 322.6462486832351 | 700.8097977757106 | 587.3721244925574 | 1378.761589333219 | 345.5673590504451 | 414.160045674715 | 7028.483696107212
 | 2016 | 507.473 | 633.958 | 843.252 | 511.247 | 514.278 | 375.464 | 383.593 | 254.28 |  | 625.067 |  |  | 4648.611999999999
 |  | 54.97311827956989 | 98.06547619047619 | 93.95161290322581 | 100 | 99.05913978494624 | 98.05555555555556 | 97.04301075268818 | 93.95161290322581 |  | 100 | 99.02777777777779 |  | 93.41273041474655
 |  | 143.8 | 140.3 | 77.8 | 85.2 | 73.3 | 45.1 | 61.2 | 62.1 | 57.4 | 62.7 | 80.9 | 131.1 | 85.075
 |  | 923.129369193154 | 646.464 | 897.53860944206 | 511.247 | 519.1625943012211 | 382.9094617563739 | 395.2814293628809 | 270.649957081545 |  | 625.067 |  |  | 5171.449421137235
 |  | 641.9536642511501 | 460.7726300784034 | 1153.648598254576 | 600.0551643192489 | 708.2709335623754 | 849.0231967990551 | 645.8846885014393 | 435.8292384565942 |  | 996.9170653907495 |  |  | 6492.355179613591
 |  |  |  |  |  |  |  |  |  | X |  | X | X | X |  | <-- appears when there are 3 or more datasets missing
 | 2017 | 491.935 | 779.695 | 623.227 | 668.731 | 429.892 | 515.873 | 363.192 | 316.133 | 387.57 | 930.862 | 777.946 | 999.43 | 7284.486
 |  | 97.98387096774194 | 98.51190476190477 | 98.52150537634408 | 99.86111111111111 | 99.86559139784946 | 99.16666666666667 | 99.86559139784946 | 97.71505376344086 | 97.91666666666666 | 100 | 99.30555555555556 | 99.86559139784946 | 99.04825908858167
 |  | 83.4 | 116.9 | 99.3 | 119.5 | 82.7 | 92.3 | 52.4 | 59.4 | 67.1 | 127.3 | 101.7 | 163.6 | 97.13333333333333
 |  | 502.0571193415637 | 791.4728700906344 | 632.579656207367 | 669.6610848400555 | 430.4705895020189 | 520.2080672268908 | 363.6808183041723 | 323.5253810178817 | 395.816170212766 | 930.862 | 783.3861818181819 | 1000.775127860027 | 7344.495066421559
 |  | 601.9869536469589 | 677.0512147909618 | 637.0389287083252 | 560.3858450544398 | 520.5206644522599 | 563.6057066380181 | 694.0473631759014 | 544.6555235991274 | 589.8899705108287 | 731.234878240377 | 770.2912308930008 | 611.72073830075 | 7502.429018010949
 | 2018 | 895.965 | 539.381 | 718.215 | 530.197 | 426.422 |  | 311.227 |  |  | 693.821 | 582.281 | 816.084 | 6651.595
 |  | 98.52150537634408 | 99.55357142857143 | 100 | 98.05555555555556 | 90.05376344086021 |  | 97.04301075268818 |  |  | 99.05913978494624 | 100 | 97.98387096774194 | 98.02283346134152
 |  | 142.2 | 71 | 115.5 | 85.6 | 69.9 |  | 50.3 |  |  | 101.6 | 82.8 | 124.1 | 86.66666666666664
 |  | 909.4105866302865 | 541.7997488789238 | 718.215 | 540.710821529745 | 473.5193552238807 |  | 320.7103711911357 |  |  | 700.4108873812754 | 582.281 | 832.8758518518517 | 6773.121163363504
 |  | 639.5292451689779 | 763.0982378576391 | 621.8311688311688 | 631.6715204786741 | 677.4239702773687 |  | 637.5951713541466 |  |  | 689.3807946666097 | 703.237922705314 | 671.1328379144657 | 7810.035195441871
 |  |  |  |  |  |  | X |  | X | X |  |  |  | X |  | <-- appears when there are 3 or more datasets missing
 | 2019 | 507.473 | 633.958 | 843.252 | 511.247 | 514.278 | 375.464 | 383.593 | 254.28 | 455.43 | 625.067 | 534.779 | 832.408 | 6471.229
 |  | 54.97311827956989 | 98.06547619047619 | 93.95161290322581 | 100 | 99.05913978494624 | 98.05555555555556 | 97.04301075268818 | 93.95161290322581 | 95 | 100 | 99.02777777777779 | 98 | 93.9272753456221
 |  | 151.6 | 104 | 179.5 | 81 | 87.4 | 58.7 | 75 | 45.6 | 82.5 | 86.7 | 67.4 | 127.4 | 95.56666666666668
 |  | 923.129369193154 | 646.464 | 897.53860944206 | 511.247 | 519.1625943012211 | 382.9094617563739 | 395.2814293628809 | 270.649957081545 | 479.4 | 625.067 | 540.0292847124824 | 849.395918367347 | 7040.274624217063
 |  | 608.9243860113154 | 621.6 | 500.0215094384736 | 631.1691358024691 | 594.0075449670722 | 652.3159484776387 | 527.0419058171746 | 593.5306076349672 | 581.0909090909091 | 720.9538638985006 | 801.2303927484902 | 666.7157914971326 | 7498.601995384142