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)
any help would be appreciated
Thank you x