Home

Formula Help Please

%3CLINGO-SUB%20id%3D%22lingo-sub-661598%22%20slang%3D%22en-US%22%3EFormula%20Help%20Please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-661598%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20needing%20help%2C%20which%20I%20know%20should%20be%20simple%2C%20but%20for%20the%20life%20of%20me%20i%20can%20not%20figure%20out%20how%20to%20solve%20my%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20week%20numbers%20(1-10)%20and%20i%20need%20to%20know%203%20things%3C%2FP%3E%3CP%3EHow%20many%20weeks%20the%20line%20is%20Out%20Of%20Stock%20(I%20have%20done%20a%26nbsp%3B%3DCOUNTIF(AN3%3ABH3%2C%220%22)%20)%20which%20works%3C%2FP%3E%3CP%3EHow%20many%20times%20it%20goes%20Out%20of%20stock%20so%20in%20this%20eg.%20the%20result%20should%20be%3A%201%2C3%20and%201%3C%2FP%3E%3CP%3EHow%20many%20consecutive%20weeks%20it%20is%20out%20of%20stock%20(the%20maximum%20amount%20of%20times%20the%20value%20is%20at%200%20(for%20more%20than%20one%20week%20in%20a%20row)%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EHow%20Many%20Week%20OOS%3C%2FTD%3E%3CTD%3EHow%20Many%20Times%20OOS%3C%2FTD%3E%3CTD%3EConsecutive%20Weeks%20OOS%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3E7%3C%2FTD%3E%3CTD%3E8%3C%2FTD%3E%3CTD%3E9%3C%2FTD%3E%3CTD%3E10%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E9%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E7%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E205%3C%2FTD%3E%3CTD%3E200%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E7%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E563%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E395%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E350%3C%2FTD%3E%3CTD%3E2223%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E1002%3C%2FTD%3E%3CTD%3E982%3C%2FTD%3E%3CTD%3E962%3C%2FTD%3E%3CTD%3E942%3C%2FTD%3E%3CTD%3E922%3C%2FTD%3E%3CTD%3E902%3C%2FTD%3E%3CTD%3E882%3C%2FTD%3E%3CTD%3E862%3C%2FTD%3E%3CTD%3E842%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3Eany%20help%20would%20be%20appreciated%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20x%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-661598%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
MoodyOne
Occasional Visitor

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 OOSHow Many Times OOSConsecutive Weeks OOS12345678910
91700000001205200
7335630003950350222300
11110029829629429229028828628420

any help would be appreciated

 

Thank you x

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies