Counting Consecutive Texts

[nicofernandez00]

Hello,

I really need help figuring out the formula for an assignment. On my spreadsheet, I have the monthly status of projects in action. From cells H28-S28, the cells are labeled either "on track", "off-track", "at risk" and "completed". I want to count the amount of consecutive times the projects were labeled "off-track" or "at risk" consecutively.

For instance:

On Track

On Track

On Track

On Track

On Track

At Risk

At Risk

At Risk

At Risk

Off Track

Off track

Off Track

<TBODY>
</TBODY>

The answer here would be 7 because "at risk" and "off track" were the consecutive statuses for seven months straight.

Please help!

 

[Redwolfx]

Re: Counting Consecutive Text Values

It's mostly Aladin's Formula, I just gave it the If/Then to identify When to use it. Thanks for the feedback.