Spreadsheet: 830264d1684834850-sumifs-with-offset-or-index-matching-with-offset-and-less-than-values-problem-sum-ifs-offset-multiple-criteria
Sheet: Sheet1

region | 0 to 10 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
Northern Region | 0 | 1.668 | 2.71443 | 0.95733 | 1.024 | 1.63242 | 1.74304 | 2.45572 | 4.706262483957975 | 1.524721552174811 | 0.024 | 2.572562563947164 | 4.217333335918889 | 2.256667593985393 | 2.983454578105664 | 5.699692393694943
Northern Region | 1 | 1.024 | 2.71135 | 0.024 | 1.224 | 0.024 | 1.829 | 0.024 | 1.079238100363537 | 3.095789364344659 | 0.6300606084848486 | 0.024 | 3.581142880120613 | 0.024 | 0.024 | 0.024
Northern Region | 2 | 1.668 | 0.8340000000000001 | 1.024 | 1.224 | 1.758 | 0.88352 | 0.024 | 0.024 | 0.024 | 0.6300606084848486 | 0.024 | 2.217333371520001 | 1.03410101010101 | 3.189454550474463 | 0.024
Northern Region | 3 | 0.024 | 1.024 | 2.074 | 1.06246 | 3.064 | 2.7315 | 0.024 | 2.001647077226298 | 3.322701359609155 | 0.024 | 0.024 | 2.394366313633998 | 0.024 | 0.024 | 0.024
Northern Region | 4 | 1.00257 | 0.024 | 2.724 | 0.024 | 0.024 | 0.024 | 0.024 | 1.889625012767969 | 1.03410101010101 | 2.448242444848485 | 0.024 | 1.93333335883089 | 0.024 | 1.612000030044961 | 3.040666745904447
Northern Region | 5 | 4.05757 | 3.92943 | 7.204 | 9.56246 | 5.62336 | 8.139249999999999 | 11.72757 | 10.31370724687045 | 4.481070950615551 | 3.458343454949495 | 6.087348476923077 | 9.236271172450417 | 6.910164728798111 | 5.571454557715743 | 16.22307735607565
Northern Region | 6 | 3.24484 | 4.25749 | 0.024 | 1.104 | 2.064 | 6.2143 | 0.83812 | 7.193084320558568 | 2.864909098090278 | 5.443765457685303 | 4.126564143589744 | 0.024 | 1.484361201782654 | 2.983454578105664 | 11.06156980500482
Northern Region | 7 | 4.22341 | 5.27232 | 11.354 | 10.18246 | 10.19166 | 13.94368 | 12.04333 | 10.42129000466144 | 11.68453409419995 | 6.402066439167183 | 5.633945645843046 | 3.103809567113724 | 6.367281313200969 | 5.777454564758523 | 8.707076962147218
Northern Region | 8 | 16.26993 | 6.51519 | 16.22066 | 17.97938 | 18.39632 | 12.72561 | 18.45383 | 42.98484295662723 | 23.24514073749175 | 24.58758465676728 | 14.92961737731158 | 19.89945073301497 | 27.1905521193482 | 22.74018197108732 | 50.86240226482941
Northern Region | 9 | 9.203829999999998 | 22.83594 | 11.49733 | 14.40938 | 14.52748 | 25.83018 | 22.68273 | 35.84354148836587 | 11.3746494308522 | 16.73469679107685 | 23.0273366920746 | 14.56786091713158 | 16.84629145707896 | 17.46036374175677 | 36.10305301053123
Northern Region | 10 | 42.85780999999998 | 54.62566999999999 | 26.86065000000001 | 25.36784000000001 | 35.98868 | 39.05972000000002 | 59.38657999999999 | 81.38676395782109 | 47.9154148209119 | 63.1135033516115 | 64.8007269770785 | 64.74909942468456 | 61.42581384536067 | 59.08818282268413 | 101.9744653958411
Scotland Region | 0 | 2.59275 | 1.28481 | 0.774 | 2.65081 | 0.024 | 1.74329 | 2.13604 | 4.195123799446865 | 0.024 | 3.258363860459508 | 0.024 | 2.468038509413019 | 0.5800606142903032 | 0.024 | 2.335932832392411
Scotland Region | 1 | 0.024 | 0.024 | 0.024 | 0.024 | 0.024 | 0.64641 | 0.024 | 1.024 | 0.024 | 0.024 | 0.024 | 0.024 | 0.024 | 1.191647064009256 | 1.175651471080552
Scotland Region | 2 | 0.024 | 1.024 | 1.024 | 1.024 | 0.024 | 0.57938 | 0.52545 | 0.4501538547097043 | 0.529050505050505 | 0.024 | 0.024 | 1.366500042960001 | 2.04420202020202 | 0.024 | 1.058285720058014
Scotland Region | 3 | 0.024 | 0.024 | 0.024 | 1.21081 | 0.024 | 1.024 | 1.0269 | 3.543777591543026 | 0.024 | 0.024 | 0.024 | 0.4451764751964015 | 0.024 | 1.024 | 1.144309485447742
Scotland Region | 4 | 0.024 | 2.74999 | 0.024 | 0.024 | 0.66622 | 0.024 | 2.17404 | 0.024 | 0.529050505050505 | 0.024 | 0.97638095292517 | 0.024 | 0.024 | 1.016500008270833 | 0.024
Scotland Region | 5 | 4.14216 | 4.48504 | 0.624 | 2.0065 | 1.78464 | 6.9851 | 6.069030000000001 | 10.12604460954902 | 4.814764816491446 | 6.926356902356902 | 1.867434351767677 | 8.2593381738187 | 1.114314922919594 | 9.33375495303008 | 8.212850477912973
Scotland Region | 6 | 0.93733 | 0.52246 | 3.874 | 4.81101 | 3.19622 | 3.74028 | 1.84 | 8.956217418403805 | 4.51894954419192 | 2.09011571249687 | 2.996582982106783 | 0.9959457084229103 | 1.72307410252713 | 5.161647097092589 | 5.212880925563769
Scotland Region | 7 | 3.11163 | 3.07505 | 1.024 | 6.560029999999999 | 5.90566 | 4.9902 | 6.7168 | 15.27274011850659 | 5.824865826592457 | 4.406205947445067 | 5.206693156615923 | 6.883076704738444 | 9.146044211086268 | 5.951116809675251 | 8.942577918335337
Scotland Region | 8 | 6.33275 | 12.69831 | 8.10733 | 13.7869 | 13.5387 | 20.37365 | 27.20225 | 27.62576236578335 | 16.77772786219628 | 17.70586924710837 | 17.91271267920049 | 12.37195907341973 | 19.97261384577201 | 14.96542165829397 | 36.62083938067818
Scotland Region | 9 | 12.55484 | 19.71985 | 12.65732 | 10.30905 | 13.1001 | 14.91479 | 12.09076 | 24.35291943474897 | 12.48648205064801 | 19.50160437617683 | 14.25940516583052 | 15.65273483115593 | 15.33903284769054 | 16.85269444436207 | 37.03040006503092
Scotland Region | 10 | 39.51656999999999 | 44.1763 | 36.40732 | 30.95683999999999 | 37.44634000000003 | 47.27262999999999 | 58.03892999999994 | 90.11326274775708 | 36.73131141659948 | 37.18857519362589 | 59.87808409322732 | 51.11323125681824 | 47.98983055044219 | 49.02921866718462 | 108.0262744594115
Southern Region | 0 | 4.76471 | 6.04265 | 9.599 | 7.16971 | 9.44997 | 5.6952 | 5.57271 | 11.42709115590893 | 2.794562782354154 | 3.055509562176792 | 9.478412618828521 | 8.257695422458385 | 5.280034375303966 | 7.401704611128446 | 9.320079146608713
Southern Region | 1 | 0.024 | 4.56195 | 4.787640000000001 | 0.40971 | 0.8497100000000001 | 0.024 | 3.64883 | 3.675438853862573 | 0.024 | 0.024 | 1.842181836363637 | 1.217333339874568 | 6.265724612970604 | 1.016500008270833 | 0.8593846202684023
Southern Region | 2 | 6.28687 | 2.68964 | 2.78764 | 0.40971 | 1.66252 | 5.14691 | 2.29635 | 2.224734822475511 | 1.577465694019866 | 3.237453221522068 | 0.3748771944598339 | 3.27657684248648 | 0.024 | 4.849561735398157 | 2.4720000205616
Southern Region | 3 | 7.38358 | 2.024 | 0.549 | 4.219 | 4.326849999999999 | 4.76691 | 0.024 | 2.024 | 0.7743607621521338 | 2.04420202020202 | 3.919202038952021 | 3.096631586692466 | 0.9507676819807451 | 0.024 | 2.060250001272656
Southern Region | 4 | 0.024 | 1.46582 | 1.024 | 0.024 | 15.93099 | 1.544 | 4.61627 | 3.372427113056103 | 0.024 | 2.827959337316183 | 2.802522076354012 | 0.4810212772958624 | 8.749310474162995 | 2.030117032286352 | 6.343634642102659
Southern Region | 5 | 7.7119 | 17.34572 | 18.174 | 15.33041999999999 | 6.13828 | 10.58153 | 11.39377 | 13.48695008288983 | 9.391668674317726 | 17.66433121807188 | 7.380166979748189 | 6.144763994369563 | 15.13633247739617 | 16.11271488146249 | 29.47900672148615
Southern Region | 6 | 8.901349999999999 | 10.20824 | 9.30764 | 5.475420000000001 | 6.32866 | 10.48153 | 15.18011 | 13.56643237766302 | 0.5673646839188556 | 6.786319829033521 | 6.107572594253002 | 9.012951130429927 | 6.935842576517316 | 6.590513881992302 | 17.42179365784457
Southern Region | 7 | 11.71825 | 10.38871 | 25.17627999999999 | 14.30258 | 11.71797 | 30.38194 | 26.94006 | 29.22887548248944 | 21.23098835942134 | 19.87878298335783 | 16.42093660357316 | 9.144826219734306 | 25.35496576943142 | 16.55988513489058 | 41.60942680871003
Southern Region | 8 | 31.24862000000001 | 36.55854 | 28.39628 | 43.84252000000001 | 48.8882 | 40.65605000000001 | 47.78647000000001 | 71.57809135538727 | 31.54515340719743 | 34.34185621705689 | 55.77812053056227 | 58.71572255637728 | 51.06135082490037 | 56.99187829445567 | 85.11693303718326
Southern Region | 9 | 25.42523000000001 | 28.85923 | 25.25492 | 11.98826 | 16.08553000000001 | 19.23469 | 32.12007 | 68.26276137517226 | 48.71114207262001 | 27.76389308780616 | 30.20483483274095 | 33.21899328408132 | 25.35153934035627 | 32.03612239941938 | 84.39600310769849
Southern Region | 10 | 69.77559000000002 | 72.11976999999997 | 55.20763999999998 | 51.09252000000001 | 51.38536 | 75.25151 | 65.68511000000001 | 128.4172007297367 | 72.51218385656493 | 79.60939130424119 | 100.298608588476 | 88.69748541368364 | 80.91170879982774 | 87.15100473867113 | 147.1854965888821
Grand Total |  | 327.7920900000001 | 386.7919 | 324.79198 | 310.7917800000001 | 341.79184 | 419.1818 | 460.79183 | 730.7920079383106 | 382.0041252377783 | 411.9031138335297 | 459.0748311527533 | 446.7920029178468 | 447.5899833174337 | 456.7920048146273 | 869.7920150225589
 |  | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
offset value |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 3 | 3 | 3 | 3 | 3 | 3
Northern Region |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sumifs attempted solution
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sum(if attempted solution
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | offset index match attempted solution
correct values/range required