Spreadsheet: 864275d1711496552-sum-filter-using-a-dynamic-range-to-calculate-year-to-date-ytd-data-sample-offset-function
Sheet: Data

Type |  | 2024 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023
 |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | TTL |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | TTL
TTL |  | 38634 | 33956 |  |  |  |  |  |  |  |  |  |  | 72590 |  | 39864 | 38156 | 40981 | 34844 | 40413 | 37893 | 41157 | 40946 | 41882 | 41355 | 36885 | 32017 | 466393
D |  | -37 | -6 |  |  |  |  |  |  |  |  |  |  | -43 |  | -2304 | -40 | 67 | -75 | -4 | -2 | -18 | 3 | -344 | -30 | -5 | -1 | -2753
C |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
B |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
B |  | 919 | 1056 |  |  |  |  |  |  |  |  |  |  | 1975 |  | 653 | 815 | 861 | 672 | 718 | 722 | 706 | 733 | 851 | 805 | 911 | 655 | 9102
L |  | 194 | 95 |  |  |  |  |  |  |  |  |  |  | 289 |  | 79 | 132 | 114 | 207 | 165 | 203 | 180 | 70 | 125 | 92 | 90 | 89 | 1546
L |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
L |  | 39 | 39 |  |  |  |  |  |  |  |  |  |  | 78 |  | 17 | 69 | 66 | 146 | 176 | 93 | 33 | 1126 | 29 | 41 | 17 | 45 | 1858
L |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
B |  | 470 | 505 |  |  |  |  |  |  |  |  |  |  | 975 |  | 504 | 425 | 445 | 364 | 445 | 427 | 588 | 1010 | 502 | 516 | 380 | 320 | 5926
B |  | 2859 | 2204 |  |  |  |  |  |  |  |  |  |  | 5063 |  | 2563 | 2054 | 1790 | 1402 | 1534 | 1336 | 1718 | 1745 | 1684 | 2179 | 2572 | 2775 | 23352
B |  | 3771 | 4083 |  |  |  |  |  |  |  |  |  |  | 7854 |  | 4236 | 4426 | 4709 | 4000 | 4287 | 4267 | 3978 | 3967 | 4909 | 4165 | 3547 | 2681 | 49172
B |  | 34 | 44 |  |  |  |  |  |  |  |  |  |  | 78 |  | 106 | 75 | 89 | 109 | 129 | 91 | 78 | 87 | 138 | 118 | 75 | 25 | 1120
B |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
L |  | 53 | 48 |  |  |  |  |  |  |  |  |  |  | 101 |  | 29 | 43 | 73 | 54 | 70 | 93 | 107 | 79 | 109 | 37 | 41 | 51 | 786
L |  | 446 | 510 |  |  |  |  |  |  |  |  |  |  | 956 |  | 362 | 450 | 404 | 347 | 400 | 435 | 436 | 329 | 324 | 444 | 324 | 366 | 4621
B |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -3 | -1 | -2 | -2 | -8
L |  | 151 | 155 |  |  |  |  |  |  |  |  |  |  | 306 |  | 184 | 153 | 196 | 177 | 190 | 245 | 150 | 148 | 173 | 208 | 213 | 154 | 2191
L |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
B |  | 16 | 25 |  |  |  |  |  |  |  |  |  |  | 41 |  | -4 | 17 | 27 | 20 | 26 | 36 | 8 | 116 | 59 | 33 | 18 | 2 | 358
L |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 7 | 6 | 0 | 0 | 21
B |  | 425 | 483 |  |  |  |  |  |  |  |  |  |  | 908 |  | 0 | 0 | -1 | 0 | 0 | 0 | 0 | 1 | 390 | 539 | 360 | 197 | 1486
L |  | 17 | 9 |  |  |  |  |  |  |  |  |  |  | 26 |  | 9 | 26 | 54 | 39 | 3 | 47 | 8 | 20 | 25 | 8 | 0 | 7 | 246
L |  | 711 | 602 |  |  |  |  |  |  |  |  |  |  | 1313 |  | 624 | 549 | 691 | 493 | 588 | 392 | 403 | 536 | 473 | 547 | 528 | 430 | 6254
L |  | 54 | 35 |  |  |  |  |  |  |  |  |  |  | 89 |  | 59 | 40 | 58 | 59 | 79 | 113 | 73 | 59 | 51 | 20 | 17 | 40 | 668
L |  | 305 | 185 |  |  |  |  |  |  |  |  |  |  | 490 |  | 219 | 82 | 157 | 109 | 171 | 598 | 548 | 259 | 405 | 202 | 265 | 546 | 3561
L |  | 332 | 275 |  |  |  |  |  |  |  |  |  |  | 607 |  | 79 | 82 | 118 | 170 | 208 | 230 | 319 | 287 | 261 | 251 | 304 | 251 | 2560
B |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | -8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -8
B |  | 2629 | 2903 |  |  |  |  |  |  |  |  |  |  | 5532 |  | 3196 | 3230 | 3625 | 2607 | 2855 | 2903 | 2389 | 2719 | 3196 | 3066 | 2361 | 1493 | 33640
B |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
L |  | 507 | 716 |  |  |  |  |  |  |  |  |  |  | 1223 |  | 506 | 686 | 560 | 294 | 403 | 629 | 428 | 545 | 561 | 591 | 501 | 391 | 6095
L |  | -1 | -1 |  |  |  |  |  |  |  |  |  |  | -2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1
O |  | 24471 | 19736 |  |  |  |  |  |  |  |  |  |  | 44207 |  | 28504 | 24596 | 26586 | 23331 | 27704 | 24817 | 28873 | 26838 | 27643 | 27232 | 24136 | 21296 | 311556
B |  | 74 | 89 |  |  |  |  |  |  |  |  |  |  | 163 |  | 41 | 57 | 105 | 52 | 89 | 44 | 24 | 86 | 101 | 67 | 34 | 34 | 734
B |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
B |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
B |  | 0 | -5 |  |  |  |  |  |  |  |  |  |  | -5 |  | -7 | 4 | 1 | 4 | -7 | 8 | -7 | 11 | 4 | 3 | -5 | 0 | 9
L |  | 10 | 20 |  |  |  |  |  |  |  |  |  |  | 30 |  | 25 | 38 | 51 | 47 | 47 | 22 | 12 | 30 | 21 | 53 | 48 | 11 | 405
B |  | 185 | 151 |  |  |  |  |  |  |  |  |  |  | 336 |  | 183 | 146 | 142 | 215 | 136 | 143 | 122 | 141 | 188 | 163 | 154 | 161 | 1894