Spreadsheet: 122736d1317120943-excel-formula-to-denotes-the-sum-of-positives-and-negatives-values-separately-book1-1-
Sheet: MI20

 | SLoc | Part Code | Difference amt. |  | SLoc | Sum of (+)or positives values | Sum of (-)or negatives values
 | M013 | 32100-KST-9500 | -2683.25 |  | M013
 | M003 | 33100-KTC-9010 | 711.39 |  | M003
 | M003 | 33100-KWA-9300 | -4906.46 |  | EA01
 | M003 | 37100-KCC-8300 | 5569.74 |  | AL01
 | M003 | 37100-KST-8600 | 2079.6 |  | GR01
 | M003 | 50500-KWH-7600 | -2122.19 |  | ST01
 | M003 | 5210A-KST-9400 | -971.82 |  | EX01
 | M003 | 5210A-KTC-9000 | -110540.4 |  | PR01
 | M003 | 5310A-KST-A300 | -317.5 |  | [NAME]
 | M003 | 13381-GF6-3000 | -2112.95 |  | FA01
 | EA01 | 13381-KCC-9000 | -33451.2 |  | DC02
 | EA01 | 28120-KTR-A00A | -10801.46
 | EA01 | 31100-KCC-9000 | -22044.06
 | EA01 | 31200-KTC-9210 | -49040.19
 | EA01 | 91001-GF6-0000 | -11063.8
 | EA01 | 91007-GB6-9100 | -20462.03
 | EA01 | 91008-GB6-9100 | -11129.2
 | EA01 | 9110A-GF6-0000 | -13725.32
 | EA01 | 11100-KWH-AA60 | -24120.99
 | AL01 | 12201-KTC-AA00 | -77475.35
 | AL01 | 12201-KTR-AA00 | -41418.93
 | AL01 | 141011989000080 | -43206.46
 | GR01 | 23111KST9200060 | -10562
 | GR01 | 12101-KWH-D960 | -53057.53
 | ST01 | 35200-KST-8700 | -61925.68
 | EX01 | 35200-KVH-8700 | -702.26
 | EX01 | 5010011987700050 | -10568.22
 | PR01 | 5010021987400050 | -14280.78
 | PR01 | 17510KST940A010 | -14733.46
 | PR01 | 17510KST940B010 | -1893874.94
 | PR01 | 5010A-KCC-7300 | -751960.41
 | [NAME] | 5010A-KCC-8300 | -579.56
 | [NAME] | 5010A-KTC-9000 | -288.98
 | [NAME] | 5010B-198-D000 | -536.13
 | [NAME] | 5010B-KVH-7600 | -399.28
 | [NAME] | 5010C-KST-A200 | -2386.44
 | [NAME] | 5010C-KVH-7600 | -1444.38
 | [NAME] | 5010C-KWH-9600 | -630.96
 | [NAME] | 5010D-KST-9400 | -1286.58
 | [NAME] | 5010D-KWH-9600 | -151.75
 | [NAME] | 5010E-KWH-9600 | -1068.06
 | [NAME] | 16100-KTC-A200 | -1072.26
 | FA01 | 17200-KTC-9200 | -3533.88
 | FA01 | 17200-KTR-A000 | -1446.65
 | FA01 | 17200-KVH-7600 | -12891.4
 | FA01 | 1720A-KCC-9400 | 0
 | FA01 | 1720A-KST-8700 | -212.19
 | FA01 | 1720A-KVH-8700 | -1962
 | FA01 | 18300-KTC-A200 | -756.81
 | FA01 | 1860A-KWA-9300 | 4684.05
 | FA01 | 2830A-KTC-9000 | -2168.06
 | FA01 | 2830A-KWH-7600 | -4716.55
 | FA01 | 31500-KVT-9410 | -9461.02
 | FA01 | 31500-KWS-8010 | -48610.28
 | FA01 | 32100-KST-A200 | -4924.42
 | FA01 | 32100-KST-A300 | -36702.92
 | FA01 | 32100-KWA-8400 | -11783.29
 | FA01 | 32100-KWH-9600 | -14254.67
 | FA01 | 32100-KWH-9700 | -42419.54
 | FA01 | 33100-KST-9510 | -43376.11
 | FA01 | 35010-KST-9400 | -1315.62
 | FA01 | 35010-KWH-9000 | -18532.15
 | FA01 | 37100-KST-A200 | -125663.85
 | FA01 | 37100-KWA-8300 | -102373.86
 | FA01 | 37100-KWH-7510 | -36047.07
 | FA01 | 37100-KWH-9620 | -18530.58
 | FA01 | 37700-KWA-830R | -23940.49
 | FA01 | 42610-KVH-7600 | -124802.35
 | FA01 | 42610-KWA-9400 | -9354.76
 | FA01 | 43000-KTR-7000 | -13302.17
 | FA01 | 50400-KTC-9400 | -3574.57
 | FA01 | 50400-KTC-A20V | -29326.3
 | FA01 | 50400-KTC-A20X | -17124.63
 | FA01 | 50400-KVH-901Z | -14918.24
 | FA01 | 51400-KST-A100 | -14568.16
 | FA01 | 51400-KTC-9010 | -2844.5
 | FA01 | 51400-KTR-A010 | -3644.48
 | FA01 | 51400-KWH-900A | -1691.4
 | FA01 | 51500-KST-9410 | -3863.37
 | FA01 | 51500-KTC-9010 | -2116.22
 | FA01 | 51500-KTR-A010 | -1031.36
 | FA01 | 51500-KWA-9100 | -2795.55
 | FA01 | 51500-KWA-9400 | -2645.8
 | FA01 | 51500-KWH-900A | -1696.71
 | FA01 | 5210A-KST-9400 | -3281.46
 | FA01 | 5210A-KTR-9400 | -4518
 | FA01 | 5210B-KCC-8700 | -1812.12
 | FA01 | 53200-KST-9400 | -1095.08
 | FA01 | 77200-KWA-8300 | 1537.07
 | FA01 | 81201-KCC-730U | -7726.6
 | FA01 | 81201-KWA-940R | -233.99
 | FA01 | 81201-KWA-940U | -6615.27
 | FA01 | 81201-KWA-940V | -579.14
 | FA01 | 81201-KWA-940W | -2054.15
 | FA01 | 8120A-KCC-8300 | -28192.25
 | FA01 | 11133-KTC-9000 | 336.91
 | DC02 | 12191-KPH-9010 | -12109.93
 | DC02 | 12197-KPH-9000 | -11926.02
 | DC02 | 12213-KSP-9100 | -1869.36
 | DC02 | 12391-GW8-6810 | -981.32
 | DC02 | 12395-KPH-9010 | 7785
 | DC02 | [PHONE] | -6473.62
 | DC02 | 14321-GB6-9000 | 20766.9
 | DC02 | [PHONE] | -27824
 | DC02 | 15441-KTC-9000 | -4301.8
 | DC02 | 15441-KTC-900A | 4556.15
 | DC02 | 15661-KTC-9000 | 5791.81
 | DC02 | [PHONE] | -33258.81
 | DC02 | [PHONE] | 1863.18
 | DC02 | 24241-KPH-9000 | 8160
 | DC02 | 24435-HF7-0000 | -13599.23
 | DC02 | 24435-KTC-9000 | 6496
 | DC02 | 28265-KPH-9000 | -1555.72
 | DC02 | 28282-KPH-9000 | 6614.42
 | DC02 | 32961-KPH-9000 | -8298.44
 | DC02 | 32961-KST-9400 | 994.99
 | DC02 | 35752-KRM-8400 | 2033.01
 | DC02 | [PHONE] | -4303.32
 | DC02 | 90022-GFP-9000 | -2360.96
 | DC02 | 90081-GFP-9000 | -3724.24
 | DC02 | [PHONE] | 9099.23
 | DC02 | 90085-KTC-9200 | -14830.61
 | DC02 | [PHONE] | -2538.64
 | DC02 | 90410-HC4-0000 | -3613.73
 | DC02 | [PHONE] | 4650.38
 | DC02 | 90412-KPH-9000 | 1655.64
 | DC02 | [PHONE] | -13897.82
 | DC02 | 90435-HB3-0000 | -4794.21
 | DC02 | [PHONE] | 1527.71
 | DC02 | 90441-KA4-7000 | -766.18
 | DC02 | 90442-GF6-0000 | -655.15
 | DC02 | [PHONE] | 13430.06
 | DC02 | 90443-GF6-0000 | 7996.62
 | DC02 | [PHONE] | 11255.19
 | DC02 | 90451-GF6-0000 | -27494.73
 | DC02 | [PHONE] | -5708.6
 | DC02 | 90452-KGH-9000 | -4347.4
 | DC02 | 90452-KPH-9000 | 2966.72
 | DC02 | 90454-KPH-9000 | 2690.09
 | DC02 | [PHONE] | -1070.96
 | DC02 | [PHONE] | 7740.96
 | DC02 | 90461-GB4-7700 | -3547.84
 | DC02 | 90464-GBG-9000 | -8324.87
 | DC02 | [PHONE] | -6293.6
 | DC02 | 90603-GF6-0000 | -348.13
 | DC02 | [PHONE] | 6499.1
 | DC02 | 90741-KGH-9000 | -13311.78
 | DC02 | 91204-GBG-8500 | -6298.56
 | DC02 | 91204-KPH-9010 | -28471.61
 | DC02 | 91204-MC7-0030 | -3148.75
 | DC02 | 91208-KPH-9010 | -933.94
 | DC02 | [PHONE] | -11537.17
 | DC02 | [PHONE] | 6690.07
 | DC02 | 91356-KGH-9010 | 7251.67
 | DC02 | 92000-06008-0H | 9362
 | DC02 | 92101-06010-0A | -2250.03
 | DC02 | 93600-06016-0A | -1786.37
 | DC02 | 93600-06016-1H | 7469.4
 | DC02 | 94303-03050 | -1575.42
 | DC02 | 94510-16000 | -2808.99
 | DC02 | 95701-06016-00 | 1969.75
 | DC02 | 96001-06022-00 | 8193.01
 | DC02 | 96211-08000 | -4183.78
 | DC02 | 96220-30085 | -1272.75
 | DC02 | 92900-08025-0E | -8067.89
 | EA01 | 23441KTC9010010 | 5257.24
 | GR01 | 16950-KVH-9000 | -18546.72
 | FA01 | 1695A-198-D000 | -138.65
 | FA01 | 1695A-KCC-9000 | -30470.81
 | FA01 | 1695A-KWH-7600 | -3467.52
 | FA01 | 2287A-KWA-9100 | -1999.92
 | FA01 | 2287A-KWH-9700 | -14149.39
 | FA01 | 33400-KST-9200 | -20936.16
 | FA01 | 33400-KST-9500 | 0
 | FA01 | 33400-KTC-9000 | -452.98
 | FA01 | 33400-KTC-A210 | -2144.62
 | FA01 | 33400-KWA-9310 | -402.72
 | FA01 | 33400-KWH-9610 | -513.28
 | FA01 | 33450-KCC-7100 | -1923.11
 | FA01 | 33450-KST-9500 | -1415.02
 | FA01 | 33450-KTC-9000 | -742.86
 | FA01 | 33450-KVH-7600 | -13620.78
 | FA01 | 33450-KVH-9000 | -855.41
 | FA01 | 33450-KWA-9310 | -3833.84
 | FA01 | 33450-KWH-9610 | -290.83
 | FA01 | 33600-KCC-6900 | -721.16
 | FA01 | 33600-KCC-7100 | -3956.8
 | FA01 | 33600-KST-9200 | -509.41
 | FA01 | 33600-KTC-9000 | 0
 | FA01 | 33600-KTC-A210 | -13071.08
 | FA01 | 33600-KVH-9000 | -696.51
 | FA01 | 33600-KWA-8300 | -3850.34
 | FA01 | 33650-KCC-6900 | -346.97
 | FA01 | 33650-KCC-7100 | -1509.5
 | FA01 | 33650-KTC-9000 | -56.34
 | FA01 | 33650-KWA-8300 | -9057.13
 | FA01 | 33650-KWH-9610 | -116.58
 | FA01 | 35350-KWA-9400 | -59.82
 | FA01 | 42303-KCC-6000 | -1884.24
 | FA01 | 42303-KTC-9000 | -134.12
 | FA01 | 44830-KWA-8300 | -16684.76
 | FA01 | 44830-KWA-9100 | -3923.5
 | FA01 | 4545A-KCC-7100 | -45457.8
 | FA01 | 4545A-KTC-9000 | -3177.46
 | FA01 | 50211-KCC-9000 | -24013.75
 | FA01 | 5061A-KCC-9000 | -63.07
 | FA01 | 5061A-KTC-9000 | -327.9
 | FA01 | 5070A-KCC-9000 | -556.29
 | FA01 | 5070A-KST-9400 | -1617.21
 | FA01 | 5070A-KTC-9000 | -486.96
 | FA01 | 5070B-KTC-A200 | -548.74
 | FA01 | 5070B-KWA-9400 | -843.5
 | FA01 | 50803-KCC-9000 | -5085.57
 | FA01 | 50803-KTC-9000 | -141.16
 | FA01 | 50803-KVH-7600 | -147.09
 | FA01 | 50803-KWA-9400 | -3843.43
 | FA01 | 51103-KST-9400 | -390.91
 | FA01 | 51103-KVH-7600 | -649.45
 | FA01 | 5110A-KCC-9000 | -1272.3
 | FA01 | 5110A-KTC-A200 | -291.16
 | FA01 | 5110A-KWA-9400 | -734.4
 | FA01 | 53220-KTR-9000 | -191.34
 | FA01 | 5323A-KWH-9600 | -15246.47
 | FA01 | 90304-KSP-9000 | -95.23