Spreadsheet: 735929d1623261886-how-to-sumif-a-box-example-sum-box-1-
Sheet: Sheet1

 |  |  |  |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-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-12-01 00:00:00 | Total
 |  | Client
 |  | 1 |  |  | 6538.117130790426 | 5557.453033585629 | 3452.042833659065 | 9904.27573132427 | 717.1255847426494 | 7065.449321365162 | 7158.136939883465 | 4325.699526702621 | 4646.5643059937 | 8264.774821573756 | 7552.44144466612 | 4029.734407280423
 |  | 1 |  |  | 9362.117022129805 | 4288.453329828695 | 2267.023892514222 | 2493.809512373201 | 6955.351841898204 | 8456.26841891613 | 5616.516073448587 | 2777.653790180019 | 5767.880450334637 | 5116.607094107828 | 1538.693622033511 | 2417.578690034521
 |  | 1 |  |  | 515.4518762048222 | 9662.888987370325 | 8502.505026611298 | 1069.735771407579 | 2093.601579722617 | 7283.985235457436 | 5531.28495127887 | 3762.656001001612 | 7507.336402971292 | 7972.251662204254 | 1135.056498420378 | 5497.229934921744
 |  | 1 |  |  | 1593.167945461754 | 3724.719138148268 | 8744.054033740476 | 8108.536986897647 | 8621.412127331867 | 2552.212340516467 | 4758.673571965886 | 6425.209209316012 | 4.446387955190367 | 8892.250804856356 | 576.5420705759105 | 5983.107044159275
 |  | 1 |  |  | 2438.105402455327 | 6182.008230440708 | 7560.346917905438 | 773.3682977505719 | 2613.056744496721 | 6896.494836677181 | 1010.051504199337 | 1978.815291591477 | 5027.187948856184 | 8272.46077127017 | 3196.162283890794 | 3240.979846581303
 |  | 1 |  |  | 8259.436583959978 | 7438.586362509013 | 7226.896323513081 | 7730.754298301748 | 1684.721292486271 | 2296.728190186241 | 4317.398199904128 | 8001.481572210534 | 1817.970581095758 | 2930.233467775834 | 594.8945457062349 | 5169.698309074812
 |  | 1 |  |  | 6993.272661487256 | 4517.910865258519 | 3273.807664181772 | 2970.157299917817 | 9482.897760166206 | 6972.842047690731 | 6913.502636424801 | 2539.040320729304 | 9117.538453952047 | 3877.547672903624 | 6677.616249574133 | 4880.917584627518
 |  | 1 |  |  | 6868.594203496265 | 1148.953954488312 | 8767.056657936026 | 2813.547454357231 | 9359.76217349705 | 8825.849704364096 | 5061.922812293195 | 1603.358890183626 | 5821.329544717738 | 5725.725019057384 | 9922.186865638985 | 9266.139546990058
 |  | 1 |  |  | 9825.188717797588 | 7352.348471520881 | 5711.963090045508 | 8386.25644757361 | 5589.512588059631 | 538.9835669180554 | 3902.83639666042 | 6079.401805721779 | 2671.488401216848 | 6178.432611956253 | 3525.84416747026 | 3779.886405932265
 |  | 1 |  |  | 1125.173003893071 | 4407.870895379303 | 276.9338651624453 | 2858.033962340773 | 7775.388581627688 | 2378.73795562646 | 6006.656979273448 | 3605.199420370616 | 5774.281883597098 | 4036.915536268368 | 7252.158321903081 | 2958.372070906652
 |  | 1 |  |  | 389.5690748575686 | 3634.86509391938 | 8152.494559912398 | 9471.217575817267 | 6416.757861306429 | 5021.975395307221 | 9910.918766043094 | 63.60799849009835 | 9296.497190003867 | 6454.808395246912 | 5410.115307350734 | 905.8497182759884
 |  | 1 |  |  | 3747.340776960413 | 2968.246853668216 | 4253.093374959192 | 892.967456809598 | 2047.940613262355 | 2657.069802575625 | 9807.228143431934 | 6998.538265351687 | 4419.819456289397 | 5058.838724190728 | 6801.652432652626 | 8635.42603304708
 |  | 2 |  |  | 3035.068586133504 | 6370.473990916228 | 5801.037564168409 | 3847.082938369878 | 4016.40984588016 | 4121.922377862066 | 4260.302970206245 | 2543.327575901663 | 4536.621445641962 | 8131.97675898389 | 9802.327993270183 | 3695.877393307607
 |  | 2 |  |  | 5640.928359872472 | 9446.672581925399 | 7635.09776026646 | 6633.123790695896 | 9167.509364617012 | 5942.68818643584 | 6840.035932677009 | 8859.037332821286 | 3749.530979080526 | 6790.316191487563 | 923.4752493149234 | 9642.321173580542
 |  | 2 |  |  | 3851.786884328282 | 3357.932948475589 | 3397.283565943003 | 3633.376384651432 | 2530.455761962727 | 3078.438017491271 | 6478.500736631478 | 2690.712016553742 | 8056.65769808679 | 4910.714583886053 | 5749.695601803727 | 4069.573152294945
 |  | 2 |  |  | 6539.3201618064 | 9323.548821599825 | 6850.597577382175 | 9856.564199402825 | 2053.767568976971 | 3186.45804662027 | 1182.29663369232 | 9458.801754082879 | 3473.630205902062 | 2529.001222612982 | 8971.291877202078 | 6594.534334197268
 |  | 2 |  |  | 4325.475880102773 | 1344.979457900259 | 8927.39165091359 | 4432.177596277735 | 6407.856702301367 | 8092.745082915631 | 8390.07891650338 | 1634.674110328471 | 9915.611891671007 | 8343.708628695193 | 4753.735865097534 | 5022.996387856628
 |  | 2 |  |  | 6029.381733571675 | 6915.921766212995 | 9342.399532042906 | 5755.333785012789 | 8899.780915293739 | 201.6744758756628 | 5314.643186343336 | 1003.687447581509 | 938.3567993445963 | 4059.847761106993 | 8930.24384853823 | 9561.263038762054
 |  | 2 |  |  | 4903.125634905672 | 3861.885814034536 | 4768.875137430829 | 5121.335403909254 | 3922.464948312826 | 798.3562674474065 | 6245.525833760017 | 7768.192954996372 | 3633.342172018704 | 5159.696048970509 | 4669.548404093786 | 9136.88704235636
 |  | 2 |  |  | 6533.257025085406 | 519.5703127116847 | 155.9865648518033 | 8885.591995601086 | 7462.126972376247 | 9761.366347080539 | 6349.391366718216 | 7.059130015126813 | 4913.237612138476 | 3929.492162255852 | 1016.621963362023 | 966.3852943974805
 |  | 2 |  |  | 6437.659073618975 | 3230.838612154326 | 2207.8193626944 | 5849.913741645862 | 1732.087101483525 | 7049.253750131536 | 1272.482620468551 | 397.3626373716288 | 3940.682585624389 | 1555.823974740807 | 2752.248696842482 | 7879.131757530845
 |  | 2 |  |  | 1489.134158426787 | 2136.897653962371 | 8227.395989165292 | 997.0373212963324 | 2085.712718009926 | 5429.066666940149 | 311.5419908019945 | 6022.599863682766 | 565.7379942304697 | 7643.663344912387 | 303.6394651381025 | 4478.806835350579
 |  | 2 |  |  | 1.780270009243967 | 6439.865293254249 | 9899.46758729912 | 9142.387945277631 | 4601.99452246189 | 2131.090833308729 | 2258.984913032992 | 1697.956920258914 | 8493.274224315466 | 5486.646136371092 | 2880.94812904915 | 3096.260522911507
 |  | 3 |  |  | 3577.306603297713 | 1908.794000879789 | 3081.910144590332 | 291.6256347550361 | 235.3737052549776 | 2393.502399440407 | 7104.095178203438 | 8370.764516570576 | 3063.437098987732 | 7019.525827771789 | 6476.110771988216 | 6962.530916850575
 |  | 3 |  |  | 6970.49938602682 | 1436.101512689713 | 6194.178664226634 | 5638.517441667484 | 4002.428294914423 | 1412.857857619915 | 8168.688826359146 | 4389.513521907526 | 6777.516945168773 | 3969.421930254232 | 8561.367047766691 | 4704.458654942468
 |  | 3 |  |  | 5894.885092608455 | 5481.873214873387 | 4671.647285894986 | 1116.958483875583 | 559.2703736170346 | 7370.069336129224 | 2538.907255956591 | 6972.05848226358 | 1085.288304063122 | 4258.718248314856 | 1322.087614503078 | 709.7758533305876
 |  | 3 |  |  | 5242.425086765505 | 6699.954104360349 | 2438.815135048842 | 1090.710073054895 | 8026.188260642927 | 3618.268783959129 | 7930.72651757703 | 4096.448861096478 | 3131.993627305943 | 9125.951527202016 | 7224.885834324909 | 9718.82034010754
 |  | 3 |  |  | 4115.730905581867 | 6974.099274948524 | 7280.730835353016 | 1368.422407925458 | 4318.726377189544 | 4521.481008155423 | 5729.832433264791 | 4674.692858183896 | 6326.743126308553 | 5687.761838047959 | 96.17550516674123 | 5465.42310388639
 |  | 3 |  |  | 3579.783837399804 | 8277.621006890564 | 3260.761893039768 | 879.532025000469 | 8880.984947844358 | 7093.875111505349 | 8687.982105171874 | 1306.271592255735 | 1080.767298058 | 5223.824029939135 | 4866.422328790475 | 1852.816595826891
 |  | 4 |  |  | 46.9918763186672 | 6236.601555338699 | 8549.204019606252 | 7656.886107919667 | 2135.593381307533 | 1426.776568642322 | 9024.892229874204 | 4712.962736195654 | 8059.817417719722 | 3108.956086589551 | 9099.150631215394 | 7815.732646774294
 |  | 4 |  |  | 6189.906298945695 | 1172.980288154062 | 7219.930697103833 | 5792.309081699743 | 191.125058229914 | 6159.262832206566 | 4071.971356302174 | 945.6000099765216 | 156.1817710984426 | 1146.545136181627 | 2296.841882931497 | 3565.854504833995
 |  | 4 |  |  | 5973.86420975544 | 6601.067056862204 | 4764.170487029258 | 1860.213203302963 | 1106.685681021782 | 2987.267394401563 | 8399.846378214204 | 5056.269402296448 | 5009.438841986742 | 668.0300029043174 | 2589.087133803778 | 7643.677810178857
 |  | 4 |  |  | 1358.00067546418 | 651.2696798202621 | 8463.47963978671 | 4164.12920663673 | 6858.822899729043 | 5972.055111015786 | 5494.610494606135 | 6053.648865752547 | 6895.60482714824 | 9712.368456758928 | 5382.04293072332 | 1271.277777002484
 |  | 4 |  |  | 4281.144183790535 | 5281.737615853216 | 6790.071575454398 | 1211.58862517739 | 2047.928376095601 | 7571.676515726783 | 8205.718753546713 | 6853.778722653964 | 7586.564560549984 | 3430.127188700131 | 1228.494925022521 | 6654.875710646403
 |  | 4 |  |  | 1895.559898251164 | 2527.182813094033 | 2327.079214510515 | 1939.799738092103 | 7836.460680661069 | 3562.247012317298 | 7807.321769779181 | 6038.031733774483 | 6639.090619450235 | 7759.421051856412 | 2997.226559627713 | 1968.944684101305
 |  | 5 |  |  | 656.8946959221156 | 5335.086582318332 | 8646.8750003162 | 4687.858219732863 | 8529.270123823253 | 3383.603370084217 | 8403.681115677588 | 2878.783435216148 | 7113.439480794216 | 5065.971284694425 | 935.5923726931903 | 7621.816727735297
 |  | 5 |  |  | 360.0589676729993 | 4562.964671969771 | 7738.298657857044 | 2310.77799577888 | 3387.633940835516 | 1983.057375863551 | 4130.380476320822 | 4095.883340722063 | 7483.52596366034 | 7751.258296933114 | 6795.770747746733 | 7977.411014331353
 |  | 5 |  |  | 7941.790892417132 | 842.211989207493 | 1538.185041990874 | 6284.359644571208 | 6998.520139668981 | 493.8413880491788 | 4531.87542046666 | 2146.856180075076 | 2695.389013974507 | 1085.997107125453 | 9901.782101771172 | 7101.36309339257
 | Client# | Month | Total
 |  | 2021-01-01 00:00:00
 |  | 2021-03-01 00:00:00