Spreadsheet: 124793d1318609087-vlookup-to-sum-all-line-under-same-reference-test-sample
Sheet: Ref#2

Track# | Line Value$
UPS24732318 | 703.12
UPS24732318 | 7657.08
UPS24732318 | 8088.95
UPS24732318 | 577.16
UPS24732318 | 25600
UPS24732318 | 1.25
UPS24732318 | 103.92
UPS24732318 | 259.6 | 42991.07999999999
UPS24732607 | 12900
UPS24732607 | 1958
UPS24732607 | 1170
UPS24732607 | 4800
UPS24732607 | 3800
UPS24732607 | 6750
UPS24732607 | 207.4
UPS24732607 | 328.6
UPS24732607 | 2036.5
UPS24732607 | 949.19
UPS24732607 | 3498.1
UPS24732607 | 937.5
UPS24732607 | 82.14
UPS24732607 | 715.5
UPS24732607 | 939.4
UPS24732607 | 349
UPS24732607 | 27.84
UPS24732607 | 481.95
UPS24732607 | 353.3
UPS24732607 | 37.46
UPS24732607 | 1975.95
UPS24732607 | 59.56
UPS24732607 | 70.9
UPS24732607 | 5771.4
UPS24732607 | 12113.24
UPS24732607 | 2080.5
UPS24732607 | 1886.5
UPS24732607 | 750.7
UPS24732607 | 245.66
UPS24732607 | 269.08
UPS24732607 | 2970.3
UPS24732607 | 466.8
UPS24732607 | 6756.85
UPS24732607 | 1597.7
UPS24732607 | 3221.16
UPS24732607 | 3107.44
UPS24732607 | 10935.84
UPS24732607 | 2856
UPS24732607 | 2628.5
UPS24732607 | 57.15
UPS24732607 | 411
UPS24732607 | 2767.4
UPS24732607 | 1788
UPS24732607 | 190.5
UPS24732607 | 3173.75
UPS24732607 | 20
UPS24732607 | 1021.58
UPS24732607 | 809.04
UPS24732607 | 302
UPS24732607 | 10358.4
UPS24732607 | 15.11
UPS24732607 | 699.55
UPS24732607 | 14180
UPS24732607 | 2983.04
UPS24732607 | 24000
UPS24732607 | 4800
UPS24732607 | 409.6
UPS24732607 | 56.6
[NAME] | 37.31
[NAME] | 2945.2
[NAME] | 7363
[NAME] | 4319.62
[NAME] | 778.16
[NAME] | 371.62
[NAME] | 128.96
[NAME] | 467.21
[NAME] | 1065.17
[NAME] | 392.7
[NAME] | 844.29
[NAME] | 103.79
[NAME] | 94.72
[NAME] | 49.67
[NAME] | 158.55
[NAME] | 1016.19
[NAME] | 358.53
[NAME] | 1579.86
[NAME] | 59.55
[NAME] | 16778.71
[NAME] | 3159.71
[NAME] | 4340.13
[NAME] | 593.51
[NAME] | 1554.69
[NAME] | 8.31
[NAME] | 6153.81
[NAME] | 18.76
[NAME] | 312.13
[NAME] | 2246.23
[NAME] | 518.04
[NAME] | 1022.07
[NAME] | 3791.2
[NAME] | 750.23
[NAME] | 946.09
[NAME] | 929.8
[NAME] | 728.94
[NAME] | 47.14
[NAME] | 7409.97
[NAME] | 1728.27
[NAME] | 1518.16
[NAME] | 964.34
[NAME] | 6982.87
[NAME] | 172.34
[NAME] | 13752.14
[NAME] | 4119.98
[NAME] | 214.65
[NAME] | 953.3
[NAME] | 1371.63
[NAME] | 849.32
[NAME] | 848.57
[NAME] | 166.52
[NAME] | 348.48
[NAME] | 319.6
[NAME] | 19.63
[NAME] | 2.88
[NAME] | 557.62
[NAME] | 1275.12
[NAME] | 97.5
[NAME] | 155.86
[NAME] | 2503.41
[NAME] | 1780.87
[NAME] | 2788.36
[NAME] | 1039.81
[NAME] | 13136.73
[NAME] | 22354.05
[NAME] | 425.49
[NAME] | 402.11
[NAME] | 4.91
[NAME] | 5.89
[NAME] | 41.23
UPS24734777 | 265.4
UPS24734777 | 267
UPS24734777 | 578.75
UPS24734777 | 3882.83
UPS24734777 | 207.52
[NAME] | 7870.84
[NAME] | 3766.9
[NAME] | 163562.86
[NAME] | 1196.56
[NAME] | 189.34
[NAME] | 13837.64
[NAME] | 9660.68
[NAME] | 25.34
[NAME] | 110.63
[NAME] | 355.91
[NAME] | 147.14
[NAME] | 1965.13
[NAME] | 10246.17
[NAME] | 213.7
[NAME] | 9738.95
[NAME] | 36.76
[NAME] | 1705.81
[NAME] | 338.31
[NAME] | 34.5
[NAME] | 78.52
[NAME] | 650.32
[NAME] | 2112.43
[NAME] | 242.22
[NAME] | 13774.88
[NAME] | 1373.54
[NAME] | 160.89
[NAME] | 1056.63
[NAME] | 13866.97
[NAME] | 2331.4
[NAME] | 6.35
[NAME] | 643.18
[NAME] | 865.4
[NAME] | 6859.73
[NAME] | 27567.77
[NAME] | 40.84
UPS24735139 | 859.28
UPS24735139 | 735.89
UPS24735139 | 3.35
UPS24735139 | 2165.97
UPS24735139 | 1931.42
UPS24735147 | 45.1
UPS24735147 | 11199.49
UPS24735147 | 11788.94
UPS24735147 | 589.45
UPS24735147 | 6041.83
UPS24735147 | 11641.58
UPS24735147 | 2755.66
UPS24735147 | 5747.11
UPS24735147 | 1166.61
UPS24735147 | 3559.42
UPS24735147 | 3006.18
UPS24735147 | 79.77
UPS24735147 | 787.5
UPS24735147 | 645.64
UPS24735147 | 1424.99
UPS24735147 | 4971.89
UPS24735147 | 460.8
UPS24735147 | 196.48
UPS24735147 | 365.85
UPS24735147 | 2894.66
UPS24735147 | 33.83
UPS24735147 | 184.2
UPS24735147 | 313.82
UPS24735147 | 495.72
UPS24735147 | 49.9
UPS24735147 | 619.66
UPS24735147 | 196.58
UPS24735147 | 43.89
UPS24735147 | 76.14
UPS24735147 | 385.11
UPS24735147 | 1985.45
UPS24735147 | 44.85
UPS24735147 | 44.41
UPS24735147 | 329.21
UPS24735147 | 51.81
UPS24735147 | 76.14
UPS24735147 | 74.8
UPS24735147 | 847.57
UPS24735147 | 4106.48
UPS24735147 | 1619.8
UPS24735147 | 240
UPS24735147 | 95.33
UPS24735147 | 188.94
UPS24735147 | 8737.3
UPS24735147 | 544.5
UPS24735147 | 3169.31
UPS24735147 | 271.66
UPS24735147 | 2894.66
UPS24735147 | 270.26
UPS24735147 | 1267.81
UPS24735147 | 21314.23
UPS24735147 | 385.11
UPS24735147 | 73.64
UPS24735147 | 6797.5
UPS24735147 | 924.77
UPS24735147 | 211.81
UPS24735147 | 41.54
UPS24735147 | 3793.04
UPS24735147 | 1077.75
UPS24735147 | 5666.02
UPS24735147 | 1428.38
UPS24735147 | 2340.5
UPS24735147 | 259.21
UPS24735147 | 145.16
UPS24735147 | 599.31
UPS24735147 | 19022.41
UPS24735147 | 8368.03
UPS24735147 | 209.14
UPS24735147 | 2101.01
UPS24735147 | 73.51
UPS24735147 | 297.18
UPS24735147 | 6370.89
UPS24735147 | 143.47
UPS24735147 | 1898.28
UPS24735147 | 1255.96
UPS24735147 | 323.75
UPS24735147 | 842.91
UPS24735147 | 392.57
UPS24735147 | 4749.47
UPS24735147 | 1553.18
UPS24735147 | 10271.71
UPS24735147 | 575
UPS24735147 | 345.5
UPS24735147 | 3808.56
UPS24735147 | 938.94
UPS24735147 | 187.64
UPS24735147 | 403.45
UPS24735147 | 413.79
UPS24735147 | 107.4
UPS24735147 | 2597.06
UPS24735147 | 491.21
UPS24735147 | 413.79
UPS24735147 | 177.11
UPS24735147 | 1006.97
UPS24735147 | 787.51
UPS24735147 | 1160.39
UPS24735147 | 916.17
UPS24735147 | 11.83
UPS24735147 | 882.4
UPS24735147 | 98.49
UPS24735147 | 664.65
UPS24735147 | 368.4
UPS24735147 | 2579.81
UPS24735147 | 4640.89
UPS24735147 | 116.65
UPS24735147 | 241.28
UPS24735147 | 33.16
UPS24735147 | 1641.62
UPS24735147 | 3931.72
UPS24735147 | 1809.95
UPS24735147 | 729.6
UPS24735147 | 71.96
UPS24735147 | 16.99
UPS24735147 | 1245.61
UPS24735147 | 1256.94
UPS24735147 | 3206.65
UPS24735147 | 3968.94
UPS24735147 | 8487.43
UPS24735147 | 3594.23
UPS24735147 | 2930.57
UPS24735147 | 405.14
UPS24735147 | 111.6
UPS24735147 | 223.99
UPS24735147 | 327.82
UPS24735147 | 76.24
UPS24735147 | 55.76
UPS24735329 | 78.7
UPS24735329 | 16231.81
UPS24735329 | 4916.76
UPS24735329 | 206.59
UPS24735329 | 467.28
UPS24735329 | 2833.2
UPS24735329 | 4916.76
UPS24735329 | 3836.61
UPS24735329 | 141.91
UPS24735329 | 713.46
UPS24735329 | 1087.89
UPS24735329 | 6105.91
UPS24735329 | 1320.19
UPS24735329 | 1189.72
UPS24735329 | 259.86
UPS24735329 | 252.29
UPS24735329 | 702.25
UPS24735329 | 2489.37
UPS24735329 | 265.41
UPS24735329 | 487.41
UPS24735329 | 48.4
UPS24735329 | 96.88
UPS24735329 | 3398.19
UPS24735329 | 673.05
UPS24735329 | 6680.3
UPS24735329 | 712.15
UPS24735329 | 470.55
UPS24735329 | 3410.63
UPS24735329 | 4150.15
UPS24735329 | 235.86
UPS24735329 | 6677.2
UPS24735329 | 6733.99
UPS24735329 | 447.71
UPS24735329 | 1135.14
UPS24735329 | 131.84
UPS24735329 | 121.78
UPS24735329 | 2183.79
UPS24735329 | 341.26
UPS24735329 | 851.98
UPS24735329 | 267.99
UPS24735329 | 385.14
UPS24735329 | 473.14
UPS24735329 | 1553.08
UPS24735329 | 5820.64
UPS24735329 | 2451.84
UPS24735329 | 1490.18
UPS24735329 | 1269.36
UPS24735329 | 1197.61
UPS24735329 | 1770.74
UPS24735329 | 1071.9
UPS24735329 | 136.8
UPS24735329 | 11.15
UPS24735329 | 368.91
UPS24735329 | 3106.84
UPS24735329 | 1724.21
UPS24735329 | 3633.91
UPS24735329 | 341.89
UPS24735329 | 1256.05
UPS24735329 | 368.91
UPS24735329 | 2860.92
UPS24735329 | 691.12
UPS24735329 | 35650.96
UPS24735329 | 1021.5
UPS24735329 | 2626.72
UPS24735329 | 22035.9
UPS24735329 | 2858.88
UPS24735329 | 3648.22
UPS24735329 | 3320.83
UPS24735329 | 3320.83
UPS24735329 | 26206.99
UPS24735329 | 218.98
UPS24735329 | 673.47
UPS24735329 | 40.94
UPS24735477 | 1747.97
UPS24735477 | 5629.06
UPS24735477 | 4740.26
UPS24735477 | 29401.47
UPS24735477 | 2666.4
UPS24735477 | 1172.72
UPS24735477 | 5372.3
UPS24735477 | 691.29
UPS24735477 | 19.73
UPS24735477 | 30.41
UPS24735477 | 434.48
UPS24735477 | 1173.66
UPS24735477 | 111.81
UPS24735477 | 703.48
UPS24735477 | 381.24
UPS24735477 | 5533.01
UPS24735477 | 166.85
UPS24735477 | 11.56
UPS24735477 | 20.38
UPS24735477 | 49.67
UPS24735477 | 62.22
UPS24735477 | 2967.87
UPS24735477 | 231.05
UPS24735477 | 959.28
UPS24735477 | 309.3
UPS24735477 | 1388.04
UPS24735477 | 366.76
UPS24735477 | 607.92
UPS24735477 | 179.59
UPS24735477 | 6616.62
UPS24735477 | 35.56
UPS24735477 | 3629.26
UPS24735477 | 451.07
UPS24735477 | 4208.96
UPS24735477 | 242.69
UPS24735477 | 192.19
UPS24735477 | 100.51
UPS24735477 | 940.05
UPS24735477 | 156.53
UPS24735477 | 2789.22
UPS24735477 | 54.23
UPS24735477 | 1070.31
UPS24735477 | 255.05
UPS24735477 | 1805.32
UPS24735477 | 855.28
UPS24735477 | 1348.29
UPS24735477 | 209.51
UPS24735477 | 892.02
UPS24735477 | 6785.45
UPS24735477 | 774.66
UPS24735477 | 1164.82
UPS24735477 | 3451.78
UPS24735477 | 282.89
UPS24735477 | 3061.23
UPS24735477 | 3381.61
UPS24735477 | 4555.61
UPS24735477 | 1431.04
UPS24735477 | 1975.11
UPS24735477 | 75.25
UPS24735477 | 664.84
UPS24735477 | 539.99
UPS24735477 | 234.52
UPS24735477 | 531.21
UPS24735477 | 419.04
UPS24735477 | 6797.72
UPS24735477 | 107722.45
UPS24735477 | 648.05