Count multiple criteria from an array that fall within each month of the year.

%3CLINGO-SUB%20id%3D%22lingo-sub-1576982%22%20slang%3D%22en-US%22%3ECount%20multiple%20criteria%20from%20an%20array%20that%20fall%20within%20each%20month%20of%20the%20year.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1576982%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20means%20to%20count%20the%20status%20collectively%20for%20each%20month%20has%20been%20provided.%20Thanks%20Guys!%3C%2FP%3E%3CP%3ENow%20I%20need%20to%20count%20each%20status%20for%20the%20month.%20See%20attached%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1576982%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%3CLINGO-SUB%20id%3D%22lingo-sub-1577275%22%20slang%3D%22en-US%22%3ERe%3A%20Count%20multiple%20criteria%20from%20an%20array%20that%20fall%20within%20each%20month%20of%20the%20year.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1577275%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F754163%22%20target%3D%22_blank%22%3E%40GKOGOKY%3C%2FA%3E%26nbsp%3BPerhaps%20like%20in%20the%20attached%20file%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1577746%22%20slang%3D%22en-US%22%3ERe%3A%20Count%20multiple%20criteria%20from%20an%20array%20that%20fall%20within%20each%20month%20of%20the%20year.%20Cleaned%20up.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1577746%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F754163%22%20target%3D%22_blank%22%3E%40GKOGOKY%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20cleaned%20up%20the%20example%20and%20added%20my%20best%20attempt%20at%20solving%2C%20but%20I%20keep%20coming%20up%20short.%20Usually%20I%20can%20research%20and%20view%20other%20contributors%20examples%20and%20devise%20a%20fix%20in%20a%20few%20hours.%20This%20one%20has%20been%20several%20hours...%20I%20feel%20like%20I%20have%20hit%20my%20next%20brick%20wall.%20Thanks%20for%20the%20help%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1577762%22%20slang%3D%22en-US%22%3ERe%3A%20Count%20multiple%20criteria%20from%20an%20array%20that%20fall%20within%20each%20month%20of%20the%20year.%20Cleaned%20up.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1577762%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F754163%22%20target%3D%22_blank%22%3E%40GKOGOKY%3C%2FA%3E%26nbsp%3BInserted%20my%20earlier%20formulae%20in%20your%20cleaned%20file.%20See%20attached!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

The means to count the status collectively for each month has been provided. Thanks Guys!

Now I need to count each status for the month. See attached file.

3 Replies
Highlighted

@GKOGOKY Perhaps like in the attached file?

 

Highlighted

@GKOGOKY 

I cleaned up the example and added my best attempt at solving, but I keep coming up short. Usually I can research and view other contributors examples and devise a fix in a few hours. This one has been several hours... I feel like I have hit my next brick wall. Thanks for the help in advance.

Highlighted

@GKOGOKY Inserted my earlier formulae in your cleaned file. See attached!