Spreadsheet: 707007d1606997230-sum-with-dynamic-range-sample-data
Sheet: Sheet1

Measure | Product | Value | Weeknum | Year |  | weeknum start | year
volume sales | Sodas | 26786534 | 47 | 2018 |  | 20 | 2019
volume sales | Sodas | 27324286 | 48 | 2018
volume sales | Sodas | 26946294 | 49 | 2018 |  | weeknum end | year
volume sales | Sodas | 26614928 | 50 | 2018 |  | 20 | 2020
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