There are alternating rows where the text is. I need to calculate the amount of completed rows (the COUNTA function) for each color. What is the best way to implement?

Comes to mind a stupid addition COUNTA, but these cells more than 100, so this option is not very pleasant to me :)

Still can be stupid to divide total amount by 2, but would like a more accurate solution.

Thanks in advance.