Spreadsheet: 679873d1590668640-skipping-results-from-if-within-average-example3
Sheet: example

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year |  | Filter
 |  | Attribut1 | [unit] | 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
 |  | Attribut2 | [unit] | 98.52150537634408 | 99.55357142857143 | 100 | 98.05555555555556 | 90.05376344086021 | 96.94444444444444 | 97.04301075268818 | 99.05913978494624 | 100 | 99.05913978494624 | 100 | 97.98387096774194 | 98.02283346134152 |  | Permissible unvalid month per year: |  | 2
 |  | Attribut3 | [unit] | 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
 |  | Attribut4 | [unit]
 |  | Attribut5 | [unit]
 |  | Attribut1 | [unit] | 507.473 | 633.958 | 843.252 | 511.247 | 514.278 | 375.464 | 383.593 | 254.28 |  | 625.067 |  |  | 4648.611999999999 |  | Years should be filtered out when there are either 3 months without data, 3 months manually X'ed out or year manually X'ed out
 |  | Attribut2 | [unit] | 54.97311827956989 | 98.06547619047619 | 93.95161290322581 | 100 | 99.05913978494624 | 98.05555555555556 | 97.04301075268818 | 93.95161290322581 |  | 100 | 99.02777777777779 |  | 93.41273041474655
 |  | Attribut3 | [unit] | 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
 |  | Attribut4 | [unit]
 |  | Attribut5 | [unit]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <--- rows underneath the data area are for filtering by using "X"
 |  | Attribut1 | [unit] | 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
 |  | Attribut2 | [unit] | 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
 |  | Attribut3 | [unit] | 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
 |  | Attribut4 | [unit]
 |  | Attribut5 | [unit]
 |  |  |  |  |  |  |  |  |  | X | X | X
 |  | Attribut1 | [unit] | 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
 |  | Attribut2 | [unit] | 98.52150537634408 | 99.55357142857143 | 100 | 98.05555555555556 | 90.05376344086021 | 96.94444444444444 | 97.04301075268818 | 99.05913978494624 | 100 | 99.05913978494624 | 100 | 97.98387096774194 | 98.02283346134152
 |  | Attribut3 | [unit] | 142.2 | 71 | 115.5 | 85.6 | 69.9 | 57.6 | 50.3 | 59 | 80.4 | 101.6 | 82.8 | 124.1 | 86.66666666666664
 |  | Attribut4 | [unit]
 |  | Attribut5 | [unit]
 | 2019 | Attribut1 | [unit] | 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
 |  | Attribut2 | [unit] | 54.97311827956989 | 98.06547619047619 | 93.95161290322581 | 100 | 99.05913978494624 | 98.05555555555556 | 97.04301075268818 | 93.95161290322581 | 95 | 100 | 99.02777777777779 | 98 | 93.9272753456221
 |  | Attribut3 | [unit] | 151.6 | 104 | 179.5 | 81 | 87.4 | 58.7 | 75 | 45.6 | 82.5 | 86.7 | 67.4 | 127.4 | 95.56666666666668
 |  | Attribut4 | [unit]
 |  | Attribut5 | [unit]
 |  | Mittelwert der [NAME]
 |  | Standardabweichung
 |  | [NAME]
 |  | Result1
 |  | Result2
 |  | Result3 |  |  |  | <-- this average Value should only consider years which are not filtered out
 |  |  |  |  |  | in this case average(Q12;Q33;Q40)