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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies