Spreadsheet: 786618d1657303770-how-to-add-month-by-month-to-get-ytd-using-getpivotdata-in-google-sheet-2022-07-08-oeldere-johnyam54-how-to-sum-vlookup
Sheet: Oeldere PT

Rijlabels | Sum Value | Rolling (YTD)
Product 1 | 203140
Direct Cost 1 | 75612
202104 | 8571 | 8571
202105 | 9221 | 17792
202106 | 9541 | 27333
202107 | 4626 | 31959
202108 | 6726 | 38685
202109 | 5564 | 44249
202110 | 4378 | 48627
202111 | 5478 | 54105
202112 | 2869 | 56974
202201 | 8168 | 65142
202202 | 4108 | 69250
202203 | 6362 | 75612
Indirect Costs | 50450
202104 | 3403 | 3403
202105 | 3125 | 6528
202106 | 4643 | 11171
202107 | 3366 | 14537
202108 | 4892 | 19429
202109 | 4814 | 24243
202110 | 5508 | 29751
202111 | 4936 | 34687
202112 | 4036 | 38723
202201 | 4075 | 42798
202202 | 3100 | 45898
202203 | 4552 | 50450
Indirect Costs 1 | 77078
202104 | 5607 | 5607
202105 | 6761 | 12368
202106 | 7086 | 19454
202107 | 6513 | 25967
202108 | 7875 | 33842
202109 | 7267 | 41109
202110 | 5056 | 46165
202111 | 7114 | 53279
202112 | 5806 | 59085
202201 | 5019 | 64104
202202 | 5832 | 69936
202203 | 7142 | 77078
Product 2 | 206612
Direct Cost 1 | 77809
202104 | 8967 | 8967
202105 | 6031 | 14998
202106 | 8099 | 23097
202107 | 3025 | 26122
202108 | 4125 | 30247
202109 | 6815 | 37062
202110 | 6750 | 43812
202111 | 2605 | 46417
202112 | 5762 | 52179
202201 | 8093 | 60272
202202 | 7911 | 68183
202203 | 9626 | 77809
Indirect Costs | 50787
202104 | 4611 | 4611
202105 | 3659 | 8270
202106 | 5569 | 13839
202107 | 3353 | 17192
202108 | 4895 | 22087
202109 | 5035 | 27122
202110 | 3395 | 30517
202111 | 3926 | 34443
202112 | 5174 | 39617
202201 | 3147 | 42764
202202 | 4497 | 47261
202203 | 3526 | 50787
Indirect Costs 1 | 78016
202104 | 5171 | 5171
202105 | 6375 | 11546
202106 | 6528 | 18074
202107 | 6129 | 24203
202108 | 5855 | 30058
202109 | 7280 | 37338
202110 | 5735 | 43073
202111 | 7220 | 50293
202112 | 8277 | 58570
202201 | 7626 | 66196
202202 | 5878 | 72074
202203 | 5942 | 78016
Product 3 | 216866
Direct Cost 1 | 80636
202104 | 6514 | 6514
202105 | 5936 | 12450
202106 | 5680 | 18130
202107 | 8987 | 27117
202108 | 8266 | 35383
202109 | 6823 | 42206
202110 | 9391 | 51597
202111 | 8028 | 59625
202112 | 4672 | 64297
202201 | 3982 | 68279
202202 | 8039 | 76318
202203 | 4318 | 80636
Indirect Costs | 56031
202104 | 3812 | 3812
202105 | 5499 | 9311
202106 | 5302 | 14613
202107 | 3304 | 17917
202108 | 3312 | 21229
202109 | 5563 | 26792
202110 | 5444 | 32236
202111 | 4960 | 37196
202112 | 4629 | 41825
202201 | 5181 | 47006
202202 | 3799 | 50805
202203 | 5226 | 56031
Indirect Costs 1 | 80199
202104 | 6108 | 6108
202105 | 7199 | 13307
202106 | 8394 | 21701
202107 | 5048 | 26749
202108 | 5656 | 32405
202109 | 5925 | 38330
202110 | 6734 | 45064
202111 | 5101 | 50165
202112 | 6990 | 57155
202201 | 7442 | 64597
202202 | 7880 | 72477
202203 | 7722 | 80199
Product 4 | 219473
Direct Cost 1 | 80470
202104 | 4072 | 4072
202105 | 8040 | 12112
202106 | 7331 | 19443
202107 | 8748 | 28191
202108 | 9476 | 37667
202109 | 7030 | 44697
202110 | 7669 | 52366
202111 | 4775 | 57141
202112 | 3316 | 60457
202201 | 7485 | 67942
202202 | 5264 | 73206
202203 | 7264 | 80470
Indirect Costs | 55081
202104 | 5448 | 5448
202105 | 5275 | 10723
202106 | 4479 | 15202
202107 | 3205 | 18407
202108 | 4816 | 23223
202109 | 4563 | 27786
202110 | 5391 | 33177
202111 | 3487 | 36664
202112 | 4899 | 41563
202201 | 4502 | 46065
202202 | 5460 | 51525
202203 | 3556 | 55081
Indirect Costs 1 | 83922
202104 | 7978 | 7978
202105 | 6698 | 14676
202106 | 6884 | 21560
202107 | 7211 | 28771
202108 | 5184 | 33955
202109 | 5013 | 38968
202110 | 6663 | 45631
202111 | 6087 | 51718
202112 | 7851 | 59569
202201 | 7781 | 67350
202202 | 8286 | 75636
202203 | 8286 | 83922
Product 5 | 202961
Direct Cost 1 | 73704
202104 | 6158 | 6158
202105 | 5015 | 11173
202106 | 3579 | 14752
202107 | 3306 | 18058
202108 | 8319 | 26377
202109 | 9361 | 35738
202110 | 4328 | 40066
202111 | 3251 | 43317
202112 | 8589 | 51906
202201 | 4009 | 55915
202202 | 9034 | 64949
202203 | 8755 | 73704
Indirect Costs | 49994
202104 | 3801 | 3801
202105 | 3664 | 7465
202106 | 5105 | 12570
202107 | 3481 | 16051
202108 | 3468 | 19519
202109 | 4703 | 24222
202110 | 5027 | 29249
202111 | 3976 | 33225
202112 | 3826 | 37051
202201 | 4981 | 42032
202202 | 3217 | 45249
202203 | 4745 | 49994
Indirect Costs 1 | 79263
202104 | 6662 | 6662
202105 | 6286 | 12948
202106 | 7185 | 20133
202107 | 5063 | 25196
202108 | 7132 | 32328
202109 | 6676 | 39004
202110 | 6613 | 45617
202111 | 5982 | 51599
202112 | 7676 | 59275
202201 | 6161 | 65436
202202 | 7898 | 73334
202203 | 5929 | 79263
Product 6 | 81846
Direct Cost 1 | 81846
202104 | 9165 | 9165
202105 | 5076 | 14241
202106 | 2808 | 17049
202107 | 9358 | 26407
202108 | 7173 | 33580
202109 | 4212 | 37792
202110 | 4056 | 41848
202111 | 6976 | 48824
202112 | 9119 | 57943
202201 | 7006 | 64949
202202 | 7793 | 72742
202203 | 9104 | 81846
Product 7 | 63092
Direct Cost 1 | 63092
202104 | 8460 | 8460
202105 | 2758 | 11218
202106 | 4428 | 15646
202107 | 3933 | 19579
202108 | 5784 | 25363
202109 | 2881 | 28244
202110 | 5145 | 33389
202111 | 8767 | 42156
202112 | 6491 | 48647
202201 | 3142 | 51789
202202 | 3513 | 55302
202203 | 7790 | 63092
Eindtotaal | 1193990