Answer the question
In order to leave comments, you need to log in
Sum by cell color and font color in SpreadSheet?
Counting by cell color and font, Counting color cells
Hello everyone. I hope they help me here. I just want to warn you right away, I use Excel Google Sheets.
There is a need to count numbers in a line that are highlighted with different backgrounds and colors.
For example:
Gray background black text - 0
Red background black text - 4171
Red background green text - 2113
Yellow background black text - 643
Blue background black text - 188
There is a lot of such data, so there is such a need. I believe that it is possible to use Java scripts, or even simple formulas, but I don’t know how, but I’m sure that this is real. Help me please ?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question