|
存货编码 | 条数 | 米数 | | 存货编码 | 合计条数 | 公式 | 合计米数 | 公式 | 6300300402050004002140 | 2 | 28 | | 6200100101050012501000090 | 189 | SUMIF(A:A,G2,B:B) | 2291 | SUMIF(A:A,G2,C:C) | 6300300402050004002150 | 4 | 60 | | 6200100101050012501000120 | 189 | SUMIF(A:A,G3,B:B) | 2291 | SUMIF(A:A,G3,C:C) | 6300300402050004008140 | 2 | 28 | | 6200100101050012501000130 | 189 | SUMIF(A:A,G4,B:B) | 2291 | SUMIF(A:A,G4,C:C) | 6300300402050004008150 | 4 | 60 | | 6200100101050012501000140 | 189 | SUMIF(A:A,G5,B:B) | 2291 | SUMIF(A:A,G5,C:C) | 6200100101080013002000110 | 1 | 11 | | 6200100101050012501000150 | 189 | SUMIF(A:A,G6,B:B) | 2291 | SUMIF(A:A,G6,C:C) | 6200100101080013002000120 | 4 | 48 | | 6200100101050012502000060 | 189 | SUMIF(A:A,G7,B:B) | 2291 | SUMIF(A:A,G7,C:C) | 6200100101080013002000130 | 4 | 52 | | 6200100101050012502000080 | 189 | SUMIF(A:A,G8,B:B) | 2291 | SUMIF(A:A,G8,C:C) | 6200100101080013002000140 | 4 | 56 | | 6200100101050012502000090 | 189 | SUMIF(A:A,G9,B:B) | 2291 | SUMIF(A:A,G9,C:C) | 6200100101080013002000150 | 2 | 30 | | 6200100101050012502000100 | 189 | SUMIF(A:A,G10,B:B) | 2291 | SUMIF(A:A,G10,C:C) | 6200100101040009501000100 | 7 | 70 | | 6200100101050012502000110 | 189 | SUMIF(A:A,G11,B:B) | 2291 | SUMIF(A:A,G11,C:C) | 6200100101040009501000140 | 5 | 70 | | 6200100101050012502000120 | 189 | SUMIF(A:A,G12,B:B) | 2291 | SUMIF(A:A,G12,C:C) | 6200100101050012501000130 | 2 | 26 | | 6200100101050012502000130 | 189 | SUMIF(A:A,G13,B:B) | 2291 | SUMIF(A:A,G13,C:C) | 6200100101050012501000140 | 4 | 56 | | 6200100101050012502000140 | 189 | SUMIF(A:A,G14,B:B) | 2291 | SUMIF(A:A,G14,C:C) | 6200100101050012502000100 | 8 | 80 | | 6200100101050012502000150 | 189 | SUMIF(A:A,G15,B:B) | 2291 | SUMIF(A:A,G15,C:C) | 6200100101050012502000110 | 6 | 66 | | 6200100101060013002000060 | 4 | SUMIF(A:A,G16,B:B) | 26 | SUMIF(A:A,G16,C:C) | 6200100101050012502000130 | 10 | 130 | | 6200100101060013002000070 | 4 | SUMIF(A:A,G17,B:B) | 26 | SUMIF(A:A,G17,C:C) | 6200100113050012503002110 | 1 | 11 | | 6200100101080013002000110 | 34 | SUMIF(A:A,G18,B:B) | 470 | SUMIF(A:A,G18,C:C) | 6200100101040009501000100 | 7 | 70 | | 6200100101080013002000120 | 34 | SUMIF(A:A,G19,B:B) | 470 | SUMIF(A:A,G19,C:C) | 6200100101040009501000140 | 6 | 84 | | 6200100101080013002000130 | 34 | SUMIF(A:A,G20,B:B) | 470 | SUMIF(A:A,G20,C:C) | 6200100101050012501000080 | 1 | 8 | | 6200100101080013002000140 | 34 | SUMIF(A:A,G21,B:B) | 470 | SUMIF(A:A,G21,C:C) | 6200100101050012501000130 | 4 | 52 | | 6200100101080013002000150 | 34 | SUMIF(A:A,G22,B:B) | 470 | SUMIF(A:A,G22,C:C) | 6200100101050012501000140 | 2 | 28 | | 6200100113050012503002110 | 2 | SUMIF(A:A,G23,B:B) | 23 | SUMIF(A:A,G23,C:C) | 6200100101040009502000060 | 2 | 12 | | 6200100113050012503002120 | 2 | SUMIF(A:A,G24,B:B) | 23 | SUMIF(A:A,G24,C:C) | 6200100101050012502000100 | 2 | 20 | | 6200100117050012502003100 | 7 | SUMIF(A:A,G25,B:B) | 70 | SUMIF(A:A,G25,C:C) | 6200100101050012502000110 | 5 | 55 | | 6300300402050004002140 | 48 | SUMIF(A:A,G26,B:B) | 686 | SUMIF(A:A,G26,C:C) | 6200100101050012502000130 | 9 | 117 | | 6300300402050004002150 | 48 | SUMIF(A:A,G27,B:B) | 686 | SUMIF(A:A,G27,C:C) | 6200100117050012502003100 | 7 | 70 | | 6300300402050004008140 | 48 | SUMIF(A:A,G28,B:B) | 686 | SUMIF(A:A,G28,C:C) | 6200100101040009501000110 | 1 | 11 | | 6300300402050004008150 | 48 | SUMIF(A:A,G29,B:B) | 686 | SUMIF(A:A,G29,C:C) | 6200100101050012501000090 | 4 | 36 | | 6200100101050012501000150 | 189 | SUMIF(A:A,G30,B:B) | 2291 | SUMIF(A:A,G30,C:C) | 6200100101050012501000120 | 5 | 60 | | 6200100101080013002000130 | 34 | SUMIF(A:A,G31,B:B) | 470 | SUMIF(A:A,G31,C:C) | 6200100101050012501000150 | 4 | 60 | | | | | | | 6200100101050012502000090 | 7 | 63 | | | | | | | 6200100101050012502000110 | 1 | 11 | | | | | | | 6200100101050012502000120 | 10 | 120 | | | | | | | 6200100101050012502000140 | 5 | 70 | | | | | | | 6200100101050012502000150 | 1 | 15 | | | | | | | 6200100101040009501000090 | 15 | 135 | | | | | | | 6200100101040009501000110 | 14 | 154 | | | | | | | 6200100101050012501000150 | 2 | 30 | | | | | | | 6200100101040009502000090 | 2 | 18 | | | | | | | 6200100101050012502000110 | 2 | 22 | | | | | | | 6200100101050012502000120 | 4 | 48 | | | | | | | 6200100101050012502000140 | 9 | 126 | | | | | | | 6200100101050012502000150 | 2 | 30 | | | | | | | 6200100101050012501000090 | 12 | 108 | | | | | | | 6200100101050012501000120 | 1 | 12 | | | | | | | 6200100101050012501000150 | 1 | 15 | | | | | | | 6200100101050012502000090 | 1 | 9 | | | | | | | 6200100101050012502000110 | 2 | 22 | | | | | | | 6200100101050012502000120 | 7 | 84 | | | | | | | 6200100101050012502000140 | 3 | 42 | | | | | | | 6200100101050012502000150 | 10 | 150 | | | | | | | 6200100113050012503002120 | 1 | 12 | | | | | | | 6200100101050012501000090 | 9 | 81 | | | | | | | 6200100101050012501000120 | 4 | 48 | | | | | | | 6200100101060013002000060 | 2 | 12 | | | | | | | 6200100101060013002000070 | 2 | 14 | | | | | | | 6200100101050012502000090 | 2 | 18 | | | | | | | 6200100101050012502000110 | 6 | 66 | | | | | | | 6200100101050012502000140 | 7 | 98 | | | | | | | 6200100101050012502000150 | 13 | 195 | | | | | | | 6200100101050012502000060 | 1 | 6 | | | | | | | 6200100101050012502000080 | 1 | 8 | | | | | | | 6300300402050004002140 | 6 | 84 | | | | | | | 6300300402050004002150 | 1 | 15 | | | | | | | 6300300402050004008140 | 4 | 56 | | | | | | | 6300300402050004008150 | 1 | 15 | | | | | | | 6200100101080013002000140 | 4 | 56 | | | | | | | 6200100101080013002000150 | 4 | 60 | | | | | | | 6200100101080013002000110 | 1 | 11 | | | | | | | 6200100101080013002000130 | 1 | 13 | | | | | | | 6200100101080013002000140 | 2 | 28 | | | | | | | 6200100101080013002000150 | 7 | 105 | | | | | | | 6300300402050004002140 | 8 | 112 | | | | | | | 6300300402050004002150 | 2 | 30 | | | | | | | 6300300402050004008140 | 2 | 28 | | | | | | | 6300300402050004002140 | 2 | 28 | | | | | | | 6300300402050004008140 | 8 | 112 | | | | | | | 6300300402050004008150 | 2 | 30 | | | | | | |
编码太长了。SUMIF只能条件前面的15位。见新的附件。
=SUMPRODUCT(($A$2:$A$80=E2)*($B$2:$B$80))
|
|