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

Contract No | Customer Order No | Weekly Value | Weekly Value Combined | Rate Id
3006-000132 | HASSAN AHMED | 106.89
3006-000402 | HASSAN AHMED | 40.992
3006-000566 | HASSAN AHMED | 50.988
3006-000942 | HDE001509 | 2410.8
3006-001252 | HDE001805 | 5283.599999999999
3006-001383 | HDE001910 | 1875.594
3006-001383 | HDE001910 | 523.7819999999999
3001-000206 | LPO# TBC | 191.5384615384615 | Sheet4 has Pivot Table.
3001-000176 | LPO# TBC | 0
3001-000222 | LPO# TBC | 0
3001-000234 | LPO# TBC | 92.3076923076923
3003-000036 | LPO# TBC | 476.4295384615384
3001-000390 | LPO# TBC | 437.0769230769231
3001-000390 | LPO# TBC | 437.0769230769231
3001-000390 | LPO# TBC | 437.0769230769231
3001-000390 | LPO# TBC | 437.0769230769231
3001-000390 | LPO# TBC | 437.0769230769231
3001-000390 | LPO# TBC | 437.0769230769231
3003-000042 | LPO# TBC | 1171.222615384615
3003-000042 | LPO# TBC | 1171.222615384615
3003-000042 | LPO# TBC | 1171.222615384615
3003-000044 | LPO# TBC | 1698.383076923077
3003-000048 | LPO# TBC | 1654.269230769231
3003-000048 | LPO# TBC | 1654.269230769231
3003-000041 | LPO# TBC | 3440.88
3003-000041 | LPO# TBC | 3440.88
3003-000080 | LPO# TBC | 3440.88
3003-000081 | LPO# TBC | 3440.88
3003-000052 | LPO# TBC | 2752.704
3003-000171 | LPO# TBC | 529.3661538461539
3003-000171 | LPO# TBC | 529.3661538461539
3003-000171 | LPO# TBC | 529.3661538461539
3003-000092 | LPO# TBC | 3440.88
3003-000151 | LPO# TBC | 1268.273076923077
3003-000154 | LPO# TBC | 3440.88
3003-000212 | LPO# TBC | 191.16
3003-000179 | LPO# TBC | 679.3532307692308
3002-002517 | LPO# TBC | 263.0769230769231
3003-000193 | LPO# TBC | 1268.273076923077
3003-000483 | LPO# TBC | 771.9923076923078
3001-000742 | LPO# TBC | 57.69230769230769
3003-000200 | LPO# TBC | 1323.415384615385
3003-000211 | LPO# TBC | 191.16
3003-000211 | LPO# TBC | 191.16
3003-000211 | LPO# TBC | 0
3003-000211 | LPO# TBC | 0
3003-000211 | LPO# TBC | 0
3003-000211 | LPO# TBC | 0
3003-000211 | LPO# TBC | 0
3003-000211 | LPO# TBC | 0
3003-000211 | LPO# TBC | 0
3003-000211 | LPO# TBC | 0
3003-000211 | LPO# TBC | 0
3003-000211 | LPO# TBC | 0
3003-000213 | LPO# TBC | 679.3532307692308
3003-000213 | LPO# TBC | 679.3532307692308
3024-000001 | LPO# TBC | 2082.4384
3024-000003 | LPO# TBC | 460.0736
3024-000004 | LPO# TBC | 460.0736
3024-000025 | LPO# TBC | 772.8000000000001
3024-000026 | LPO# TBC | 726.432
3003-000226 | LPO# TBC | 1885.866923076923
3003-000233 | LPO# TBC | 2977.684615384615
3003-000228 | LPO# TBC | 679.3532307692308
3003-000229 | LPO# TBC | 1885.866923076923
3003-000232 | LPO# TBC | 1157.988461538461
3003-000243 | LPO# TBC | 606.5653846153846
3003-000243 | LPO# TBC | 606.5653846153846
3003-000247 | LPO# TBC | 606.5653846153846
3003-000247 | LPO# TBC | 606.5653846153846
3003-000246 | LPO# TBC | 606.5653846153846
3024-000051 | LPO# TBC | 0
3024-000052 | LPO# TBC | 0
3024-000053 | LPO# TBC | 0
3003-000253 | LPO# TBC | 2205.692307692308
3003-000258 | LPO# TBC | 1672.65
3003-000332 | LPO# TBC | 529.3661538461539
3003-000291 | LPO# TBC | 661.7076923076924
3003-000291 | LPO# TBC | 0
3003-000295 | LPO# TBC | 3727.62
3003-000305 | LPO# TBC | 679.3532307692308
3003-000306 | LPO# TBC | 738.906923076923
3003-000314 | LPO# TBC | 771.9923076923078
3003-000331 | LPO# TBC | 716.8499999999999
3003-000326 | LPO# TBC | 551.4230769230769
3003-000285 | LPO# TBC | 1080.789230769231
3003-000325 | LPO# TBC | 6617.076923076923
3003-000325 | LPO# TBC | 882.2769230769229
3003-000327 | LPO# TBC | 1146.96
3003-000346 | LPO# TBC | 394.8189230769231
3001-001117 | LPO# TBC | 761.5384615384615
3001-001117 | LPO# TBC | 99.23076923076923
3001-001117 | LPO# TBC | 103.8461538461538
3003-000355 | LPO# TBC | 5514.23076923077
3003-000426 | LPO# TBC | 0
3003-000364 | LPO# TBC | 1543.984615384616
3024-000082 | LPO# TBC | 4963.951999999999
3024-000082 | LPO# TBC | 0
3024-000083 | LPO# TBC | 4963.951999999999
3024-000083 | LPO# TBC | 0
3003-000368 | LPO# TBC | 3087.969230769231
3003-000374 | LPO# TBC | 5514.23076923077
3003-000372 | LPO# TBC | 551.4230769230769
3003-000372 | LPO# TBC | 551.4230769230769
3003-000372 | LPO# TBC | 551.4230769230769
3003-000375 | LPO# TBC | 551.4230769230769
3003-000375 | LPO# TBC | 551.4230769230769
3003-000375 | LPO# TBC | 551.4230769230769
3003-000373 | LPO# TBC | 6617.076923076923
3003-000381 | LPO# TBC | 551.4230769230769
3003-000381 | LPO# TBC | 551.4230769230769
3003-000377 | LPO# TBC | 191.16
3003-000377 | LPO# TBC | 191.16
3003-000377 | LPO# TBC | 191.16
3003-000377 | LPO# TBC | 191.16
3003-000377 | LPO# TBC | 191.16
3003-000379 | LPO# TBC | 1080.789230769231
3003-000382 | LPO# TBC | 1235.187692307692
3003-000382 | LPO# TBC | 1235.187692307692
3024-000086 | LPO# TBC | 18741.9456
3003-000389 | LPO# TBC | 1654.269230769231
3003-000410 | LPO# TBC | 551.4230769230769
3003-000410 | LPO# TBC | 551.4230769230769
3003-000410 | LPO# TBC | 551.4230769230769
3003-000411 | LPO# TBC | 738.906923076923
3003-000414 | LPO# TBC | 679.3532307692308
3003-000375 | LPO# TBC | 551.4230769230769
3003-000415 | LPO# TBC | 771.9923076923078
3003-000414 | LPO# TBC | 679.3532307692308
3001-001196 | LPO# TBC | 448.8461538461539
3001-001196 | LPO# TBC | 0
3001-001196 | LPO# TBC | 448.8461538461539
3001-001196 | LPO# TBC | 0
3001-001196 | LPO# TBC | 448.8461538461539
3001-001196 | LPO# TBC | 0
3001-001196 | LPO# TBC | 448.8461538461539
3001-001196 | LPO# TBC | 0
3003-000385 | LPO# TBC | 661.7076923076924
3001-001211 | LPO# TBC | 692.3076923076923
3001-001211 | LPO# TBC | 692.3076923076923
3003-000439 | LPO# TBC | 2150.55
3003-000360 | LPO# TBC | 1378.557692307692
3003-000419 | LPO# TBC | 1543.984615384616
3024-000093 | LPO# TBC | 3864
3024-000093 | LPO# TBC | 3864
3003-000420 | LPO# TBC | 1543.984615384616
3003-000421 | LPO# TBC | 661.7076923076924
3003-000423 | LPO# TBC | 1378.557692307692
3003-000385 | LPO# TBC | 661.7076923076924
3003-000385 | LPO# TBC | 661.7076923076924
3003-000434 | LPO# TBC | 661.7076923076924
3003-000434 | LPO# TBC | 661.7076923076924
3003-000433 | LPO# TBC | 2977.684615384615
3003-000438 | LPO# TBC | 551.4230769230769
3003-000438 | LPO# TBC | 551.4230769230769
3003-000438 | LPO# TBC | 551.4230769230769
3003-000482 | LPO# TBC | 716.8499999999999
3003-000446 | LPO# TBC | 275.7115384615385
3003-000452 | LPO# TBC | 1378.557692307692
3003-000453 | LPO# TBC | 679.3532307692308
3003-000458 | LPO# TBC | 1543.984615384616
3003-000470 | LPO# TBC | 551.4230769230769
3003-000470 | LPO# TBC | 694.7930769230769
3003-000470 | LPO# TBC | 551.4230769230769
3001-001282 | LPO# TBC | 2376
3001-001282 | LPO# TBC | 594
3001-001312 | LPO# TBC | 0
3001-001312 | LPO# TBC | 0
3001-001312 | LPO# TBC | 0
3001-001312 | LPO# TBC | 0
3001-001312 | LPO# TBC | 0
3001-001312 | LPO# TBC | 0
3001-001312 | LPO# TBC | 0
3001-001312 | LPO# TBC | 0
3001-001312 | LPO# TBC | 0
3001-001312 | LPO# TBC | 0
3001-001312 | LPO# TBC | 0
3001-001312 | LPO# TBC | 0
3001-001312 | LPO# TBC | 0
3001-001312 | LPO# TBC | 0
3001-001312 | LPO# TBC | 0
3001-001312 | LPO# TBC | 0
3001-001312 | LPO# TBC | 0
3001-001312 | LPO# TBC | 0
3003-000473 | LPO# TBC | 661.7076923076924
3001-001314 | LPO# TBC | 1200
3001-001314 | LPO# TBC | 218.0769230769231
3001-001314 | LPO# TBC | 1200
3001-001314 | LPO# TBC | 218.0769230769231
3001-001314 | LPO# TBC | 530.7692307692307
3001-001314 | LPO# TBC | 194.3076923076923
3001-001314 | LPO# TBC | 1243.153846153846
3001-001314 | LPO# TBC | 194.3076923076923
3003-000479 | LPO# TBC | 507.3092307692308
3003-000479 | LPO# TBC | 551.4230769230769
3003-000479 | LPO# TBC | 551.4230769230769
3001-001314 | LPO# TBC | 1200
3001-001314 | LPO# TBC | 218.0769230769231
3001-001314 | LPO# TBC | 530.7692307692307
3001-001314 | LPO# TBC | 194.3076923076923
3001-001314 | LPO# TBC | 761.5384615384615
3001-001314 | LPO# TBC | 194.3076923076923
3001-001325 | LPO# TBC | 1200
3001-001325 | LPO# TBC | 1200
3001-001325 | LPO# TBC | 0
3001-001325 | LPO# TBC | 218.0769230769231
3001-001325 | LPO# TBC | 218.0769230769231
3001-001314 | LPO# TBC | 1243.153846153846
3001-001314 | LPO# TBC | 194.3076923076923
3001-001314 | LPO# TBC | 1243.153846153846
3001-001314 | LPO# TBC | 194.3076923076923
3001-001314 | LPO# TBC | 761.5384615384615
3001-001314 | LPO# TBC | 0
3001-001314 | LPO# TBC | 194.3076923076923
3003-000477 | LPO# TBC | 661.7076923076924
3003-000477 | LPO# TBC | 661.7076923076924
3003-000477 | LPO# TBC | 661.7076923076924
3003-000477 | LPO# TBC | 661.7076923076924
3003-000477 | LPO# TBC | 661.7076923076924
3003-000477 | LPO# TBC | 661.7076923076924
3003-000477 | LPO# TBC | 661.7076923076924
3003-000477 | LPO# TBC | 661.7076923076924
3003-000477 | LPO# TBC | 661.7076923076924
3003-000477 | LPO# TBC | 661.7076923076924
3001-001308 | LPO# TBC | 0
3001-001308 | LPO# TBC | 0
3003-000481 | LPO# TBC | 1100.640461538462
3003-000372 | LPO# TBC | 551.4230769230769
3003-000422 | LPO# TBC | 551.4230769230769
3001-001326 | LPO# TBC | 2496.923076923077
3001-001326 | LPO# TBC | 218.0769230769231
3001-001326 | LPO# TBC | 2496.923076923077
3001-001326 | LPO# TBC | 218.0769230769231
3001-001327 | LPO# TBC | 553.8461538461538
3001-001328 | LPO# TBC | 2888
3024-000080 | LPO#: N/A | 0
3024-000081 | LPO#: N/A | 0
3024-000081 | LPO#: N/A | 0
3024-000081 | LPO#: N/A | 0
3024-000081 | LPO#: N/A | 0
3024-000090 | LPO#: N/A | 0
3024-000094 | LPO#: N/A | 0
3024-000094 | LPO#: N/A | 0
3024-000094 | LPO#: N/A | 0
3024-000072 | LPO#: TBC | 0
3024-000072 | LPO#: TBC | 0
3024-000084 | LPO#: TBC | 0
3024-000084 | LPO#: TBC | 0
3024-000084 | LPO#: TBC | 0
3024-000085 | LPO#: TBC | 0
3024-000073 | LPO#: TBC | 726.432
3024-000074 | LPO#: TBC | 726.432
3024-000075 | LPO#: TBC | 726.432
3024-000077 | LPO#: TBC | 726.432
3024-000078 | LPO#: TBC | 726.432
3006-001117 | LPO#: TBC | 3313.8
3006-001118 | LPO#: TBC | 3005.646
3006-001119 | LPO#: TBC | 714.588
3006-001119 | LPO#: TBC | 714.588
3006-001121 | LPO#: TBC | 373.464
3006-001122 | LPO#: TBC | 1316.436923076923
3024-000091 | LPO#: TBC | 460.0736
3024-000096 | LPO#: TBC | 0
3024-000095 | LPO#: TBC | 1719.2224
3016-000007 | LPO#:N/A | 0
3016-000007 | LPO#:N/A | 0
3024-000002 | LPO#:TBC | 460.0736
3024-000005 | LPO#:TBC | 460.0736
3024-000006 | LPO#:TBC | 460.0736
3024-000007 | LPO#:TBC | 460.0736
3024-000008 | LPO#:TBC | 460.0736
3024-000009 | LPO#:TBC | 460.0736
3024-000010 | LPO#:TBC | 460.0736
3024-000011 | LPO#:TBC | 460.0736
3024-000012 | LPO#:TBC | 460.0736
3024-000013 | LPO#:TBC | 460.0736
3024-000014 | LPO#:TBC | 460.0736
3024-000015 | LPO#:TBC | 460.0736
3024-000017 | LPO#:TBC | 460.0736
3024-000022 | LPO#:TBC | 9540.4736
3024-000023 | LPO#:TBC | 9540.4736
3024-000024 | LPO#:TBC | 726.432
3024-000027 | LPO#:TBC | 726.432
3024-000028 | LPO#:TBC | 726.432
3024-000029 | LPO#:TBC | 726.432
3024-000030 | LPO#:TBC | 726.432
3024-000031 | LPO#:TBC | 1767.6512
3024-000032 | LPO#:TBC | 1162.2912
3024-000033 | LPO#:TBC | 460.0736
3024-000034 | LPO#:TBC | 460.0736
3024-000035 | LPO#:TBC | 460.0736
3024-000036 | LPO#:TBC | 460.0736
3024-000037 | LPO#:TBC | 460.0736
3024-000038 | LPO#:TBC | 460.0736
3024-000039 | LPO#:TBC | 460.0736
3024-000040 | LPO#:TBC | 460.0736
3024-000041 | LPO#:TBC | 460.0736
3024-000042 | LPO#:TBC | 460.0736
3024-000043 | LPO#:TBC | 460.0736
3024-000044 | LPO#:TBC | 460.0736
3024-000045 | LPO#:TBC | 460.0736
3024-000046 | LPO#:TBC | 460.0736
3006-000718 | LPO#:TBC | 81.144
3006-000718 | LPO#:TBC | 81.144
3024-000047 | LPO#:TBC | 32205.15200000001
3024-000048 | LPO#:TBC | 22156.176
3024-000050 | LPO#:TBC | 726.432
3024-000054 | LPO#:TBC | 0
3024-000058 | LPO#:TBC | 0
3024-000059 | LPO#:TBC | 0
3024-000060 | LPO#:TBC | 0
3024-000055 | LPO#:TBC | 0
3024-000055 | LPO#:TBC | 0
3024-000055 | LPO#:TBC | 0
3024-000056 | LPO#:TBC | 0
3024-000056 | LPO#:TBC | 0
3024-000056 | LPO#:TBC | 0
3024-000057 | LPO#:TBC | 0
3024-000057 | LPO#:TBC | 0
3024-000049 | LPO#:TBC | 11719.7696
3024-000063 | LPO#:TBC | 0
3024-000064 | LPO#:TBC | 3438.4448
3024-000065 | LPO#:TBC | 3147.872
3024-000066 | LPO#:TBC | 32205.15200000001
3024-000067 | LPO#:TBC | 3438.4448
3024-000068 | LPO#:TBC | 9540.4736
3024-000069 | LPO#:TBC | 3365.8016
3024-000070 | LPO#:TBC | 3147.872
3024-000071 | LPO#:TBC | 11719.7696
3002-000086 | N/A | 807.6923076923077
3002-000225 | N/A | 332.3076923076923
3002-000236 | N/A | 299.5384615384615
3002-000343 | N/A | 1364.538461538461
3002-000173 | NA | 299.5384615384615
3015-000015 | PO#:TBA | 1137.692307692308
3002-001311 | RQ-TBA | 2838.461538461539
3002-002790 | TBA | 3576.923076923077
3024-000092 | TBC | 0
3024-000092 | TBC | 0
3001-001267 | TBC | 1381.153846153846