3
3
3amunyk2016-04-18 00:32:28
Google Sheets
3amunyk, 2016-04-18 00:32:28

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.
h_1460928631_3370332_af78923b32.png
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

1 answer(s)
A
Alexander Ivanov, 2016-08-01
@oshliaer

Custom Count and Sum - cheap and cheerful.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question