May 31 2019 12:46 PM
Hello
I am needing help, which I know should be simple, but for the life of me i can not figure out how to solve my problem.
I have week numbers (1-10) and i need to know 3 things
How many weeks the line is Out Of Stock (I have done a =COUNTIF(AN3:BH3,"0") ) which works
How many times it goes Out of stock so in this eg. the result should be: 1,3 and 1
How many consecutive weeks it is out of stock (the maximum amount of times the value is at 0 (for more than one week in a row)
How Many Week OOS | How Many Times OOS | Consecutive Weeks OOS | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
9 | 1 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 205 | 200 |
7 | 3 | 3 | 563 | 0 | 0 | 0 | 395 | 0 | 350 | 2223 | 0 | 0 |
1 | 1 | 1 | 1002 | 982 | 962 | 942 | 922 | 902 | 882 | 862 | 842 | 0 |
any help would be appreciated
Thank you x