Spreadsheet: 285432d1387604294-formula-to-fill-blank-cell-sample2
Sheet: sample

Lot Expiration Date | Item Number | Des | [NAME] | Total
2014-01-22 00:00:00 | EGGOMEGA | OMEGA EGGS 60 TRAYS X 6 EGGS | 1x60 tray | 88.05
 | EGGSDHA | DHA EGGS 60 TRAYS X 6 EGGS | 1x60 tray | 89.3
 | EGSELENIUM | SELENIUM EGGS 60 TRAYS X 6 EGGS | 1x60 tray | 89.32
2014-04-20 00:00:00 | FCHIWP0008 | [NAME] IN BOX | 12X900 GM | 52
2014-05-04 00:00:00 | FCHIWP0008 | [NAME] IN BOX | 12X900 GM | 252
2014-05-11 00:00:00 | FCHIWP0008 | [NAME] IN BOX | 12X900 GM | 271.59
2014-05-18 00:00:00 | FCHIW800GM | [NAME] IN BOX | 12x800 gm | 160
 | PROC004 | WHOLE CHICKEN 800GMX2 | 6X2X800G | 16.67
2014-05-19 00:00:00 | FCHIW00987 | [NAME] GMX12 CHICKEN IN BOX | 12X1000 GM | 657.58
 | FCHIW00989 | [NAME] GMX10 CHICKEN IN BOX | 10X1200 GM | 662
 | PROC003 | WHOLE CHICKEN 1000GM X 2 | 6X2X1000G | 122.5
 | PROC005 | WHOLE CHICKEN 1100 GM + 1200 GM | 5x2x(1100+1200) | 29
2014-05-26 00:00:00 | FCHIW00987 | [NAME] GMX12 CHICKEN IN BOX | 12X1000 GM | 272
 | FCHIW00989 | [NAME] GMX10 CHICKEN IN BOX | 10X1200 GM | 277
2014-06-01 00:00:00 | MINTAORIG | MINTA ORIGINAL | 1 CR X 24 UNITS | 2458.21
2014-06-09 00:00:00 | FCHIW00998 | [NAME] 1100 [NAME] IN BOX | 10X1100 GM | 1886.8
 | PROC005 | WHOLE CHICKEN 1100 GM + 1200 GM | 5x2x(1100+1200) | 100
2014-06-19 00:00:00 | 1LVER+1GIZ | 1 LIVER + 1 GIZZARD SPECIAL PRICE | (1+1)X9X450GM | 289.22
 | FCHIBR0001 | [NAME] 900 gm | 8X900 GM | 5.38
 | FCHICB0632 | [NAME] 500 gr bag for Singapore | 14X500 GM | 436.71
 | FCHICP0010 | [NAME] POPCORN 280 GR | 14X280 GM | 221.22
 | FCHIDR0002 | [NAME] GM | 8X900 GM | 181.29
 | FCHIFR0712 | [NAME] 340 gm | 24X340 GM | 0.96
 | FCHIGI0007 | [NAME] 450 GM | 18X450 GM | 196.68
 | FCHIKN0009 | [NAME] 280 GR | 14X280 GM | 281.64
 | FCHILI0006 | [NAME] 450 GM | 18X450 GM | 46.11
 | FCHILQ0004 | [NAME] QUARTER 900 GM | 8X900 GM | 558.14
 | FCHITH0003 | [NAME] THIGH 900 GM | 8X900 GM | 470.77
 | FCHIWI0005 | [NAME] GM | 8X900 GM | 101.26
 | FCNUGG0982 | [NAME] GR | 12X440 GM | 53.25
 | FMEATB0466 | [NAME] 450 GM | 12X450 GM | 748.5
 | PROB001 | [NAME] GM SINGLE PACK SPECIAL PRICE | 8X900G | 2.5
 | PRODR001 | [NAME] 900GM | 4X2X900 GM | 0.5
 | PROG001 | [NAME] 450 GM TWIN PACK SPECIAL PRICE | 9X2X450G | 4.890000000000001
 | PROL001 | [NAME] 450 GM TWIN PACK SPECIAL PRICE | 9X2X450G | 4.890000000000001
 | PROMB001 | CHICKEN MEATBALL 450 GM X 2 | 6X2X440GM | 66.66
 | PROMP001 | MEAT BALLS 450GM + CHKN CRISPY POPCORN 280GM | 6X2X450G+280G | 2
 | PRONUG001 | [NAME]  440gm | 6X2X440 GM | 31
 | PRONUG002 | [NAME]  440gm | 6X2X440 GM | 22
 | PRONUG003 | CHKN NUGGETS 440GM + CHKN KIDS NUGGETS | 6X2X440G+280G | 5
 | PRONUG004 | NUGGETS 440G 1+ 1 FREE | 6X2X440GM | 44
 | PRONUG006 | CHICKEN NUGGETS 440GM X 2 | 6X2X440GM | 46.67
 | PRONUG007 | KIDS NUGGETS 280 GM X 2 | 7x2x280gm | 74.28
 | PROPOP001 | [NAME] POPCORN | 7X2X280 GM | 33.14
 | PROPOP002 | CRISPY POPCORN 1 + 1 FREE | 7X2X280 GM | 49.14
 | PROPOP003 | CRISPY POPCORN 280 GM X 2 | 7x2x280gm | 5
