how to perform 2 consecutive conditional formulas for same row

I am new to the forum but I am trying to learn how to set some conditions for identifying trends. there are two trends I am trying to track, one if there are any 3 consecutive months where the score was >0, and the other was if there two occurrences of 2 consecutive months (tracking area 1 has that example), tracking area 2 shows the three months in a row, and tracking area 3 did not meet either. It doesn't mater if meets both in same row I only need to identify if yes or no. You guys would be life saves id you can come up with this, potentially if cannot combine two, maybe have another column after cond met for the second trend pattern I am looking for.

welcome to the forum, Curt. you can try this array formula in P4:

Formula:

Please Login or Register  to view this content.

you mentioned 3 consecutive months & 2 occurrences of 2 consecutive months. so i did exactly that. if you want 3/2 or more, then add in the > sign like this:

Formula:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

a merry Christmas to you in advance!

Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.