Spreadsheet: 89173d1288917892-vlookup-with-sumif-excel_forum_752045
Sheet: Data

 |  |  |  | 2009-02-01 00:00:00 | A
 |  |  |  | $F$7 |  | 3678.77
 |  |  |  | $F$24
 |  |  |  | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00
Concat | Location | Transfer From | Metric
AWidgets | A | U | Widgets | 99 | 64 | 85 | 18 | 5 | 79 | 82 | 67 | 36 | 54 | 54 | 60 | 82 | 99 | 90 | 36 | 66 | 93 | 56 | 73 | 65
ACost | A | U | Cost | 878.09 | 893.49 | 69.02 | 952.41 | 934.43 | 843.82 | 6.66 | 23.99 | 240.05 | 630.35 | 187.19 | 587.52 | 638.06 | 94.9 | 49.47 | 842.92 | 408.63 | 470.38 | 819.19 | 861.2 | 995.06
ADamaged | A | U | Damaged | 6 | 6 | 10 | 6 | 5 | 2 | 10 | 7 | 2 | 3 | 10 | 4 | 5 | 8 | 4 | 6 | 1 | 4 | 5 | 4 | 5
BWidgets | B | V | Widgets | 3 | 39 | 70 | 2 | 54 | 38 | 99 | 69 | 78 | 66 | 8 | 86 | 85 | 30 | 45 | 26 | 76 | 56 | 30 | 97 | 96
BCost | B | V | Cost | 70.25 | 885.1 | 827.47 | 701.1 | 716.26 | 380.97 | 390.9 | 896.84 | 591.03 | 297.92 | 148.14 | 583.37 | 852.3 | 463.06 | 601.36 | 778.33 | 753.08 | 502.84 | 823.48 | 784.06 | 42.48
BDamaged | B | V | Damaged | 6 | 2 | 9 | 5 | 8 | 6 | 1 | 9 | 8 | 5 | 10 | 5 | 9 | 8 | 1 | 8 | 7 | 5 | 0 | 1 | 2
AWidgets | A | W | Widgets | 93 | 53 | 47 | 49 | 45 | 91 | 2 | 95 | 60 | 81 | 87 | 47 | 51 | 49 | 71 | 96 | 72 | 71 | 58 | 88 | 8
ACost | A | W | Cost | 595.13 | 1 | 343.88 | 461.82 | 891.25 | 484.24 | 724.11 | 825.97 | 26.27 | 805.08 | 178.99 | 877.94 | 127.44 | 434.93 | 262.94 | 532.16 | 275.46 | 303.47 | 112.35 | 991.92 | 901.81
ADamaged | A | W | Damaged | 3 | 2 | 9 | 8 | 6 | 1 | 9 | 9 | 5 | 7 | 4 | 3 | 5 | 4 | 7 | 2 | 9 | 4 | 3 | 9 | 4
CWidgets | C | X | Widgets | 16 | 8 | 82 | 71 | 4 | 26 | 86 | 94 | 41 | 16 | 32 | 23 | 63 | 54 | 79 | 2 | 30 | 49 | 61 | 42 | 62
CCost | C | X | Cost | 563.5 | 200.46 | 451.94 | 942.41 | 333.99 | 717.96 | 421.65 | 92.44 | 652.91 | 66.01 | 398.99 | 322.51 | 757.34 | 536.89 | 570.16 | 253.37 | 332.4 | 422.85 | 978.77 | 729.65 | 464.68
CDamaged | C | X | Damaged | 4 | 2 | 3 | 7 | 10 | 6 | 7 | 6 | 10 | 4 | 1 | 9 | 9 | 4 | 4 | 1 | 1 | 6 | 6 | 9 | 7
AWidgets | A | Y | Widgets | 25 | 32 | 53 | 7 | 2 | 27 | 1 | 53 | 58 | 95 | 49 | 45 | 50 | 60 | 73 | 94 | 14 | 8 | 62 | 80 | 77
ACost | A | Y | Cost | 32.88 | 781.19 | 690.66 | 710.03 | 918.71 | 664.37 | 504.3 | 778.95 | 746.95 | 505.17 | 758.51 | 408.02 | 188.55 | 19.48 | 495.02 | 524.69 | 408.12 | 332.04 | 731.89 | 899.03 | 637.02
ADamaged | A | Y | Damaged | 5 | 8 | 9 | 7 | 6 | 7 | 4 | 1 | 8 | 5 | 5 | 7 | 0 | 3 | 8 | 6 | 2 | 6 | 10 | 9 | 1
CWidgets | C | Z | Widgets | 55 | 93 | 92 | 80 | 92 | 90 | 92 | 36 | 2 | 22 | 65 | 21 | 1 | 64 | 24 | 81 | 52 | 22 | 43 | 3 | 9
CCost | C | Z | Cost | 165.06 | 603.53 | 766.29 | 978.21 | 180.87 | 300.27 | 856.86 | 788.9 | 774.54 | 133.62 | 384.41 | 851.41 | 516.51 | 262.2 | 586.56 | 106.57 | 718.39 | 703.38 | 970.51 | 988.59 | 45.63
CDamaged | C | Z | Damaged | 5 | 5 | 4 | 9 | 1 | 9 | 2 | 3 | 2 | 7 | 9 | 7 | 6 | 1 | 4 | 9 | 1 | 1 | 7 | 7 | 5