Count text with conditions until text changes, then reset 'counter' and continue on

[ddander54]

My tasks are these:
1) Count the number of id's open in RED status greater than 15 concurrent business days and can not be a greater than 2 id's in a given period
2) Count the number of id's open in YELLOW status greater than 20 concurrent business days and can not be a greater than 20 id's in a given period

My data is loaded into a pivot table daily (work day) as this:

ID | Date | Indicator |
123 | 1/11/2021 | Green |
123 | 1/12/2021 | Yellow |
123 | 1/13/2021 | Red |
456 | 1/11/2021 | Red |
456 | 1/12/2021 | Red |
789 | 1/11/2021 | Yellow |
789 | 1/12/2021 | Yellow |
789 | 1/12/2021 | Yellow |
789 | 1/14/2021 | Green |

The ID and Date Column will not have blanks, the Indicator column could have a blank or 'None'.

I have tried creating a counter column with COUNTIFS, but then a different combination of Red, Yellow, Green for a give id 'breaks' the count.

Any suggestions for a solution?

Thanks in advance,