Spreadsheet: 216533d1361802775-unable-to-calculate-using-sumif-formula-copy-of-example-ans
Sheet: Sheet4

Row Labels | Sum of Weekly Value
3001-000176 | 0
3001-000206 | 191.5384615384615
3001-000222 | 0
3001-000234 | 92.3076923076923
3001-000390 | 2622.461538461538
3001-000742 | 57.69230769230769
3001-001117 | 964.6153846153845
3001-001196 | 1795.384615384615
3001-001211 | 1384.615384615385
3001-001267 | 1381.153846153846
3001-001282 | 2970
3001-001308 | 0
3001-001312 | 0
3001-001314 | 11928.46153846154
3001-001325 | 2836.153846153846
3001-001326 | 5430
3001-001327 | 553.8461538461538
3001-001328 | 2888
3002-000086 | 807.6923076923077
3002-000173 | 299.5384615384615
3002-000225 | 332.3076923076923
3002-000236 | 299.5384615384615
3002-000343 | 1364.538461538461
3002-001311 | 2838.461538461539
3002-002517 | 263.0769230769231
3002-002790 | 3576.923076923077
3003-000036 | 476.4295384615384
3003-000041 | 6881.76
3003-000042 | 3513.667846153846
3003-000044 | 1698.383076923077
3003-000048 | 3308.538461538461
3003-000052 | 2752.704
3003-000080 | 3440.88
3003-000081 | 3440.88
3003-000092 | 3440.88
3003-000151 | 1268.273076923077
3003-000154 | 3440.88
3003-000171 | 1588.098461538462
3003-000179 | 679.3532307692308
3003-000193 | 1268.273076923077
3003-000200 | 1323.415384615385
3003-000211 | 382.32
3003-000212 | 191.16
3003-000213 | 1358.706461538462
3003-000226 | 1885.866923076923
3003-000228 | 679.3532307692308
3003-000229 | 1885.866923076923
3003-000232 | 1157.988461538461
3003-000233 | 2977.684615384615
3003-000243 | 1213.130769230769
3003-000246 | 606.5653846153846
3003-000247 | 1213.130769230769
3003-000253 | 2205.692307692308
3003-000258 | 1672.65
3003-000285 | 1080.789230769231
3003-000291 | 661.7076923076924
3003-000295 | 3727.62
3003-000305 | 679.3532307692308
3003-000306 | 738.906923076923
3003-000314 | 771.9923076923078
3003-000325 | 7499.353846153846
3003-000326 | 551.4230769230769
3003-000327 | 1146.96
3003-000331 | 716.8499999999999
3003-000332 | 529.3661538461539
3003-000346 | 394.8189230769231
3003-000355 | 5514.23076923077
3003-000360 | 1378.557692307692
3003-000364 | 1543.984615384616
3003-000368 | 3087.969230769231
3003-000372 | 2205.692307692308
3003-000373 | 6617.076923076923
3003-000374 | 5514.23076923077
3003-000375 | 2205.692307692308
3003-000377 | 955.8
3003-000379 | 1080.789230769231
3003-000381 | 1102.846153846154
3003-000382 | 2470.375384615385
3003-000385 | 1985.123076923077
3003-000389 | 1654.269230769231
3003-000410 | 1654.269230769231
3003-000411 | 738.906923076923
3003-000414 | 1358.706461538462
3003-000415 | 771.9923076923078
3003-000419 | 1543.984615384616
3003-000420 | 1543.984615384616
3003-000421 | 661.7076923076924
3003-000422 | 551.4230769230769
3003-000423 | 1378.557692307692
3003-000426 | 0
3003-000433 | 2977.684615384615
3003-000434 | 1323.415384615385
3003-000438 | 1654.269230769231
3003-000439 | 2150.55
3003-000446 | 275.7115384615385
3003-000452 | 1378.557692307692
3003-000453 | 679.3532307692308
3003-000458 | 1543.984615384616
3003-000470 | 1797.639230769231
3003-000473 | 661.7076923076924
3003-000477 | 6617.076923076923
3003-000479 | 1610.155384615384
3003-000481 | 1100.640461538462
3003-000482 | 716.8499999999999
3003-000483 | 771.9923076923078
3006-000132 | 106.89
3006-000402 | 40.992
3006-000566 | 50.988
3006-000718 | 162.288
3006-000942 | 2410.8
3006-001117 | 3313.8
3006-001118 | 3005.646
3006-001119 | 1429.176
3006-001121 | 373.464
3006-001122 | 1316.436923076923
3006-001252 | 5283.599999999999
3006-001383 | 2399.376
3015-000015 | 1137.692307692308
3016-000007 | 0
3024-000001 | 2082.4384
3024-000002 | 460.0736
3024-000003 | 460.0736
3024-000004 | 460.0736
3024-000005 | 460.0736
3024-000006 | 460.0736
3024-000007 | 460.0736
3024-000008 | 460.0736
3024-000009 | 460.0736
3024-000010 | 460.0736
3024-000011 | 460.0736
3024-000012 | 460.0736
3024-000013 | 460.0736
3024-000014 | 460.0736
3024-000015 | 460.0736
3024-000017 | 460.0736
3024-000022 | 9540.4736
3024-000023 | 9540.4736
3024-000024 | 726.432
3024-000025 | 772.8000000000001
3024-000026 | 726.432
3024-000027 | 726.432
3024-000028 | 726.432
3024-000029 | 726.432
3024-000030 | 726.432
3024-000031 | 1767.6512
3024-000032 | 1162.2912
3024-000033 | 460.0736
3024-000034 | 460.0736
3024-000035 | 460.0736
3024-000036 | 460.0736
3024-000037 | 460.0736
3024-000038 | 460.0736
3024-000039 | 460.0736
3024-000040 | 460.0736
3024-000041 | 460.0736
3024-000042 | 460.0736
3024-000043 | 460.0736
3024-000044 | 460.0736
3024-000045 | 460.0736
3024-000046 | 460.0736
3024-000047 | 32205.15200000001
3024-000048 | 22156.176
3024-000049 | 11719.7696
3024-000050 | 726.432
3024-000051 | 0
3024-000052 | 0
3024-000053 | 0
3024-000054 | 0
3024-000055 | 0
3024-000056 | 0
3024-000057 | 0
3024-000058 | 0
3024-000059 | 0
3024-000060 | 0
3024-000063 | 0
3024-000064 | 3438.4448
3024-000065 | 3147.872
3024-000066 | 32205.15200000001
3024-000067 | 3438.4448
3024-000068 | 9540.4736
3024-000069 | 3365.8016
3024-000070 | 3147.872
3024-000071 | 11719.7696
3024-000072 | 0
3024-000073 | 726.432
3024-000074 | 726.432
3024-000075 | 726.432
3024-000077 | 726.432
3024-000078 | 726.432
3024-000080 | 0
3024-000081 | 0
3024-000082 | 4963.951999999999
3024-000083 | 4963.951999999999
3024-000084 | 0
3024-000085 | 0
3024-000086 | 18741.9456
3024-000090 | 0
3024-000091 | 460.0736
3024-000092 | 0
3024-000093 | 7728
3024-000094 | 0
3024-000095 | 1719.2224
3024-000096 | 0
Grand Total | 434728.4089230768