Spreadsheet: 105035d1302523775-help-with-a-sumproduct-query-stock-movement-sheet-1
Sheet: Stock Tracker

ID No. | Item Description | Period 2 |  |  | Period 3 Wk 1/2 |  |  | Period 3 Wk 3/4 |  |  | Period 4 Wk 1/2 |  |  | Period 4 Wk 3/4 |  |  | Period 5 |  |  | Period 6 Wk 1/2 |  |  | Period 6 Wk 3/4 |  |  | Period 7 |  |  | Period 8 Wk 1/2 |  |  | Period 8 Wk 3/4 |  |  | Period 9 |  |  | Period 10 |  |  | Period 11 |  |  | Period 12 |  |  | Period 13
 |  | Opening Stock | Stock In | Stock Out | Opening Stock | Stock In | Stock Out | Opening Stock | Stock In | Stock Out | Opening Stock | Stock In | Stock Out | Opening Stock | Stock In | Stock Out | Opening Stock | Stock In | Stock Out | Opening Stock | Stock In | Stock Out | Opening Stock | Stock In | Stock Out | Opening Stock | Stock In | Stock Out | Opening Stock | Stock In | Stock Out | Opening Stock | Stock In | Stock Out | Opening Stock | Stock In | Stock Out | Opening Stock | Stock In | Stock Out | Opening Stock | Stock In | Stock Out | Opening Stock | Stock In | Stock Out | Opening Stock | Stock In | Stock Out
001 | 16 watt GLS ES Energy Saver Softone | 239 | 200 | 282 | 157 | 5 | 87 | 75 | 163 | 82 | 156 | 150 | 280 | 26 | 138 | 130 | 34 | 360 | 304 | 90 | 0 | 174 | 66 | 60 | 108 | 48 | 470 | 290 | 228 | 300 | 300 | 228 | 300 | 221 | 307 | 500 | 580 | 227 | 130 | 92 | 265 | 300 | 460 | 105 | 0 | 121 |  | 0 | 168
002 | 16 watt GLS BC Energy Saver Softone | 297 | 331 | 139 | 248 | 1 | 50 | 242 | 0 | 6 | 210 | 0 | 32 | 167 | 0 | 31 | 41 | 300 | 126 | 92 | 0 | 54 | 94 | 60 | 52 | 102 | 192 | 101 | 84 | 100 | 42 | 84 | 0 | 60 | 416 | 500 | 89 | 363 | 0 | 53 | 280 | 0 | 83 | 205 | 0 | 66 |  | 0 | 48
003 | 7 Watt GU10 Energy Saver | 178 | 4 | 40 | 168 | 0 | 10 | 158 | 0 | 10 | 148 | 0 | 10 | 128 | 0 | 20 | 73 | 0 | 55 | 26 | 0 | 50 | 17 | 19 | 8 | 28 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 30 | 24 | 13 | 50 | 60 |  | 24 | 0
004 | 40 Watt SES Clear Cooker hood Lamp | 496 | 501 | 206 | 420 | 0 | 76 | 420 | 0 | 0 | 354 | 0 | 50 | 218 | 0 | 136 | 56 | 400 | 168 | 194 | 0 | 52 | 114 | 26 | 86 | 54 | 250 | 270 | 355 | 500 | 48 | 355 | 0 | 50 | 93 | 0 | 79 | 290 | 250 | 113 | 220 | 0 | 80 | 0 | 0 | 120 |  | 0 | 290
005 | 25 Watt SES Clear Oven Lamp | 74 | 0 | 10 | 74 | 0 | 0 | 74 | 0 | 0 | 124 | 50 | 0 | 124 | 0 | 0 | 74 | 0 | 30 | 44 | 0 | 0 | 68 | 36 | 12 | 92 | 0 | 36 | 52 | 0 | 0 | 52 | 0 | 0 | 13 | 0 | 0 | 1 | 0 | 12 | 201 | 200 | 0 | 209 | 0 | 0 |  | 0 | 0
006 | 15 Watt SES Pygmy Clear Sign Lamp | 112 | 0 | 0 | 112 | 0 | 0 | 112 | 0 | 0 | 112 | 0 | 0 | 112 | 0 | 0 | 104 | 0 | 8 | 100 | 0 | 50 | 50 | 0 | 0 | 50 | 0 | 20 | 14 | 0 | 0 | 14 | 0 | 15 | 3 | 0 | 10 | 3 | 0 | 0 | 3 | 0 | 0 | 152 | 200 | 3 |  | 0 | 0
007 | 15 Watt SBC Pygmy Clear Sign Lamp | 149 | 0 | 0 | 149 | 0 | 0 | 149 | 0 | 0 | 149 | 0 | 0 | 149 | 0 | 0 | 149 | 0 | 0 | 149 | 0 | 0 | 153 | 5 | 0 | 158 | 0 | 6 | 150 | 0 | 0 | 150 | 0 | 0 | 150 | 0 | 0 | 150 | 0 | 0 | 105 | 0 | 0 | 164 | 0 | 0 |  | 0 | 12
008 | 25 Watt BC22 Pygmy Clear Sign Lamp | 30 | 0 | 0 | 30 | 0 | 0 | 30 | 0 | 0 | 30 | 0 | 0 | 30 | 0 | 0 | 30 | 0 | 0 | 30 | 0 | 0 | 30 | 0 | 0 | 30 | 0 | 0 | 26 | 0 | 0 | 26 | 0 | 0 | 26 | 0 | 0 | 26 | 0 | 0 | 26 | 0 | 0 | 126 | 100 | 0 |  | 0 | 0
009 | 20 Watt 12v G4 Capsule Lamp | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13 | 20 | 7 | 3 | 0 | 10 | 3 | 0 | 0 | 3 | 0 | 0 | 6 | 3 | 0 | 9 | 0 | 4 | 2 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
010 | 50 Watt GY 6.35 12V M32 Capsule Lamp | 5 | 0 | 0 | 5 | 0 | 0 | 5 | 0 | 0 | 3 | 0 | 2 | 3 | 0 | 0 | 3 | 0 | 0 | 3 | 0 | 0 | 5 | 3 | 0 | 8 | 0 | 0 | 4 | 0 | 0 | 4 | 0 | 0 | 5 | 0 | 0 | 5 | 0 | 0 | 5 | 0 | 0 | 5 | 0 | 0 |  | 0 | 0