Spreadsheet: 105002d1302501336-excel-2007-sum-if-macro-excel-2007-test
Sheet: Sheet1

Article | Article Description | Site | MvT | Art.Doc. | User name | Postg Date | Period | EA's | [NAME] | Pack Size | Pac's | [NAME] | Amt | Comment
1067888 | GEL TEA TREE 2.5ML A21 | DC01 | 712 | 4918107265 |  | 2011-01-20 00:00:00 | 1 | 84 | 84 | 6 | 14 | 14 | 48.13
1082965 | HM SPRAY VANILLA LIME BLOSSOM 100ML AX | DC01 | 711 | 4917998440 |  | 2011-01-12 00:00:00 | 1 | -18 | -18 | 6 | -3 | -3 | -21.71
1082965 | HM SPRAY VANILLA LIME BLOSSOM 100ML AX | DC01 | 712 | 4918074828 |  | 2011-01-18 00:00:00 | 1 | 12 | -18 | 6 | 2 | -3 | 14.47
1082965 | HM SPRAY VANILLA LIME BLOSSOM 100ML AX | DC01 | 711 | 4919011187 |  | 2011-04-04 00:00:00 | 4 | -12 | -18 | 6 | -2 | -3 | -14.47
1084149 | LOVE GLOSS 02 GLDN CORAL 7.5ML A0 | DC01 | 711 | 4918490923 |  | 2011-02-21 00:00:00 | 2 | -135 | -135 | 3 | -45 | -45 | -135.63
1084149 | LOVE GLOSS 02 GLDN CORAL 7.5ML A0 | DC01 | 712 | 4918944671 |  | 2011-03-29 00:00:00 | 3 | 3 | -135 | 3 | 1 | -45 | 2.93
1084149 | LOVE GLOSS 02 GLDN CORAL 7.5ML A0 | DC01 | 712 | 4918961313 |  | 2011-03-30 00:00:00 | 3 | 21 | -135 | 3 | 7 | -45 | 20.52
1084149 | LOVE GLOSS 02 GLDN CORAL 7.5ML A0 | DC01 | 711 | 4918985178 |  | 2011-04-01 00:00:00 | 4 | -24 | -135 | 3 | -8 | -45 | -23.45
1085738 | LOVE GLOSS 19 TWKLING PINK 7.5ML XM10 A0 | DC01 | 711 | 4918367247 |  | 2011-02-10 00:00:00 | 2 | -87 | -90 | 3 | -29 | -30 | -77.62
1085738 | LOVE GLOSS 19 TWKLING PINK 7.5ML XM10 A0 | DC01 | 711 | 4919011188 |  | 2011-04-04 00:00:00 | 4 | -3 | -90 | 3 | -1 | -30 | -2.68
1067896 | MITT BODY HEMP NATURAL A0 | DC01 | 712 | 4918001313 |  | 2011-01-12 00:00:00 | 1 | 231 | 225 | 3 | 77 | 75 | 297.99
1067896 | MITT BODY HEMP NATURAL A0 | DC01 | 712 | 4917992469 |  | 2011-01-12 00:00:00 | 1 | 3 | 225 | 3 | 1 | 75 | 3.87
1067896 | MITT BODY HEMP NATURAL A0 | DC01 | 711 | 4918485733 |  | 2011-02-21 00:00:00 | 2 | -6 | 225 | 3 | -2 | 75 | -7.48
1067896 | MITT BODY HEMP NATURAL A0 | DC01 | 711 | 4919055414 |  | 2011-04-07 00:00:00 | 4 | -3 | 225 | 3 | -1 | 75 | -3.39
1059378 | MOISTURE FOUNDATION SPF15 05 30ML AX | DC01 | 711 | 4918070464 |  | 2011-01-18 00:00:00 | 1 | -78 | -183 | 3 | -26 | -61 | -188.24
1059378 | MOISTURE FOUNDATION SPF15 05 30ML AX | DC01 | 711 | 4918575900 |  | 2011-02-28 00:00:00 | 2 | -36 | -183 | 3 | -12 | -61 | -85.12
1059378 | MOISTURE FOUNDATION SPF15 05 30ML AX | DC01 | 712 | 4918664406 |  | 2011-03-07 00:00:00 | 3 | 15 | -183 | 3 | 5 | -61 | 35.47
1059378 | MOISTURE FOUNDATION SPF15 05 30ML AX | DC01 | 711 | 4918948065 |  | 2011-03-29 00:00:00 | 3 | -27 | -183 | 3 | -9 | -61 | -62.68
1059378 | MOISTURE FOUNDATION SPF15 05 30ML AX | DC01 | 711 | 4918948065 |  | 2011-03-29 00:00:00 | 3 | -63 | -183 | 3 | -21 | -61 | -146.24
1059378 | MOISTURE FOUNDATION SPF15 05 30ML AX | DC01 | 711 | 4919014545 |  | 2011-04-04 00:00:00 | 4 | -6 | -183 | 3 | -2 | -61 | -13.93
1059378 | MOISTURE FOUNDATION SPF15 05 30ML AX | DC01 | 711 | 4919014592 |  | 2011-04-04 00:00:00 | 4 | -483 | -183 | 3 | -161 | -61 | -1121.19
1059378 | MOISTURE FOUNDATION SPF15 05 30ML AX | DC01 | 712 | 4919014592 |  | 2011-04-04 00:00:00 | 4 | 18 | -183 | 3 | 6 | -61 | 41.78
1059378 | MOISTURE FOUNDATION SPF15 05 30ML AX | DC01 | 712 | 4919014592 |  | 2011-04-04 00:00:00 | 4 | 492 | -183 | 3 | 164 | -61 | 1142.09
1059378 | MOISTURE FOUNDATION SPF15 05 30ML AX | DC01 | 711 | 4919030144 |  | 2011-04-05 00:00:00 | 4 | -15 | -183 | 3 | -5 | -61 | -34.82
1049533 | [NAME] SPF15 ALOE 50ML A22 | DC01 | 712 | 4918582164 |  | 2011-02-28 00:00:00 | 2 | 12 | 78 | 6 | 2 | 13 | 17.32
1049533 | [NAME] SPF15 ALOE 50ML A22 | DC01 | 712 | 4918633292 |  | 2011-03-04 00:00:00 | 3 | 66 | 78 | 6 | 11 | 13 | 95.24
1049533 | [NAME] SPF15 ALOE 50ML A22 | DC01 | 712 | 4918633292 |  | 2011-03-04 00:00:00 | 3 | 18 | 78 | 6 | 3 | 13 | 25.97
1049533 | [NAME] SPF15 ALOE 50ML A22 | DC01 | 711 | 4918885490 |  | 2011-03-24 00:00:00 | 3 | -6 | 78 | 6 | -1 | 13 | -8.66
1049533 | [NAME] SPF15 ALOE 50ML A22 | DC01 | 711 | 4919052669 |  | 2011-04-07 00:00:00 | 4 | -12 | 78 | 6 | -2 | 13 | -17.31
1024135 | NAIL SHINER BIG M1 | DC01 | 712 | 4918505164 |  | 2011-02-22 00:00:00 | 2 | 498 | 273 | 3 | 166 | 91 | 88.47
1024135 | NAIL SHINER BIG M1 | DC01 | 711 | 4918876469 |  | 2011-03-23 00:00:00 | 3 | -249 | 273 | 3 | -83 | 91 | -44.36
1024135 | NAIL SHINER BIG M1 | DC01 | 712 | 4919014592 |  | 2011-04-04 00:00:00 | 4 | 27 | 273 | 3 | 9 | 91 | 4.81
1024135 | NAIL SHINER BIG M1 | DC01 | 711 | 4919043618 |  | 2011-04-06 00:00:00 | 4 | -1299 | 273 | 3 | -433 | 91 | -231.42
1024135 | NAIL SHINER BIG M1 | DC01 | 712 | 4919043618 |  | 2011-04-06 00:00:00 | 4 | 1296 | 273 | 3 | 432 | 91 | 230.88
1086016 | PADS ORGANIC COTTON SQUARE AX | DC01 | 712 | 4918150836 |  | 2011-01-24 00:00:00 | 1 | 36 | 6 | 6 | 6 | 1 | 18.36
1086016 | PADS ORGANIC COTTON SQUARE AX | DC01 | 711 | 4918189510 |  | 2011-01-27 00:00:00 | 1 | -6 | 6 | 6 | -1 | 1 | -3.06
1086016 | PADS ORGANIC COTTON SQUARE AX | DC01 | 711 | 4918764762 |  | 2011-03-15 00:00:00 | 3 | -24 | 6 | 6 | -4 | 1 | -12.24
1086016 | PADS ORGANIC COTTON SQUARE AX | DC01 | 711 | 4918782707 |  | 2011-03-16 00:00:00 | 3 | -24 | 6 | 6 | -4 | 1 | -12.24
1086016 | PADS ORGANIC COTTON SQUARE AX | DC01 | 712 | 4919030144 |  | 2011-04-05 00:00:00 | 4 | 24 | 6 | 6 | 4 | 1 | 12.24
1082867 | PILLOW MIST ENERGY 100ML A0 | DC01 | 711 | 4918120761 |  | 2011-01-21 00:00:00 | 1 | -12 | -150 | 6 | -2 | -25 | -13.86
1082867 | PILLOW MIST ENERGY 100ML A0 | DC01 | 712 | 4918849121 |  | 2011-03-21 00:00:00 | 3 | 30 | -150 | 6 | 5 | -25 | 34.65
1082867 | PILLOW MIST ENERGY 100ML A0 | DC01 | 711 | 4919027250 |  | 2011-04-05 00:00:00 | 4 | -60 | -150 | 6 | -10 | -25 | -69.3
1082867 | PILLOW MIST ENERGY 100ML A0 | DC01 | 711 | 4919030144 |  | 2011-04-05 00:00:00 | 4 | -246 | -150 | 6 | -41 | -25 | -284.13
1082867 | PILLOW MIST ENERGY 100ML A0 | DC01 | 711 | 4919030144 |  | 2011-04-05 00:00:00 | 4 | -720 | -150 | 6 | -120 | -25 | -831.6
1082867 | PILLOW MIST ENERGY 100ML A0 | DC01 | 712 | 4919029005 |  | 2011-04-05 00:00:00 | 4 | 798 | -150 | 6 | 133 | -25 | 921.69
1082867 | PILLOW MIST ENERGY 100ML A0 | DC01 | 712 | 4919027250 |  | 2011-04-05 00:00:00 | 4 | 60 | -150 | 6 | 10 | -25 | 69.3
1048407 | PORE PERFECTOR SEAWEED 15ML A0 | DC01 | 712 | 4918417367 |  | 2011-02-15 00:00:00 | 2 | 24 | 36 | 6 | 4 | 6 | 20.48
1048407 | PORE PERFECTOR SEAWEED 15ML A0 | DC01 | 711 | 4918490923 |  | 2011-02-21 00:00:00 | 2 | -48 | 36 | 6 | -8 | 6 | -41.02
1048407 | PORE PERFECTOR SEAWEED 15ML A0 | DC01 | 712 | 4918596577 |  | 2011-03-01 00:00:00 | 3 | 84 | 36 | 6 | 14 | 6 | 71.79
1048407 | PORE PERFECTOR SEAWEED 15ML A0 | DC01 | 711 | 4918975699 |  | 2011-03-31 00:00:00 | 3 | -12 | 36 | 6 | -2 | 6 | -10.25
1048407 | PORE PERFECTOR SEAWEED 15ML A0 | DC01 | 711 | 4918969307 |  | 2011-03-31 00:00:00 | 3 | -30 | 36 | 6 | -5 | 6 | -25.64
1048407 | PORE PERFECTOR SEAWEED 15ML A0 | DC01 | 712 | 4919014340 |  | 2011-04-04 00:00:00 | 4 | 12 | 36 | 6 | 2 | 6 | 10.25
1048407 | PORE PERFECTOR SEAWEED 15ML A0 | DC01 | 714 | 4919054515 |  | 2011-04-07 00:00:00 | 4 | 6 | 36 | 6 | 1 | 6 | 5.12
1082862 | PULSE [NAME] SLEEP 15ML A55 | DC01 | 712 | 4918076527 |  | 2011-01-18 00:00:00 | 1 | 42 | -132 | 6 | 7 | -22 | 38.34
1082862 | PULSE [NAME] SLEEP 15ML A55 | DC01 | 712 | 4918104752 |  | 2011-01-20 00:00:00 | 1 | 6 | -132 | 6 | 1 | -22 | 5.48
1082862 | PULSE [NAME] SLEEP 15ML A55 | DC01 | 711 | 4918897996 |  | 2011-03-25 00:00:00 | 3 | -180 | -132 | 6 | -30 | -22 | -159.88
1082862 | PULSE [NAME] SLEEP 15ML A55 | DC01 | 712 | 4918930163 |  | 2011-03-28 00:00:00 | 3 | 12 | -132 | 6 | 2 | -22 | 10.66
1082862 | PULSE [NAME] SLEEP 15ML A55 | DC01 | 711 | 4919014340 |  | 2011-04-04 00:00:00 | 4 | -12 | -132 | 6 | -2 | -22 | -10.66
1082951 | RD [NAME] 125ML AX | DC01 | 711 | 4918119726 |  | 2011-01-21 00:00:00 | 1 | -162 | -12 | #N/A | #N/A | #N/A | -458.95
1082951 | RD [NAME] 125ML AX | DC01 | 712 | 4918119724 |  | 2011-01-21 00:00:00 | 1 | 150 | -12 | #N/A | #N/A | #N/A | 424.95
1082951 | RD [NAME] 125ML AX | DC01 | 711 | 4918352501 |  | 2011-02-09 00:00:00 | 2 | -6 | -12 | #N/A | #N/A | #N/A | -16.75
1082951 | RD [NAME] 125ML AX | DC01 | 712 | 4919010928 |  | 2011-04-04 00:00:00 | 4 | 6 | -12 | #N/A | #N/A | #N/A | 16.66
1084656 | SACHET SERUM NATRULIFT 1.5ML A0N | DC01 | 711 | 4918257572 |  | 2011-02-01 00:00:00 | 2 | -320 | -280 | 20 | -16 | -14 | -33.4
1084656 | SACHET SERUM NATRULIFT 1.5ML A0N | DC01 | 712 | 4918795410 |  | 2011-03-17 00:00:00 | 3 | 40 | -280 | 20 | 2 | -14 | 4.17
1084656 | SACHET SERUM NATRULIFT 1.5ML A0N | DC01 | 712 | 4918849121 |  | 2011-03-21 00:00:00 | 3 | 80 | -280 | 20 | 4 | -14 | 8.35
1084656 | SACHET SERUM NATRULIFT 1.5ML A0N | DC01 | 711 | 4919043617 |  | 2011-04-06 00:00:00 | 4 | -80 | -280 | 20 | -4 | -14 | -8.35
1058363 | SERUM WHITENING MOISTURE WHITE 30ML A36 | DC01 | 712 | 4918664406 |  | 2011-03-07 00:00:00 | 3 | 18 | -6 | 6 | 3 | -1 | 71.15
1058363 | SERUM WHITENING MOISTURE WHITE 30ML A36 | DC01 | 711 | 4918944671 |  | 2011-03-29 00:00:00 | 3 | -6 | -6 | 6 | -1 | -1 | -23.72
1058363 | SERUM WHITENING MOISTURE WHITE 30ML A36 | DC01 | 711 | 4919014592 |  | 2011-04-04 00:00:00 | 4 | -18 | -6 | 6 | -3 | -1 | -71.15
1084991 | SHAMPOO OIL BALANCE 60ML A0 | DC01 | 711 | 4918592426 |  | 2011-03-01 00:00:00 | 3 | -6 | -6 | 6 | -1 | -1 | -3.23
1084991 | SHAMPOO OIL BALANCE 60ML A0 | DC01 | 711 | 4919014594 |  | 2011-04-04 00:00:00 | 4 | -60 | -6 | 6 | -10 | -1 | -32.27
1084991 | SHAMPOO OIL BALANCE 60ML A0 | DC01 | 712 | 4919030145 |  | 2011-04-05 00:00:00 | 4 | 60 | -6 | 6 | 10 | -1 | 32.27
1034888 | SHAMPOO VLMSG GUARANA BERRY 250ML A0 | DC01 | 711 | 4918322951 |  | 2011-02-07 00:00:00 | 2 | -12 | -2514 | 6 | -2 | -419 | -8.46
1034888 | SHAMPOO VLMSG GUARANA BERRY 250ML A0 | DC01 | 711 | 4918746891 |  | 2011-03-14 00:00:00 | 3 | -6 | -2514 | 6 | -1 | -419 | -4.24
1034888 | SHAMPOO VLMSG GUARANA BERRY 250ML A0 | DC01 | 711 | 4919049546 |  | 2011-04-07 00:00:00 | 4 | -2496 | -2514 | 6 | -416 | -419 | -1762.68
1030588 | SHIMMER CUBE PALETTE 07 16G A0 | DC01 | 712 | 4918364361 |  | 2011-02-10 00:00:00 | 2 | 3 | -24 | 3 | 1 | -8 | 7.61
1030588 | SHIMMER CUBE PALETTE 07 16G A0 | DC01 | 711 | 4918848026 |  | 2011-03-21 00:00:00 | 3 | -12 | -24 | 3 | -4 | -8 | -30.87
1030588 | SHIMMER CUBE PALETTE 07 16G A0 | DC01 | 711 | 4918889324 |  | 2011-03-24 00:00:00 | 3 | -48 | -24 | 3 | -16 | -8 | -122.67
1030588 | SHIMMER CUBE PALETTE 07 16G A0 | DC01 | 711 | 4918889324 |  | 2011-03-24 00:00:00 | 3 | -78 | -24 | 3 | -26 | -8 | -199.34
1030588 | SHIMMER CUBE PALETTE 07 16G A0 | DC01 | 712 | 4919043617 |  | 2011-04-06 00:00:00 | 4 | 102 | -24 | 3 | 34 | -8 | 260.67
1030588 | SHIMMER CUBE PALETTE 07 16G A0 | DC01 | 712 | 4919043612 |  | 2011-04-06 00:00:00 | 4 | 9 | -24 | 3 | 3 | -8 | 23
1058344 | SHIMMER CUBES 18 14G A0 | DC01 | 711 | 4918538060 |  | 2011-02-24 00:00:00 | 2 | -6 | -21 | 3 | -2 | -7 | -16.69
1058344 | SHIMMER CUBES 18 14G A0 | DC01 | 711 | 4918876164 |  | 2011-03-23 00:00:00 | 3 | -3 | -21 | 3 | -1 | -7 | -8.34
1058344 | SHIMMER CUBES 18 14G A0 | DC01 | 711 | 4918958134 |  | 2011-03-30 00:00:00 | 3 | -21 | -21 | 3 | -7 | -7 | -58.41
1058344 | SHIMMER CUBES 18 14G A0 | DC01 | 712 | 4919039914 |  | 2011-04-06 00:00:00 | 4 | 9 | -21 | 3 | 3 | -7 | 25.03
1086642 | SHOWER GEL LEMON 250ML A0 | DC01 | 711 | 4918339227 |  | 2011-02-08 00:00:00 | 2 | -72 | -90 | 6 | -12 | -15 | -36.99
1086642 | SHOWER GEL LEMON 250ML A0 | DC01 | 712 | 4918339211 |  | 2011-02-08 00:00:00 | 2 | 66 | -90 | 6 | 11 | -15 | 33.91
1086642 | SHOWER GEL LEMON 250ML A0 | DC01 | 711 | 4918375812 |  | 2011-02-11 00:00:00 | 2 | -60 | -90 | 6 | -10 | -15 | -31.22
1086642 | SHOWER GEL LEMON 250ML A0 | DC01 | 711 | 4918778320 |  | 2011-03-16 00:00:00 | 3 | -24 | -90 | 6 | -4 | -15 | -12.53
1086642 | SHOWER GEL LEMON 250ML A0 | DC01 | 711 | 4919054515 |  | 2011-04-07 00:00:00 | 4 | -96 | -90 | 6 | -16 | -15 | -50.43
1086642 | SHOWER GEL LEMON 250ML A0 | DC01 | 712 | 4919054515 |  | 2011-04-07 00:00:00 | 4 | 96 | -90 | 6 | 16 | -15 | 50.43
1088404 | SHOWER GEL WHITE MUSK BLUSH 250ML A0 | DC01 | 711 | 4918758837 |  | 2011-03-15 00:00:00 | 3 | -42 | 36 | 6 | -7 | 6 | -23.3
1088404 | SHOWER GEL WHITE MUSK BLUSH 250ML A0 | DC01 | 711 | 4918763122 |  | 2011-03-15 00:00:00 | 3 | -6 | 36 | 6 | -1 | 6 | -3.33
1088404 | SHOWER GEL WHITE MUSK BLUSH 250ML A0 | DC01 | 712 | 4918778320 |  | 2011-03-16 00:00:00 | 3 | 78 | 36 | 6 | 13 | 6 | 43.28
1088404 | SHOWER GEL WHITE MUSK BLUSH 250ML A0 | DC01 | 712 | 4919039915 |  | 2011-04-06 00:00:00 | 4 | 6 | 36 | 6 | 1 | 6 | 3.33
1058621 | SOAP COCONUT 100G A0 | DC01 | 711 | 4918194169 |  | 2011-01-27 00:00:00 | 1 | -48 | -1044 | 12 | -4 | -87 | -17.22
1058621 | SOAP COCONUT 100G A0 | DC01 | 711 | 4918260979 |  | 2011-02-01 00:00:00 | 2 | -36 | -1044 | 12 | -3 | -87 | -12.89
1058621 | SOAP COCONUT 100G A0 | DC01 | 711 | 4918682579 |  | 2011-03-08 00:00:00 | 3 | -936 | -1044 | 12 | -78 | -87 | -334.28
1058621 | SOAP COCONUT 100G A0 | DC01 | 711 | 4919013837 |  | 2011-04-04 00:00:00 | 4 | -24 | -1044 | 12 | -2 | -87 | -8.57
1085389 | STAFF ACCESSORY RAINFOREST A0 | DC01 | 711 | 4918266461 |  | 2011-02-01 00:00:00 | 2 | -4 | -24 | 1 | -4 | -24 | -2.4
1085389 | STAFF ACCESSORY RAINFOREST A0 | DC01 | 711 | 4919030145 |  | 2011-04-05 00:00:00 | 4 | -20 | -24 | 1 | -20 | -24 | -12.02
1089926 | WOODWOOL NATURAL SS11 A0 | DC01 | 711 | 4918266461 |  | 2011-02-01 00:00:00 | 2 | -5 | -5 | 1 | -5 | -5 | -39.42
1089926 | WOODWOOL NATURAL SS11 A0 | DC01 | 711 | 4919027250 |  | 2011-04-05 00:00:00 | 4 | -18 | -5 | 1 | -18 | -5 | -142.04
1089926 | WOODWOOL NATURAL SS11 A0 | DC01 | 712 | 4919027250 |  | 2011-04-05 00:00:00 | 4 | 18 | -5 | 1 | 18 | -5 | 142.04