Spreadsheet: 783405d1654786918-help-calculating-consecutive-weeks-of-stock-for-this-year-and-last-year-excel-wos-help
Sheet: Sheet1

 |  |  |  |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | WEEKS | WEEKS
REF | TIME | YEAR | Article | DESC | COLOUR | STOCK UNITS | STOCK UNITS | STOCK UNITS | STOCK UNITS | STOCK UNITS | STOCK UNITS | STOCK UNITS | STOCK UNITS | STOCK UNITS | STOCK UNITS | STOCK UNITS | STOCK UNITS | ON SALE TY | ON SALE LY | SHOULD EQUAL
AA0001 | LY | 2021 | AA0001 | A MODEL | WHITE | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 | 0 | "FORMULA" |  | 10 | Item in stock for 10 consecutive weeks
AA0002 | LY | 2021 | AA0002 | A MODEL | BLACK | 40 | 39 | 38 | 37 | 36 | 35 | 34 | 33 | 32 | 31 | 30 | 29 | "FORMULA" |  | 12 | Item in stock for 12 consecutive weeks
AA0003 | LY | 2021 | AA0003 | A MODEL | GREY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 19 | 18 | "FORMULA" |  | 3 | Item in stock for 3 consecutive weeks
AA0004 | LY | 2021 | AA0004 | A MODEL | RED | 0 | 0 | 0 | 4 | 3 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | "FORMULA" |  | 4 | Item in stock for 4 consecutive weeks
AA0005 | LY | 2021 | AA0005 | A MODEL | BLUE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | "FORMULA" |  | 0 | No stock
BB0001 | LY | 2021 | BB0001 | B MODEL | WHITE | 6 | 5 | 4 | 3 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | "FORMULA" |  | 6 | Item in stock for 6 consecutive weeks
BB0002 | LY | 2021 | BB0002 | B MODEL | BLACK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | "FORMULA" |  | 0 | No stock
BB0003 | LY | 2021 | BB0003 | B MODEL | GREY
BB0004 | LY | 2021 | BB0004 | B MODEL | RED
BB0005 | LY | 2021 | BB0005 | B MODEL | BLUE
CC0001 | LY | 2021 | CC0001 | C MODEL | WHITE
CC0002 | LY | 2021 | CC0002 | C MODEL | BLACK
CC0003 | LY | 2021 | CC0003 | C MODEL | GREY
CC0004 | LY | 2021 | CC0004 | C MODEL | RED
CC0005 | LY | 2021 | CC0005 | C MODEL | BLUE
AA0001 | TY | 2022 | AA0001 | A MODEL | WHITE | 0 | 0 | 5 | 4 | 3 | 2 |  |  |  |  |  |  | "FORMULA" | 10 | 4 | Item in stock for 4 consecutive weeks
AA0002 | TY | 2022 | AA0002 | A MODEL | BLACK | 28 | 27 | 26 | 25 | 24 | 23 |  |  |  |  |  |  | "FORMULA" | 12 | 18 | Item in stock final month of LY so should continue to count from LYs total
AA0003 | TY | 2022 | AA0003 | A MODEL | GREY | 17 | 16 | 15 | 14 | 13 | 12 |  |  |  |  |  |  | "FORMULA" | 3 | 9 | Item in stock final month of LY so should continue to count from LYs total
AA0004 | TY | 2022 | AA0004 | A MODEL | RED | 0 | 3 | 2 | 1 | 0 | 0 |  |  |  |  |  |  | "FORMULA" | 4 | 3 | Item in stock for 3 consecutive weeks
AA0005 | TY | 2022 | AA0005 | A MODEL | BLUE | 60 | 59 | 58 | 57 | 56 | 55 |  |  |  |  |  |  | "FORMULA" | 0 | 6 | Item in stock for 6 consecutive weeks
BB0001 | TY | 2022 | BB0001 | B MODEL | WHITE | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | "FORMULA" | 6 | 0 | No stock
BB0002 | TY | 2022 | BB0002 | B MODEL | BLACK | 1 | 0 | 0 | 3 | 2 | 1 |  |  |  |  |  |  | "FORMULA" | 0 | 3 | Should only include the most recent consecutive amount of weks in stock
BB0003 | TY | 2022 | BB0003 | B MODEL | GREY
BB0004 | TY | 2022 | BB0004 | B MODEL | RED
BB0005 | TY | 2022 | BB0005 | B MODEL | BLUE
CC0001 | TY | 2022 | CC0001 | C MODEL | WHITE
CC0002 | TY | 2022 | CC0002 | C MODEL | BLACK
CC0003 | TY | 2022 | CC0003 | C MODEL | GREY
CC0004 | TY | 2022 | CC0004 | C MODEL | RED
CC0005 | TY | 2022 | CC0005 | C MODEL | BLUE