Spreadsheet: 707073d1607019502-sum-with-dynamic-range-example1967
Sheet: Sheet1

Measure | Product | Value | Weeknum | Year |  | weeknum start | year
volume sales | Sodas | 26786534 | 47 | 2018 |  | 20 | 2019
volume sales | Sodas | 27324286 | 48 | 2018 |  |  |  |  | sodas | CHF Sales
volume sales | Sodas | 26946294 | 49 | 2018 |  | weeknum end | year |  |  |  |  |  |  | sodas | volume sales
volume sales | Sodas | 26614928 | 50 | 2018 |  | 20 | 2020 |  |  |  |  |  |  | waters | CHF sales
volume sales | Sodas | 31305960 | 51 | 2018
volume sales | Sodas | 28402124 | 52 | 2018
volume sales | Sodas | 28261410 | 1 | 2019 |  | Result:
volume sales | Sodas | 26057496 | 2 | 2019
volume sales | Sodas | 25919200 | 3 | 2019
volume sales | Sodas | 26769624 | 4 | 2019
volume sales | Sodas | 27049242 | 5 | 2019
volume sales | Sodas | 27081546 | 6 | 2019
volume sales | Sodas | 27464964 | 7 | 2019
volume sales | Sodas | 28192414 | 8 | 2019
volume sales | Sodas | 29284348 | 9 | 2019
volume sales | Sodas | 28041944 | 10 | 2019
volume sales | Sodas | 27579992 | 11 | 2019
volume sales | Sodas | 28846674 | 12 | 2019
volume sales | Sodas | 29225564 | 13 | 2019
volume sales | Sodas | 29337058 | 14 | 2019
volume sales | Sodas | 29708008 | 15 | 2019
volume sales | Sodas | 33498422 | 16 | 2019
volume sales | Sodas | 31485804 | 17 | 2019
volume sales | Sodas | 29904790 | 18 | 2019
volume sales | Sodas | 30056618 | 19 | 2019
volume sales | Sodas | 30702056 | 20 | 2019
volume sales | Sodas | 32206162 | 21 | 2019
volume sales | Sodas | 34604728 | 22 | 2019
volume sales | Sodas | 32928148 | 23 | 2019
volume sales | Sodas | 32397308 | 24 | 2019
volume sales | Sodas | 36297420 | 25 | 2019
volume sales | Sodas | 39192596 | 26 | 2019
volume sales | Sodas | 35032920 | 27 | 2019
volume sales | Sodas | 32180364 | 28 | 2019
volume sales | Sodas | 32972480 | 29 | 2019
volume sales | Sodas | 26786534 | 30 | 2019
volume sales | Sodas | 27324286 | 31 | 2019
volume sales | Sodas | 26946294 | 32 | 2019
volume sales | Sodas | 26614928 | 33 | 2019
volume sales | Sodas | 31305960 | 34 | 2019
volume sales | Sodas | 28402124 | 35 | 2019
volume sales | Sodas | 28261410 | 36 | 2019
volume sales | Sodas | 26057496 | 37 | 2019
volume sales | Sodas | 25919200 | 38 | 2019
volume sales | Sodas | 26769624 | 39 | 2019
volume sales | Sodas | 27049242 | 40 | 2019
volume sales | Sodas | 27081546 | 41 | 2019
volume sales | Sodas | 27464964 | 42 | 2019
volume sales | Sodas | 28192414 | 43 | 2019
volume sales | Sodas | 29284348 | 44 | 2019
volume sales | Sodas | 28041944 | 45 | 2019
volume sales | Sodas | 27579992 | 46 | 2019
volume sales | Sodas | 28846674 | 47 | 2019
volume sales | Sodas | 29225564 | 48 | 2019
volume sales | Sodas | 29337058 | 49 | 2019
volume sales | Sodas | 29708008 | 50 | 2019
volume sales | Sodas | 33498422 | 51 | 2019
volume sales | Sodas | 31485804 | 52 | 2019
volume sales | Sodas | 29904790 | 1 | 2020
volume sales | Sodas | 30056618 | 2 | 2020
volume sales | Sodas | 30702056 | 3 | 2020
volume sales | Sodas | 32206162 | 4 | 2020
volume sales | Sodas | 34604728 | 5 | 2020
volume sales | Sodas | 32928148 | 6 | 2020
volume sales | Sodas | 32397308 | 7 | 2020
volume sales | Sodas | 36297420 | 8 | 2020
volume sales | Sodas | 39192596 | 9 | 2020
volume sales | Sodas | 35032920 | 10 | 2020
volume sales | Sodas | 32180364 | 11 | 2020
volume sales | Sodas | 32972480 | 12 | 2020
volume sales | Sodas | 26786534 | 13 | 2020
volume sales | Sodas | 27324286 | 14 | 2020
volume sales | Sodas | 26946294 | 15 | 2020
volume sales | Sodas | 26614928 | 16 | 2020
volume sales | Sodas | 31305960 | 17 | 2020
volume sales | Sodas | 28402124 | 18 | 2020
volume sales | Sodas | 28261410 | 19 | 2020
volume sales | Sodas | 26057496 | 20 | 2020
volume sales | Sodas | 25919200 | 21 | 2020
volume sales | Sodas | 26769624 | 22 | 2020
volume sales | Sodas | 27049242 | 23 | 2020
volume sales | Sodas | 27081546 | 24 | 2020
volume sales | Sodas | 27464964 | 25 | 2020
volume sales | Sodas | 28192414 | 26 | 2020
volume sales | Sodas | 29284348 | 27 | 2020
volume sales | Sodas | 28041944 | 28 | 2020
CHF sales | Sodas | 27116008.3682 | 47 | 2018
CHF sales | Sodas | 27660374.7178 | 48 | 2018
CHF sales | Sodas | 27277733.4162 | 49 | 2018
CHF sales | Sodas | 26942291.6144 | 50 | 2018
CHF sales | Sodas | 31691023.308 | 51 | 2018
CHF sales | Sodas | 28751470.1252 | 52 | 2018
CHF sales | Sodas | 28609025.343 | 1 | 2019
CHF sales | Sodas | 26378003.2008 | 2 | 2019
CHF sales | Sodas | 26238006.16 | 3 | 2019
CHF sales | Sodas | 27098890.3752 | 4 | 2019
CHF sales | Sodas | 27381947.6766 | 5 | 2019
CHF sales | Sodas | 27414649.0158 | 6 | 2019
CHF sales | Sodas | 27802783.0572 | 7 | 2019
CHF sales | Sodas | 28539180.6922 | 8 | 2019
CHF sales | Sodas | 29644545.4804 | 9 | 2019
CHF sales | Sodas | 28386859.9112 | 10 | 2019
CHF sales | Sodas | 27919225.9016 | 11 | 2019
CHF sales | Sodas | 29201488.0902 | 12 | 2019
CHF sales | Sodas | 29585038.4372 | 13 | 2019
CHF sales | Sodas | 29697903.8134 | 14 | 2019
CHF sales | Sodas | 30073416.4984 | 15 | 2019
CHF sales | Sodas | 33910452.5906 | 16 | 2019
CHF sales | Sodas | 31873079.3892 | 17 | 2019
CHF sales | Sodas | 30272618.917 | 18 | 2019
CHF sales | Sodas | 30426314.4014 | 19 | 2019
CHF sales | Sodas | 31079691.2888 | 20 | 2019
CHF sales | Sodas | 32602297.7926 | 21 | 2019
CHF sales | Sodas | 35030366.1544 | 22 | 2019
CHF sales | Sodas | 33333164.2204 | 23 | 2019
CHF sales | Sodas | 32795794.8884 | 24 | 2019
CHF sales | Sodas | 36743878.266 | 25 | 2019
CHF sales | Sodas | 39674664.9308 | 26 | 2019
CHF sales | Sodas | 35463824.916 | 27 | 2019
CHF sales | Sodas | 32576182.4772 | 28 | 2019
CHF sales | Sodas | 33378041.504 | 29 | 2019
CHF sales | Sodas | 27116008.3682 | 30 | 2019
CHF sales | Sodas | 27660374.7178 | 31 | 2019
CHF sales | Sodas | 27277733.4162 | 32 | 2019
CHF sales | Sodas | 26942291.6144 | 33 | 2019
CHF sales | Sodas | 31691023.308 | 34 | 2019
CHF sales | Sodas | 28751470.1252 | 35 | 2019
CHF sales | Sodas | 28609025.343 | 36 | 2019
CHF sales | Sodas | 26378003.2008 | 37 | 2019
CHF sales | Sodas | 26238006.16 | 38 | 2019
CHF sales | Sodas | 27098890.3752 | 39 | 2019
CHF sales | Sodas | 27381947.6766 | 40 | 2019
CHF sales | Sodas | 27414649.0158 | 41 | 2019
CHF sales | Sodas | 27802783.0572 | 42 | 2019
CHF sales | Sodas | 28539180.6922 | 43 | 2019
CHF sales | Sodas | 29644545.4804 | 44 | 2019
CHF sales | Sodas | 28386859.9112 | 45 | 2019
CHF sales | Sodas | 27919225.9016 | 46 | 2019
CHF sales | Sodas | 29201488.0902 | 47 | 2019
CHF sales | Sodas | 29585038.4372 | 48 | 2019
CHF sales | Sodas | 29697903.8134 | 49 | 2019
CHF sales | Sodas | 30073416.4984 | 50 | 2019
CHF sales | Sodas | 33910452.5906 | 51 | 2019
CHF sales | Sodas | 31873079.3892 | 52 | 2019
CHF sales | Sodas | 30272618.917 | 1 | 2020
CHF sales | Sodas | 30426314.4014 | 2 | 2020
CHF sales | Sodas | 31079691.2888 | 3 | 2020
CHF sales | Sodas | 32602297.7926 | 4 | 2020
CHF sales | Sodas | 35030366.1544 | 5 | 2020
CHF sales | Sodas | 33333164.2204 | 6 | 2020
CHF sales | Sodas | 32795794.8884 | 7 | 2020
CHF sales | Sodas | 36743878.266 | 8 | 2020
CHF sales | Sodas | 39674664.9308 | 9 | 2020
CHF sales | Sodas | 35463824.916 | 10 | 2020
CHF sales | Sodas | 32576182.4772 | 11 | 2020
CHF sales | Sodas | 33378041.504 | 12 | 2020
CHF sales | Sodas | 27116008.3682 | 13 | 2020
CHF sales | Sodas | 27660374.7178 | 14 | 2020
CHF sales | Sodas | 27277733.4162 | 15 | 2020
CHF sales | Sodas | 26942291.6144 | 16 | 2020
CHF sales | Sodas | 31691023.308 | 17 | 2020
CHF sales | Sodas | 28751470.1252 | 18 | 2020
CHF sales | Sodas | 28609025.343 | 19 | 2020
CHF sales | Sodas | 26378003.2008 | 20 | 2020
CHF sales | Sodas | 26238006.16 | 21 | 2020
CHF sales | Sodas | 27098890.3752 | 22 | 2020
CHF sales | Sodas | 27381947.6766 | 23 | 2020
CHF sales | Sodas | 27414649.0158 | 24 | 2020
CHF sales | Sodas | 27802783.0572 | 25 | 2020
CHF sales | Sodas | 28539180.6922 | 26 | 2020
CHF sales | Sodas | 29644545.4804 | 27 | 2020
CHF sales | Sodas | 28386859.9112 | 28 | 2020
volume sales | Waters | 17857689.33333333 | 47 | 2018
volume sales | Waters | 18216190.66666667 | 48 | 2018
volume sales | Waters | 17964196 | 49 | 2018
volume sales | Waters | 17743285.33333333 | 50 | 2018
volume sales | Waters | 20870640 | 51 | 2018
volume sales | Waters | 18934749.33333333 | 52 | 2018
volume sales | Waters | 18840940 | 1 | 2019
volume sales | Waters | 17371664 | 2 | 2019
volume sales | Waters | 17279466.66666667 | 3 | 2019
volume sales | Waters | 17846416 | 4 | 2019
volume sales | Waters | 18032828 | 5 | 2019
volume sales | Waters | 18054364 | 6 | 2019
volume sales | Waters | 18309976 | 7 | 2019
volume sales | Waters | 18794942.66666667 | 8 | 2019
volume sales | Waters | 19522898.66666667 | 9 | 2019
volume sales | Waters | 18694629.33333333 | 10 | 2019
volume sales | Waters | 18386661.33333333 | 11 | 2019
volume sales | Waters | 19231116 | 12 | 2019
volume sales | Waters | 19483709.33333333 | 13 | 2019
volume sales | Waters | 19558038.66666667 | 14 | 2019
volume sales | Waters | 19805338.66666667 | 15 | 2019
volume sales | Waters | 22332281.33333333 | 16 | 2019
volume sales | Waters | 20990536 | 17 | 2019
volume sales | Waters | 19936526.66666667 | 18 | 2019
volume sales | Waters | 20037745.33333333 | 19 | 2019
volume sales | Waters | 20468037.33333333 | 20 | 2019
volume sales | Waters | 21470774.66666667 | 21 | 2019
volume sales | Waters | 23069818.66666667 | 22 | 2019
volume sales | Waters | 21952098.66666667 | 23 | 2019
volume sales | Waters | 21598205.33333333 | 24 | 2019
volume sales | Waters | 24198280 | 25 | 2019
volume sales | Waters | 26128397.33333333 | 26 | 2019
volume sales | Waters | 23355280 | 27 | 2019
volume sales | Waters | 21453576 | 28 | 2019
volume sales | Waters | 21981653.33333333 | 29 | 2019
volume sales | Waters | 17857689.33333333 | 30 | 2019
volume sales | Waters | 18216190.66666667 | 31 | 2019
volume sales | Waters | 17964196 | 32 | 2019
volume sales | Waters | 17743285.33333333 | 33 | 2019
volume sales | Waters | 20870640 | 34 | 2019
volume sales | Waters | 18934749.33333333 | 35 | 2019
volume sales | Waters | 18840940 | 36 | 2019
volume sales | Waters | 17371664 | 37 | 2019
volume sales | Waters | 17279466.66666667 | 38 | 2019
volume sales | Waters | 17846416 | 39 | 2019
volume sales | Waters | 18032828 | 40 | 2019
volume sales | Waters | 18054364 | 41 | 2019
volume sales | Waters | 18309976 | 42 | 2019
volume sales | Waters | 18794942.66666667 | 43 | 2019
volume sales | Waters | 19522898.66666667 | 44 | 2019
volume sales | Waters | 18694629.33333333 | 45 | 2019
volume sales | Waters | 18386661.33333333 | 46 | 2019
volume sales | Waters | 19231116 | 47 | 2019
volume sales | Waters | 19483709.33333333 | 48 | 2019
volume sales | Waters | 19558038.66666667 | 49 | 2019
volume sales | Waters | 19805338.66666667 | 50 | 2019
volume sales | Waters | 22332281.33333333 | 51 | 2019
volume sales | Waters | 20990536 | 52 | 2019
volume sales | Waters | 19936526.66666667 | 1 | 2020
volume sales | Waters | 20037745.33333333 | 2 | 2020
volume sales | Waters | 20468037.33333333 | 3 | 2020
volume sales | Waters | 21470774.66666667 | 4 | 2020
volume sales | Waters | 23069818.66666667 | 5 | 2020
volume sales | Waters | 21952098.66666667 | 6 | 2020
volume sales | Waters | 21598205.33333333 | 7 | 2020
volume sales | Waters | 24198280 | 8 | 2020
volume sales | Waters | 26128397.33333333 | 9 | 2020
volume sales | Waters | 23355280 | 10 | 2020
volume sales | Waters | 21453576 | 11 | 2020
volume sales | Waters | 21981653.33333333 | 12 | 2020
volume sales | Waters | 17857689.33333333 | 13 | 2020
volume sales | Waters | 18216190.66666667 | 14 | 2020
volume sales | Waters | 17964196 | 15 | 2020
volume sales | Waters | 17743285.33333333 | 16 | 2020
volume sales | Waters | 20870640 | 17 | 2020
volume sales | Waters | 18934749.33333333 | 18 | 2020
volume sales | Waters | 18840940 | 19 | 2020
volume sales | Waters | 17371664 | 20 | 2020
volume sales | Waters | 17279466.66666667 | 21 | 2020
volume sales | Waters | 17846416 | 22 | 2020
volume sales | Waters | 18032828 | 23 | 2020
volume sales | Waters | 18054364 | 24 | 2020
volume sales | Waters | 18309976 | 25 | 2020
volume sales | Waters | 18794942.66666667 | 26 | 2020
volume sales | Waters | 19522898.66666667 | 27 | 2020
volume sales | Waters | 18694629.33333333 | 28 | 2020
CHF sales | Waters | 18077338.91213333 | 47 | 2018
CHF sales | Waters | 18440249.81186667 | 48 | 2018
CHF sales | Waters | 18185155.6108 | 49 | 2018
CHF sales | Waters | 17961527.74293333 | 50 | 2018
CHF sales | Waters | 21127348.872 | 51 | 2018
CHF sales | Waters | 19167646.75013333 | 52 | 2018
CHF sales | Waters | 19072683.562 | 1 | 2019
CHF sales | Waters | 17585335.4672 | 2 | 2019
CHF sales | Waters | 17492004.10666667 | 3 | 2019
CHF sales | Waters | 18065926.9168 | 4 | 2019
CHF sales | Waters | 18254631.7844 | 5 | 2019
CHF sales | Waters | 18276432.6772 | 6 | 2019
CHF sales | Waters | 18535188.7048 | 7 | 2019
CHF sales | Waters | 19026120.46146667 | 8 | 2019
CHF sales | Waters | 19763030.32026667 | 9 | 2019
CHF sales | Waters | 18924573.27413333 | 10 | 2019
CHF sales | Waters | 18612817.26773333 | 11 | 2019
CHF sales | Waters | 19467658.7268 | 12 | 2019
CHF sales | Waters | 19723358.95813333 | 13 | 2019
CHF sales | Waters | 19798602.54226667 | 14 | 2019
CHF sales | Waters | 20048944.33226667 | 15 | 2019
CHF sales | Waters | 22606968.39373333 | 16 | 2019
CHF sales | Waters | 21248719.5928 | 17 | 2019
CHF sales | Waters | 20181745.94466667 | 18 | 2019
CHF sales | Waters | 20284209.60093333 | 19 | 2019
CHF sales | Waters | 20719794.19253333 | 20 | 2019
CHF sales | Waters | 21734865.19506667 | 21 | 2019
CHF sales | Waters | 23353577.43626667 | 22 | 2019
CHF sales | Waters | 22222109.48026667 | 23 | 2019
CHF sales | Waters | 21863863.25893333 | 24 | 2019
CHF sales | Waters | 24495918.844 | 25 | 2019
CHF sales | Waters | 26449776.62053333 | 26 | 2019
CHF sales | Waters | 23642549.944 | 27 | 2019
CHF sales | Waters | 21717454.9848 | 28 | 2019
CHF sales | Waters | 22252027.66933333 | 29 | 2019
CHF sales | Waters | 18077338.91213333 | 30 | 2019
CHF sales | Waters | 18440249.81186667 | 31 | 2019
CHF sales | Waters | 18185155.6108 | 32 | 2019
CHF sales | Waters | 17961527.74293333 | 33 | 2019
CHF sales | Waters | 21127348.872 | 34 | 2019
CHF sales | Waters | 19167646.75013333 | 35 | 2019
CHF sales | Waters | 19072683.562 | 36 | 2019
CHF sales | Waters | 17585335.4672 | 37 | 2019
CHF sales | Waters | 17492004.10666667 | 38 | 2019
CHF sales | Waters | 18065926.9168 | 39 | 2019
CHF sales | Waters | 18254631.7844 | 40 | 2019
CHF sales | Waters | 18276432.6772 | 41 | 2019
CHF sales | Waters | 18535188.7048 | 42 | 2019
CHF sales | Waters | 19026120.46146667 | 43 | 2019
CHF sales | Waters | 19763030.32026667 | 44 | 2019
CHF sales | Waters | 18924573.27413333 | 45 | 2019
CHF sales | Waters | 18612817.26773333 | 46 | 2019
CHF sales | Waters | 19467658.7268 | 47 | 2019
CHF sales | Waters | 19723358.95813333 | 48 | 2019
CHF sales | Waters | 19798602.54226667 | 49 | 2019
CHF sales | Waters | 20048944.33226667 | 50 | 2019
CHF sales | Waters | 22606968.39373333 | 51 | 2019
CHF sales | Waters | 21248719.5928 | 52 | 2019
CHF sales | Waters | 20181745.94466667 | 1 | 2020
CHF sales | Waters | 20284209.60093333 | 2 | 2020
CHF sales | Waters | 20719794.19253333 | 3 | 2020
CHF sales | Waters | 21734865.19506667 | 4 | 2020
CHF sales | Waters | 23353577.43626667 | 5 | 2020
CHF sales | Waters | 22222109.48026667 | 6 | 2020
CHF sales | Waters | 21863863.25893333 | 7 | 2020
CHF sales | Waters | 24495918.844 | 8 | 2020
CHF sales | Waters | 26449776.62053333 | 9 | 2020
CHF sales | Waters | 23642549.944 | 10 | 2020
CHF sales | Waters | 21717454.9848 | 11 | 2020
CHF sales | Waters | 22252027.66933333 | 12 | 2020
CHF sales | Waters | 18077338.91213333 | 13 | 2020
CHF sales | Waters | 18440249.81186667 | 14 | 2020
CHF sales | Waters | 18185155.6108 | 15 | 2020
CHF sales | Waters | 17961527.74293333 | 16 | 2020
CHF sales | Waters | 21127348.872 | 17 | 2020
CHF sales | Waters | 19167646.75013333 | 18 | 2020
CHF sales | Waters | 19072683.562 | 19 | 2020
CHF sales | Waters | 17585335.4672 | 20 | 2020
CHF sales | Waters | 17492004.10666667 | 21 | 2020
CHF sales | Waters | 18065926.9168 | 22 | 2020
CHF sales | Waters | 18254631.7844 | 23 | 2020
CHF sales | Waters | 18276432.6772 | 24 | 2020
CHF sales | Waters | 18535188.7048 | 25 | 2020
CHF sales | Waters | 19026120.46146667 | 26 | 2020
CHF sales | Waters | 19763030.32026667 | 27 | 2020
CHF sales | Waters | 18924573.27413333 | 28 | 2020