D
D
Dima2018-04-29 12:14:46
Google Sheets
Dima, 2018-04-29 12:14:46

How to calculate sum of values ​​for each cell in striped 100 cells?

5ae58c576441b349404607.png
There are alternating lines in which there will be text. I need to calculate the sum of filled rows (COUNTA function) for each color. How it is better to implement it?
For now, stupid COUNTA addition comes to mind, but there are more than 100 of these cells, so I don’t really like this option :) You
can also stupidly divide the total amount by 2, but I would like a more accurate solution.
Thanks in advance.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Aleksandr, 2018-05-03
@qpz

You can add another column, which will check for the presence in the source text.
For green:
For blue:
Copy the formulas to the entire column.
To calculate, we use the COUNIF function :

=COUNTIF(C3:C52;"green")

=COUNTIF(C3:C52;"blue")

C
Codebaker, 2018-04-29
@Codebaker

What's with the color at all? SUM(B1:B5), SUM(B6:B10)...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question