Spreadsheet: 762759d1641802249-summing-the-mutiple-ranges-where-the-same-header-are-there-tried-sumifs-index-xlookup-testing
Sheet: ABC

Nos | Type | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-11-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-03-01 00:00:00 | 2022-03-01 00:00:00
6 | A | 108493.1506849315 | 43397.26027397261 | 68712.32876712328 | 108493.1506849315 | 65095.89041095891 | 47013.69863013698 | 112109.5890410959 | 108493.1506849315 | 112109.5890410959 | 61479.45205479452 | 28931.50684931507 | 19503.00619253143 | 120918.6383936949 | 120918.6383936949 | 7801.202477012572 | 101415.6322011634 | 42906.61362356914 | 15602.40495402514 | 62409.61981610057
6 | B | 7885.522109589039 | 3154.208843835616 | 4994.164002739725 | 7885.522109589039 | 4731.313265753424 | 3417.059580821917 | 8148.372846575342 | 7885.522109589039 | 8148.372846575342 | 4468.462528767123 | 2102.805895890411 | 1417.521618311878 | 8788.634033533644 | 8788.634033533644 | 567.0086473247512 | 7371.112415221766 | 3118.547560286132 | 1134.017294649502 | 4536.06917859801 |  | 98542.87092118534
7 | A | 246575.3424657534 | 98630.13698630137 | 156164.3835616438 | 246575.3424657534 | 147945.2054794521 | 106849.3150684931 | 254794.5205479452 | 246575.3424657534 | 254794.5205479452 | 139726.0273972603 | 65753.42465753424 | 41095.89041095891 | 254794.5205479452 | 254794.5205479452 | 16438.35616438356 | 235337.8119722274 | 99565.99737286546 | 36205.81722649653 | 144823.2689059861
7 | B | 23095.66522799775 | 9238.2660911991 | 14627.25464439858 | 23095.66522799775 | 13857.39913679865 | 10008.12159879903 | 23865.52073559768 | 23095.66522799775 | 23865.52073559768 | 13087.54362919873 | 6158.844060799401 | 3849.277537999625 | 23865.52073559768 | 23865.52073559768 | 1539.71101519985 | 22043.09346768907 | 9325.924159406917 | 3391.245148875242 | 13564.98059550097 |  | 285440.7397122491
7 | C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4079.403661228172 | 1725.90154898115 | 627.6005632658727 | 2510.402253063491
8 | A | 320547.9452054795 | 128219.1780821918 | 203013.698630137 | 320547.9452054795 | 192328.7671232877 | 138904.1095890411 | 331232.8767123288 | 320547.9452054795 | 331232.8767123288 | 181643.8356164384 | 85479.45205479451 | 53424.65753424657 | 331232.8767123288 | 331232.8767123288 | 21369.86301369863 | 277808.2191780822 | 117534.2465753425 | 47587.46481516232 | 190349.8592606493
8 | B | 33631.1901369863 | 13452.47605479452 | 21299.75375342465 | 33631.1901369863 | 20178.71408219178 | 14573.5157260274 | 34752.22980821918 | 33631.1901369863 | 34752.22980821918 | 19057.67441095891 | 8968.317369863013 | 5605.198356164383 | 34752.22980821918 | 34752.22980821918 | 2242.079342465753 | 29147.03145205479 | 12331.43638356164 | 4992.77284809908 | 19971.09139239632 |  | 411722.5508158378
8 | C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 289.4360547945205 | 1157.744219178082
9 | A | 98630.13698630137 | 39452.05479452055 | 63328.29423906925 | 99992.04353537249 | 59995.2261212235 | 43329.88553199475 | 103325.1116532182 | 99992.04353537249 | 103325.1116532182 | 56662.15800337775 | 26664.544942766 | 16665.34058922875 | 103325.1116532182 | 103325.1116532182 | 6666.1362356915 | 86659.77106398951 | 36663.74929630325 | 13332.272471383 | 53329.089885532
9 | C |  |  | 6135.848376806153 | 9688.181647588663 | 5812.908988553198 | 4198.212047288421 | 10011.12103584162 | 9688.181647588663 | 10011.12103584162 | 5489.969600300243 | 2583.515106023644 | 1614.696941264777 | 10011.12103584162 | 10011.12103584162 | 645.8787765059109 | 8396.424094576842 | 3552.33327078251 | 1291.757553011822 | 5167.030212047287 |  | 104309.4224057046
10 | A | 98630.13698630137 | 39452.05479452055 | 62465.75342465754 | 98630.13698630137 | 59178.08219178082 | 42739.72602739726 | 101917.8082191781 | 98630.13698630137 | 101917.8082191781 | 55890.41095890411 | 26301.3698630137 | 16438.35616438356 | 101917.8082191781 | 101917.8082191781 | 6575.342465753424 | 85479.45205479451 | 36164.38356164384 | 13150.68493150685 | 58638.36367048226
10 | C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 255.9519609682867 |  | 255.9519609682867
11 | A |  |  |  |  |  | 59835.61643835616 | 142684.9315068493 | 138082.1917808219 | 142684.9315068493 | 78246.57534246576 | 36821.91780821918 | 23013.69863013699 | 142684.9315068493 | 142684.9315068493 | 9205.479452054795 | 119671.2328767123 | 50630.13698630137 | 18410.95890410959 | 73643.83561643836
11 | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
12 | A |  |  |  |  |  |  |  |  |  |  | 131506.8493150685 | 82191.78082191781 | 509589.0410958904 | 509589.0410958904 | 32876.71232876712 | 427397.2602739726 | 180821.9178082192 | 65753.42465753424 | 263013.698630137
12 | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0