2014-06-22 00:00:00 | FCHIW800GM | [NAME] IN BOX | 12x800 gm | 1029.92
 | FCHIWP0008 | [NAME] IN BOX | 12X900 GM | 248
 | PROC004 | WHOLE CHICKEN 800GMX2 | 6X2X800G | 30
2014-07-01 00:00:00 | 900TWINPCK | WHOLE CHICKEN 900GM TWIN PACK SPECIAL PRICE | 2X6X900GM | 81.83
 | FCHIWP0008 | [NAME] IN BOX | 12X900 GM | 0.42
2014-07-06 00:00:00 | FCHIWP0008 | [NAME] IN BOX | 12X900 GM | 113.67
2014-07-07 00:00:00 | FCHIW00987 | [NAME] GMX12 CHICKEN IN BOX | 12X1000 GM | 240
2014-07-12 00:00:00 | FCHICB0632 | [NAME] 500 gr bag for Singapore | 14X500 GM | 800
 | FCHICP0010 | [NAME] POPCORN 280 GR | 14X280 GM | 801
 | FCHIFR0712 | [NAME] 340 gm | 24X340 GM | 3841.33
 | FCHIKN0009 | [NAME] 280 GR | 14X280 GM | 936
 | FCNUGG0982 | [NAME] GR | 12X440 GM | 883
 | FMEATB0466 | [NAME] 450 GM | 12X450 GM | 949
 | PRONUG006 | CHICKEN NUGGETS 440GM X 2 | 6X2X440GM | 18.34
 | PROPOP003 | CRISPY POPCORN 280 GM X 2 | 7x2x280gm | 56.43
2014-07-13 00:00:00 | FCHIFR0712 | [NAME] 340 gm | 24X340 GM | 3426
2014-07-14 00:00:00 | 900TWINPCK | WHOLE CHICKEN 900GM TWIN PACK SPECIAL PRICE | 2X6X900GM | 17.67
 | FCHIW00987 | [NAME] GMX12 CHICKEN IN BOX | 12X1000 GM | 1
 | FCHIW00989 | [NAME] GMX10 CHICKEN IN BOX | 10X1200 GM | 389
 | FCHIWP0008 | [NAME] IN BOX | 12X900 GM | 207
2014-07-20 00:00:00 | FCHIW00989 | [NAME] GMX10 CHICKEN IN BOX | 10X1200 GM | 348
2014-07-27 00:00:00 | FCHIW00987 | [NAME] GMX12 CHICKEN IN BOX | 12X1000 GM | 674
 | FCHIW800GM | [NAME] IN BOX | 12x800 gm | 438
 | FCHIWP0008 | [NAME] IN BOX | 12X900 GM | 729
2014-08-03 00:00:00 | FCHICB0632 | [NAME] 500 gr bag for Singapore | 14X500 GM | 347
 | FCHICP0010 | [NAME] POPCORN 280 GR | 14X280 GM | 425.29
 | FCHIKN0009 | [NAME] 280 GR | 14X280 GM | 469.21
 | FCNUGG0982 | [NAME] GR | 12X440 GM | 479.17
