Hey, I see your frustration and thanks for letting me know. I'm new to this and i didn't see it from your view . Thank you for helping.

Firstly why it wouldn't work that well..I have about 500 000 rows of data, with a helper row, it would be 1 000 000 rows.

The green colour is a day when a device had uptime above 96 %
The yellow colour is a day when a device had a uptime between 90% and 96%
The red colour is a device with an uptime of below 90℅
The first column is device id's
I used conditional formatting to indicate visually, when a device is below 90 ℅ , consecutively, basically only focusing on the red days. I need a figure to indicate how much times a device is down consecutively after the grand total column.
I will use the figure to look at, in which region we have an issue with regards to service level agreements.

So...A formula to drag down will be easy and efficient if that is possible, I can't say.

Would you still help? What will it cost me?
Is that much better info?