Help & Support
Send Feedback
Cell Color Functions
Allows you to build a function that accounts for the color of of the cell. =SUM now is =COLOR_SUM adds up the values with a specific background color selected by the user.
splintermitch
30,107 users
Works with
Install
Overview
This currently contains 6 default functions that you can use in google spreadsheets (sum, average, count, counta, max and min). But with an added bonus! You can now not only choose the range of cells you want to use that function for, but you can now designate a color for it too. 

Let's say I have a list of items. The list of items are sorted by color. I only want to get the sum of the items with a red color. You can now do that! 

I've created a function builder which helps you get the color you want to use, the range you want to use and the type of function you would like. Once its built out it's just a paste into a cell and you're good to go!
Reviews
A User of Cell Color Functions
January 17, 2020
No bg color Sort zzzzz. useless
Submit reply
Cancel
A user of Cell Color Functions
February 27, 2020
Sign in with Google temporarily disabled for this app This app has not been verified yet by Google in order to use Google Sign In.
A User of Cell Color Functions
March 10, 2018
When I entered the function only the word "text" popped in the cells. Why is that happening?
Submit reply
Cancel
A User of Cell Color Functions
February 26, 2018
is it still working? always show 0 result
Submit reply
Cancel
A User of Cell Color Functions
January 7, 2018
It works ok in most of my usages, but for some reason I cannot use INDIRECT(CELL) as the range.
Submit reply
Cancel
A User of Cell Color Functions
December 29, 2017
just what I needed
Submit reply
Cancel
A User of Cell Color Functions
September 9, 2017
Great. Super helpful, although I need to know how to refresh because if you are updating your list with colors, your counts do not refresh.
Submit reply
Cancel
A user of Cell Color Functions
December 29, 2017
Hey! if you change the content (not color) of one of the cells in the range - it will update!
Robert Kalinowski
May 12, 2017
It works but not so good. How can I sum two background colors? If I use COLOR_COUNT twice in single expression I get doubled sum of single color (this COLOR_COUNT which was last range edited).
Submit reply
Cancel
A user of Cell Color Functions
February 12, 2017
Hi Robert, Thanks for the review. I haven't thought about using it twice in a single expression. That never came across my mind. But, that's an interesting idea. I'll definitely look into it!
A User of Cell Color Functions
April 4, 2017
Just what I need!
Submit reply
Cancel
A User of Cell Color Functions
March 24, 2017
Its not working at all, total catastrophy
Submit reply
Cancel
p0lar
November 6, 2016
Working well. how do I refresh the value?
Submit reply
Cancel
A user of Cell Color Functions
December 29, 2017
Hey! if you change the content (not color) of one of the cells in the range - it will update!
A user of Cell Color Functions
September 9, 2017
Yes I need to know as well! If you figure it out, let me know!
1-10 of 10
Additional information
Search
Clear search
Close search
Google apps
Main menu