2014-08-18 00:00:00 | FCHIW00990 | [NAME] GMX10 CHICKEN IN BOX | 10X1300 GM | 950.9
 | FCHIW00991 | [NAME] 1400 [NAME] IN BOX | 10X1400 GM | 877.1
2014-09-01 00:00:00 | ORGAPRI967 | CROFTER PREMIUM SPREAD APRICOT ORGANIC | 2X6X283GM | 374.5
 | ORGCHERY43 | CROFTER PREMIUM  SPREAD MORELLO CHERRY ORGANIC | 2X6X283GM | 182.58
 | ORGRASP920 | CROFTER PREMIUM SPREAD RASPBERRY ORGANIC | 2X6X283GM | 374.5
 | ORGSTRAW13 | CROFTER  PREMIUM SPREAD STRAWBERRY ORGANIC | 2X6X283GM | 548.67
2014-09-10 00:00:00 | [NAME] | RAVIKA EXTRA VIRGIN OLIVE OIL WITH CHILI 250 ML | 12x250ml | -5
2014-09-25 00:00:00 | 11001GET1 | WHOLE CHICKEN 1100GM TWIN PACK BUY 1 GET 1 FREE | 2X6X1100GM | 10.67
2014-09-26 00:00:00 | FR2+1UNION | CHICKEN FRANKS 2+1 UNION | 3X12X340GM | 12.5
 | FRANKSC4 | CHICKEN FRANKS 2+1 C4 | 3X12X340GM | 916
2014-11-05 00:00:00 | GIZEPAC750 | GIZE PINEAPPLE COCONUT 750 ML | 6x750 ml | 116
 | GIZEPV750 | GIZE PEAR - VINEGAR 750 ML | 6x750 ml | 116
 | GIZERAS750 | GIZE RASPBERRY GINSENG 750 ML | 6x750 ml | 116
2014-11-08 00:00:00 | GIZEPAC200 | GIZE PINEAPPLE COCONUT 200 ML | 12x200 ml | 169
 | GIZEPV200 | GIZE PEAR - VINEGAR 200 ML | 12x200 ml | 172
 | GIZERAS200 | GIZE RASPBERRY GINSENG 200 ML | 12x200 ml | 172.17
2014-11-30 00:00:00 | WHYNATTE01 | WHYNATTE LATTE | 24x240ml | 1910.83
 | WHYNATTE02 | WHYNATTE LATTE 6 BOXES 4 UNITS | 1 CR X 6BX X 4UN | 640
2015-01-01 00:00:00 | ORGAPRI967 | CROFTER PREMIUM SPREAD APRICOT ORGANIC | 2X6X283GM | 282
 | ORGBLAC936 | CROFTERS PREMIUM BLACKBERRY ORGANIC | 2X6X283GM | 178
 | ORGBLUE950 | CROFTERS PREMIUM BLUEBERRY ORGANIC | 2X6X283GM | 269
 | ORGCHERY43 | CROFTER PREMIUM  SPREAD MORELLO CHERRY ORGANIC | 2X6X283GM | 168
 | ORGMANGO75 | CROFTERS PREMIUM MANGO ORGANIC | 2X6X283GM | 269
 | ORGRASP920 | CROFTER PREMIUM SPREAD RASPBERRY ORGANIC | 2X6X283GM | 281
 | ORGSTRAW13 | CROFTER  PREMIUM SPREAD STRAWBERRY ORGANIC | 2X6X283GM | 390
2015-04-25 00:00:00 | GIZESPARK7 | GIZE SPARKLING 750 ML | 6x750 ml | 348
2015-05-01 00:00:00 | PRSELA20KG | PRESIDENT SELLA 1121 CREAM SELLA 20 KG | 20 KG | 1041.45
 | QILLAG1KG | QILLA GOLD 1121 STEAMED BASMATI RICE 1 KG | 20X1KG | 30.9
 | QILLAG20KG | QILLA GOLD 1121 STEAMED BASMATI RICE 20 KG | 2O KG | -11
 | [NAME] | QILLA GOLD 1121 STEAMED BASMATI RICE 5 KG | 4X5KG | 195.25
