nicofernandez00
New Member
- Joined
- Jun 24, 2014
- Messages
- 27
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:
<TBODY>
</TBODY>The answer here would be 7 because "at risk" and "off track" were the consecutive statuses for seven months straight.
Please help!
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>
Please help!