I need to add up the "Qty" when the "P/N", "L/N", and "From"
Here is my data:
P/N L/N Qty From To
sta-d1 k09714 1 N-FG STA-K21
STA-D1 K09714 20 N-FG STA-K21
STA-D3 K08949 3 N-FG STA-K21
STA-D2 K09720 5 N-FG STA-K21
MTP-PS2L 2 N-CNSBLK MT00092
MTP-PS2R 2 N-CNSBLK MT00092
MTP-PS3L 2 N-CNSBLK MT00092
MTP-PS3R 2 N-CNSBLK MT00092
MTP-RS2R 2 N-CNSBLK MT00092
MTP-RS2L 2 N-CNSBLK MT00092
MTP-RS3R 2 N-CNSBLK MT00092
MTP-RS3L 2 N-CNSBLK MT00092
MTP-2712 5 N-CNSBLK MT00092
MTP-2714 5 N-CNSBLK MT00092
MTP-2716 5 N-CNSBLK MT00092
MTP-2718 5 N-CNSBLK MT00092
MTP-2720 5 N-CNSBLK MT00092
MTP-2724 5 N-CNSBLK MT00092
MTP-2728 5 N-CNSBLK MT00092
MTP-3212 5 N-CNSBLK MT00092
MTP-3214 5 N-CNSBLK MT00092
MTP-3216 5 N-CNSBLK MT00092
MTP-3218 5 N-CNSBLK MT00092
MTP-3220 5 N-CNSBLK MT00092
MTP-PS2L 2 N-CNSBLK MT00093
MTP-PS2R 2 N-CNSBLK MT00093
MTP-PS3L 2 N-CNSBLK MT00093
MTP-PS3R 2 N-CNSBLK MT00093
MTP-RS2R 2 N-CNSBLK MT00093
MTP-RS2L 2 N-CNSBLK MT00093
MTP-RS3R 2 N-CNSBLK MT00093
MTP-RS3L 2 N-CNSBLK MT00093
MTP-2712 5 N-CNSBLK MT00093
MTP-2714 5 N-CNSBLK MT00093
MTP-2716 5 N-CNSBLK MT00093
MTP-2718 5 N-CNSBLK MT00093
MTP-2720 5 N-CNSBLK MT00093
MTP-2724 5 N-CNSBLK MT00093
MTP-2728 5 N-CNSBLK MT00093
MTP-3212 5 N-CNSBLK MT00093
MTP-3214 5 N-CNSBLK MT00093
MTP-3216 5 N-CNSBLK MT00093
MTP-3218 5 N-CNSBLK MT00093
MTP-3220 5 N-CNSBLK MT00093
MTP-PS2L 2 N-CNSBLK MT00100
MTP-PS2R 2 N-CNSBLK MT00100
MTP-PS3L 2 N-CNSBLK MT00100
MTP-PS3R 2 N-CNSBLK MT00100
MTP-RS2R 2 N-CNSBLK MT00100
MTP-RS2L 2 N-CNSBLK MT00100
MTP-RS3R 2 N-CNSBLK MT00100
MTP-RS3L 2 N-CNSBLK MT00100
MTP-2712 5 N-CNSBLK MT00100
MTP-2714 5 N-CNSBLK MT00100
MTP-2716 5 N-CNSBLK MT00100
MTP-2718 5 N-CNSBLK MT00100
MTP-2720 5 N-CNSBLK MT00100
MTP-2724 5 N-CNSBLK MT00100
MTP-2728 5 N-CNSBLK MT00100
MTP-3212 5 N-CNSBLK MT00100
MTP-3214 5 N-CNSBLK MT00100
MTP-3216 5 N-CNSBLK MT00100
MTP-3218 5 N-CNSBLK MT00100
MTP-3220 5 N-CNSBLK MT00100
Here is my data:
P/N L/N Qty From To
sta-d1 k09714 1 N-FG STA-K21
STA-D1 K09714 20 N-FG STA-K21
STA-D3 K08949 3 N-FG STA-K21
STA-D2 K09720 5 N-FG STA-K21
MTP-PS2L 2 N-CNSBLK MT00092
MTP-PS2R 2 N-CNSBLK MT00092
MTP-PS3L 2 N-CNSBLK MT00092
MTP-PS3R 2 N-CNSBLK MT00092
MTP-RS2R 2 N-CNSBLK MT00092
MTP-RS2L 2 N-CNSBLK MT00092
MTP-RS3R 2 N-CNSBLK MT00092
MTP-RS3L 2 N-CNSBLK MT00092
MTP-2712 5 N-CNSBLK MT00092
MTP-2714 5 N-CNSBLK MT00092
MTP-2716 5 N-CNSBLK MT00092
MTP-2718 5 N-CNSBLK MT00092
MTP-2720 5 N-CNSBLK MT00092
MTP-2724 5 N-CNSBLK MT00092
MTP-2728 5 N-CNSBLK MT00092
MTP-3212 5 N-CNSBLK MT00092
MTP-3214 5 N-CNSBLK MT00092
MTP-3216 5 N-CNSBLK MT00092
MTP-3218 5 N-CNSBLK MT00092
MTP-3220 5 N-CNSBLK MT00092
MTP-PS2L 2 N-CNSBLK MT00093
MTP-PS2R 2 N-CNSBLK MT00093
MTP-PS3L 2 N-CNSBLK MT00093
MTP-PS3R 2 N-CNSBLK MT00093
MTP-RS2R 2 N-CNSBLK MT00093
MTP-RS2L 2 N-CNSBLK MT00093
MTP-RS3R 2 N-CNSBLK MT00093
MTP-RS3L 2 N-CNSBLK MT00093
MTP-2712 5 N-CNSBLK MT00093
MTP-2714 5 N-CNSBLK MT00093
MTP-2716 5 N-CNSBLK MT00093
MTP-2718 5 N-CNSBLK MT00093
MTP-2720 5 N-CNSBLK MT00093
MTP-2724 5 N-CNSBLK MT00093
MTP-2728 5 N-CNSBLK MT00093
MTP-3212 5 N-CNSBLK MT00093
MTP-3214 5 N-CNSBLK MT00093
MTP-3216 5 N-CNSBLK MT00093
MTP-3218 5 N-CNSBLK MT00093
MTP-3220 5 N-CNSBLK MT00093
MTP-PS2L 2 N-CNSBLK MT00100
MTP-PS2R 2 N-CNSBLK MT00100
MTP-PS3L 2 N-CNSBLK MT00100
MTP-PS3R 2 N-CNSBLK MT00100
MTP-RS2R 2 N-CNSBLK MT00100
MTP-RS2L 2 N-CNSBLK MT00100
MTP-RS3R 2 N-CNSBLK MT00100
MTP-RS3L 2 N-CNSBLK MT00100
MTP-2712 5 N-CNSBLK MT00100
MTP-2714 5 N-CNSBLK MT00100
MTP-2716 5 N-CNSBLK MT00100
MTP-2718 5 N-CNSBLK MT00100
MTP-2720 5 N-CNSBLK MT00100
MTP-2724 5 N-CNSBLK MT00100
MTP-2728 5 N-CNSBLK MT00100
MTP-3212 5 N-CNSBLK MT00100
MTP-3214 5 N-CNSBLK MT00100
MTP-3216 5 N-CNSBLK MT00100
MTP-3218 5 N-CNSBLK MT00100
MTP-3220 5 N-CNSBLK MT00100