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.