How to calculate the sum of values for each cell in alternating 100 cells?


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
13 views
5ae58c576441b349404607.png

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.
by | 13 views

2 Answers

0 like 0 dislike
You can add another column that will be checked in the original text.

For green:
=IF(B3="";"";"green")

For blue:
=IF(B8="";"";"blue")

Copy the formula to the entire column.

For counting use the function COUNIF:
=COUNTIF(C3:C52;"green") =COUNTIF(C3:C52;"blue")
by
0 like 0 dislike
What's the color at all? SUM(B1:B5), SUM(B6:B10)...
by
110,608 questions
257,186 answers
0 comments
35,405 users