Spreadsheet: 682437d1592098154-sumif-depending-on-a-data-validation-amendedinventory
Sheet: Master Inventory

MARCH-MAY
ITEM NAME | SIZE | Qty | ORIG PRICE | SELL PRICE | SF AMOUNT | SF SHOULDERED BY | PROFIT | LABEL
Adidas Athletics Steal Blue | 8.5 | 1 | 1387.5
Adidas Athletics Teal | 8 | 1 | 1500
Adidas Athletics Teal | 8 | 1 | 1500
Air Huarache [NAME] | 8.5 | 1 | 2923
Air Huarache [NAME] | 9 | 1 | 2923
Air Huarache [NAME] | 10 | 1 | 2923 | 3300 | 100 | SELLER | 277 | SOLD
Alpha Bounce Dark Gray | 9 | 1 | 1600 | 2000 | 182 | BUYER | 400 | SOLD | WILLIAM YAP
Alpha Bounce Maroon Comb White | 7.5 | 1 | 1295
Alpha Bounce Maroon Comb White | 7.5 | 1 | 1295
Arkyn Cargo | 6.5 | 1 | 2000 |  |  |  |  | SOLD
Arkyn Cargo | 5.5 | 1 | 2000
Arkyn Cargo | 8 | 1 | 2000 | 2900 | 130 | BUYER | 770
[NAME] | 5.5 | 1 | 1942.5
[NAME] | 5.5 | 1 | 1942.5
Crazy Train Lt M Gray | 6.5 | 1 | 3330
Gazelle Red | 8 | 1 | 2000 | 2000 | 0 | N/A | 0
[NAME] | 6.5 | 1 | 1295 | 1500 | 95 | BUYER | 205 | RESERVED
Gazelle Royal Blue | 6 | 1 | 1295 | 2500 | 385 | SELLER | 820 | SOLD | CINDY GONZALO
Gazelle Royal Blue | 8.5 | 1 | 1295 | C/O Paolo | C/O Paolo | N/A | C/O Paolo |  | C/O Paolo
POD-S3 W Lavender | 5.5 | 1 | 1850
POD-S3 W Lavender | 6 | 1 | 1850 | 1200 | 0 | BUYER | -650 |  | MARIELLE SANGUEZA
[NAME] x Trainer Blue/White Straps | 7.5 | 1 | 2220
[NAME] x Trainer Blue/White Straps | 7 | 1 | 2220
[NAME] x Trainer Blue/White Straps | 6 | 1 | 2220
[NAME] x Trainer Blue/White Straps | 8 | 1 | 2220
Solar Boost Weaving M Black/Orange | 9.5 | 1 | 6105
Solar Boost Weaving M Black/Orange | 9.5 | 1 | 6105
Solar Glide M Gray/Red | 8 | 1 | 1850 | 2000 | 0 | N/A | 150 |  | WILLIAM YAP
Solar Glide M Gray/Red | 8 | 1 | 1850
Solar Glide M Gray/Red | 8 | 1 | 1850
Solar Glide M Gray/Red | 8 | 1 | 1850 |  |  |  |  | SOLD
Solar Glide M Gray/Red | 10 | 1 | 1850
Solar Glide M Gray/Red | 10 | 1 | 1850 |  |  |  |  | SOLD
Solar Glide ST W Blue | 7 | 1 | 1800
Solar Glide ST W Blue | 7 | 1
Solar Glide ST W Blue | 7.5 | 1
Solar Glide ST W Blue | 7.5 | 1
Solar Glide ST W Blue | 7.5 | 1 | 1800
[NAME] | 7 | 1 | 1480 | 2000 | 110 | SELLER | 410 |  | JOESA TORRES
[NAME] | 7 | 1 | 1480 | 1300 | 0 | N/A | -180 | SOLD | CINDY GONZALO
Tubular Shadow W Black | 5 | 1 | 1572.5
Tubular Shadow W Black | 6 | 1 | 1572.5 | 2300 | 0 | N/A | 728 |  | MARIELLE SANGUEZA
Tubular Shadow W Black | 6 | 1 | 1572.5
Tubular Shadow W Black | 6 | 1 | 1572.5
Tubular Shadow W Black | 7 | 1 | 1572.5
Tubular Shadow W Black | 7.5 | 1 | 1572.5
Tubular Shadow W Black | 8 | 1 | 1572.5
Tubular Shadow W Black | 6.5 | 1 | 1572.5 | 2500 | 115 | SELLER | 812.5 |  | RADLEY GRANT DONEZA
Tubular Shadow W Black | 6.5 | 1 | 1572.5
UltraBoost Black Carbon Ash | 9.5 | 1 | 5180
UltraBoost Blue | 10 | 1 | 5180
UltraBoost Laceless Mint | 8.5 | 1 | 5180
UltraBoost x [NAME] | 8.5 | 1 | 3145
UltraBoost x [NAME] | 5.5 | 1 | 3145
Vans  x [NAME] | 8 | 1 | 2923 | 4000 | 130 | SELLER | 947 | SOLD | ARVIN JAY SOSA
Vans  x [NAME] | 8 | 1 | 2923 |  |  |  |  | SOLD
Vans x Perlicue Pink | 8 | 1 | 2923 | 3000 | 120 | BUYER | 77 | SOLD | GABRIELLE SAN PEDRO
ZX 500 RM | 10 | 1 | 5180
EQT Support 91/48 | 9 | 1 | 4625
Nike Exp - Z07 SE | 8 | 1 | 2183
Nike Exp - Z07 SE | 9.5 | 1 | 2183
[NAME] | 8 | 1 | 4070
[NAME] | 8 | 1 | 4070
[NAME] | 8 | 1 | 4070
[NAME] | 8 | 1 | 4070
[NAME] | 8 | 1 | 4070
[NAME] | 8 | 1 | 4070
[NAME] | 8 | 1 | 4070
[NAME] | 8 | 1 | 4070
[NAME] | 8.5 | 1 | 4070
[NAME] | 8.5 | 1 | 4070
[NAME] | 8.5 | 1 | 4070
[NAME] | 8.5 | 1 | 4070
[NAME] | 8.5 | 1 | 4070
[NAME] | 8.5 | 1 | 4070
[NAME] | 8.5 | 1 | 4070
[NAME] | 9 | 1 | 4070
[NAME] | 9 | 1 | 4070
[NAME] | 9 | 1 | 4070
[NAME] | 9 | 1 | 4070
[NAME] | 9 | 1 | 4070
[NAME] | 9 | 1 | 4070
[NAME] | 10 | 1 | 4070
[NAME] | 10 | 1 | 4070
[NAME] | Qty | SALE PRICE | SELL PRICE |  |  |  |  | LABEL
BP CL Adicolor Navy | 1 | 1480 | 2480
Hershel Sixteen Hip Pack Navy | 1 | 1774 | 2000
Nike Heritage BP 21L | 1 | 703 | 1000
Adidas BP Camo | 1 | 4440 | 5000
Adidas BP Camo | 1 | 4440
[NAME] | 1 | 2800 | 3000 |  |  |  |  | SOLD | 1
[NAME] | 1 | 2800
Clothes | SIZE | Qty | SALE PRICE |  |  |  |  | LABEL
Adidas Real 3 JSY Red | XL | 1 | 1017.5
Adidas Real 3 JSY Red | L | 1 | 1017.5
Adidas Real H JSY White | 2XL | 1 | 1017.5 |  |  |  |  | SOLD
Adidas Real H Preshi Stone | S | 1 | 693.75
Adidas Real H Preshi Stone | M | 1 | 693.75 |  |  |  |  | SOLD
Jordan JDK STRETCH Black | L | 1 | 600 |  |  |  |  | SOLD
Jordan JDK STRETCH Black | L | 1 | 600
Jordan JDK STRETCH Black | L | 1 | 600
Jordan JDK Jordan Camo White | L | 1 | 600 |  |  |  |  | SOLD
Jordan JDK Jordan Camo White | L | 1 | 600
Jordan JDK Jordan Camo White | XL | 1 | 600 |  |  |  |  | SOLD
Jordan Flight Black | L | 1 | 600 |  |  |  |  | SOLD
Jordan Flight Black | L | 1 | 600
[NAME] | L | 1 | 600 |  |  |  |  | SOLD
[NAME] | L | 1 | 600
Jordan JDK 23 Drive Tee | M | 1 | 600 |  |  |  |  | SOLD
Jordan JDK 23 Drive Tee | M | 1 | 600
Adidas Real H Short White | M | 1 | 480 |  |  |  |  | SOLD
[NAME] Short Black | XL | 1 | 500 |  |  |  |  | SOLD
[NAME] Short Black | XL | 1 | 500
Adidas Real LIC TOP Red | L | 1 | 925
Adidas MUFC ZNE H JKT Red | M | 1 | 925
Adidas MUFC ZNE H JKT Red | M | 1 | 925 |  |  |  |  | SOLD
CAPS | SIZE | Qty | SALE PRICE |  |  |  |  | LABEL
Nike SB Cap | 1 size | 1 | 370
Nike SB Cap | 1 size | 1 | 370
Nike SB Cap | 1 size | 1 | 370 |  |  |  |  | SOLD
New Era Cap Black | 1 size | 1 | 800 |  |  |  |  | SOLD
New Era Cap Red | 1 size | 1 | 800 |  |  |  |  | SOLD
Nike Pro Black | 1 size | 1 | 800
Nike Pro Black | 1 size | 1 | 800 |  |  |  |  | SOLD
Nike Pro Grey | 1 size | 1 | 800 |  |  |  |  | SOLD
Nike Pro Grey | 2 size | 1 | 800