2015-06-01 00:00:00 | PROQ003 | QILLA GOLD STEAMED BASMATI RICE 5KG+2KG | 4X5KG+2KG | 23.75
 | PROQILLA5 | QILLA GOLD BASMATI RICE | 4X5KG | 0.25
 | QILLAG1KG | QILLA GOLD 1121 STEAMED BASMATI RICE 1 KG | 20X1KG | 184.6
 | QILLAG20KG | QILLA GOLD 1121 STEAMED BASMATI RICE 20 KG | 2O KG | 16
 | [NAME] | QILLA GOLD 1121 STEAMED BASMATI RICE 5 KG | 4X5KG | 3
2015-07-31 00:00:00 | GIZE750ML | GIZE STILL 750 ML | 6x750 ml | 464
2015-08-01 00:00:00 | QILLAG20KG | QILLA GOLD 1121 STEAMED BASMATI RICE 20 KG | 2O KG | 484
 | [NAME] | QILLA GOLD 1121 STEAMED BASMATI RICE 5 KG | 4X5KG | 250
2015-08-07 00:00:00 | GIZE200ML | GIZE STILL 200 ML | 12x200 ml | 695.17
 | GIZESPARK2 | GIZE SPARKLING 200ML | 12x200 ml | 696
2015-08-13 00:00:00 | SOLMTEORIG | SOL MATE ORIGINAL | 12x330 ml | 1050
2015-08-14 00:00:00 | SOLMTEORIG | SOL MATE ORIGINAL | 12x330 ml | 892.67
2015-08-15 00:00:00 | SOLMTEORIG | SOL MATE ORIGINAL | 12x330 ml | 1049
2015-08-19 00:00:00 | SOLMTEORIG | SOL MATE ORIGINAL | 12x330 ml | 150
2015-08-20 00:00:00 | SOLMTELIME | SOL MATE LEMON/LIME | 12x330 ml | 3141.58
2015-08-25 00:00:00 | GIZE200ML | GIZE STILL 200 ML | 12x200 ml | 0.58
 | GIZE750ML | GIZE STILL 750 ML | 6x750 ml | 5
 | GIZEPAC200 | GIZE PINEAPPLE COCONUT 200 ML | 12x200 ml | 3.67
 | GIZEPAC750 | GIZE PINEAPPLE COCONUT 750 ML | 6x750 ml | 4.67
 | GIZEPV200 | GIZE PEAR - VINEGAR 200 ML | 12x200 ml | 1.83
 | GIZEPV750 | GIZE PEAR - VINEGAR 750 ML | 6x750 ml | 4.83
 | GIZERAS200 | GIZE RASPBERRY GINSENG 200 ML | 12x200 ml | 1.75
 | GIZERAS750 | GIZE RASPBERRY GINSENG 750 ML | 6x750 ml | 4.83
 | GIZESPARK2 | GIZE SPARKLING 200ML | 12x200 ml | 1.92
 | GIZESPARK7 | GIZE SPARKLING 750 ML | 6x750 ml | 5
2015-09-05 00:00:00 | LUNCHEON | CHICKEN LUNCHEON 340 GM | 24X340GM | 486
2015-09-10 00:00:00 | [NAME] | RAVIKA EXTRA VIRGIN OLIVE OIL WITH CHILI 250 ML | 12x250ml | 493.67
 | REVIKLEMON | RAVIKA EXTRA VIRGIN OLIVE OIL WITH LEMON 250 ML | 12x250ml | 488.67
 | REVKABASIL | RAVIKA EXTRA VIRGIN OLIVE OIL WITH BASIL 250 ML | 12x250ml | 517.58
 | REVKOREGNO | RAVIKA EXTRA VIRGIN OLIVE OIL WITH OREGANO 250 ML | 12x250ml | 512.75
 | REVKTRUFLE | RAVIKA EXTRA VIRGIN OLIVE OIL WITH TRUFFLE 250 ML | 12x250ml | 461.67
 | REVKVINGAR | RAVIKA EXTRA VIRGIN OILIVE OIL WITH BALSAMIC VINEGAR 250 ML | 12x250ml | 503.5
Grand Total |  |  |  | 53140.05999999998