Sum and count colored cells in Google Sheets.
Listing updated:November 28, 2023
Works with:
524K+
Overview
Expand possibilities for processing color-coded cells in Google Sheets with this add-on. It sums, counts colored cells, calculates the average, finds the maximum or minimum number, and more – and all based on fill and/or text hues.

2 TOOLS TO HANDLE COLORS:
- pick & calculate ONE specific color 
- get an overview of ALL colors in the range

2 WAYS TO PICK YOUR CELL COLORS
- use color-picker to select a pattern cell from the sheet
- pick the required color from special palettes the add-on offers

3 TYPES OF COLOR COMBINATIONS TO PROCESS
- sum and count cells by text color
- sum and count cells by their fill color
- process cells by both font and background color

13 FUNCTIONS TO COUNT BY CELL COLORS
- SUM
- COUNT (numbers)
- COUNTA (text)
- COUNTBLANK
- AVERAGE
- AVERAGEA
- MIN
- MAX
- PRODUCT
- MODE
- STDEV
- VAR
- MEDIAN

3 WAYS TO COUNT COLORED CELLS
- calculate all cells in the entire selected range
- sum or count cell colors in each column of the selected range
- process cells in each row

2 CLICKS TO EDIT FORMULAS & REFRESH RESULTS
Keep your formulas up-to-date with close-by options in the drop-down menu:
- 'Refresh results' will recalculate all formulas in the active sheet
- 'Edit selected formula' will let you change and save any settings used for calculations.

2 EXTRA FUNCTIONS FOR YOUR IF(S), SUMIF(S), COUNTIF(S), etc.
=CELLCOLOR() – returns color names
=VALUESBYCOLORALL() – returns the range with values of the the same color.

30 DAYS OF FREE USE

Fully functional 30-day trial period. All payments are secure and include an unconditional 30-day money-back guarantee.

If you have any questions please post them here:
https://www.ablebits.com/docs/google-sheets-count-sum-colors/
We'll be happy to assist!

Function by Color is a proud member of the Ablebits product family. We build add-ons that help you make the most of Google Workspace. Visit our official website to learn more:
https://www.ablebits.com/google-sheets-addons.php
–––––––––––––––––––––––––––––––––––––
WHAT'S NEW
***** V1.4 (1 February 2023) *****
★ New features ★
- Calculate by all fill/font colors in the selected range.

Improved:
- The limit for total cells in a spreadsheet is expanded to 10 million cells.
- UX and UI improvements.

***** V1.3 (14 March 2022) *****
Improved:
- By popular demand, the 'Refresh results' option is back to refresh valuesByColor formulas only on the currently active sheet.
- Minor UX improvements.

Fixed:
- Didn't process those formulas where the set data range exceeded the actual number of cells on the sheet.
- Formulas with several valuesByColor functions related to the same data range returned incorrect results if no font color was specified.
- Didn't recognize the source range taken from another sheet in the existing COUNT formulas.

***** V1.2 (18 October 2021) *****
★ New features ★
- Two new functions are available in your Google Sheets:
=CELLCOLOR ()
=VALUESBYCOLORALL ()
Use them to process colors in your own formulas, e.g. SUMIFS, IF, etc. Learn more on the help page.

Improved:
- Significant performance improvements in processing large amounts of data.
- Minor UI and UX improvements.

Fixed:
- Formulas didn't work with a one-cell range.

***** V1.1 (5 May 2021) *****
Improved:
- 'Refresh results': performance improvements in processing large amounts of data.
- Minor UX improvements. 
    
Fixed:
- COUNTA and AVERAGEA ignored cells with zero-length strings and whitespaces.
- Pulled all data used for counting to a sheet with the formulas if these sheets differed.
- Didn't show corresponding hints when you tried to activate a subscription with an incorrect key.
Additional information
PricingFree of charge trial
Developer
Privacy policy
Terms of service
Function by Color will ask for the permissions shown below. Learn more
Function by Color will need access to your Google account
This will allow Function by Color to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Kirstin Chaplin
November 12, 2023
Love this extension. I used it for my weekly budget worksheet and couldn't be without it.
Is this review helpful?
Yes
No
Profile Picture
Austin McMullin
August 17, 2023
Very promising add-on, but it's not working. Installed it, even went into "Manage Add-Ons" and selected "Use in this document" and it's not recognizing any functions. Any help? I could be doing something wrong....
Is this review helpful?
Yes
No
Profile Picture
Mary Young
August 15, 2023
Once I figured it out works great!
Is this review helpful?
Yes
No
Profile Picture
Allena Shillinger
May 21, 2023
Great! Until subscription based!
Is this review helpful?
Yes
No
Profile Picture
Kimberly Gregory
March 11, 2022
I have been using Function by Color for several months now. It has helped tremendously with my production scheduling. Ran into a problem getting the formula to load and I reached out to customer service. They were very helpful and continued to follow up with me to make sure the formula was working and helped me troubleshoot the problem (turned out to be a bug within google sheets itself). A great tool and I'm glad that I have it!
Is this review helpful?
Yes
No
Profile Picture
Randy W. Harris
July 11, 2022
Awesome little piece of software. I use it frequently to help calculate performance dashboards. Highly recommend.
Is this review helpful?
Yes
No
Profile Picture
Tatianna D
March 4, 2022
I have been using the Function By Colour add-in for several months now for the purposes of tracking my income/expenses and it is perfect for what I need. My spreadsheet, thanks to this add-in is much better than any expense tracking application I have used. It is very easy to use. If you ever run into problems, their customer service responds quickly and they are so pleasant to deal with. If you need a way to use functions with colour-coded values this is the perfect add-in and for an affordable price too!
Is this review helpful?
Yes
No
Profile Picture
Pubudu Fernando
December 18, 2021
The name of this is very misleading. Expected to be able to sum based on the colour. But it turns out it cannot update the value based on a change in the colour. You have to go and refresh it manually. Which makes this a pointless add on for me.
Is this review helpful?
Yes
No
Profile Picture
Kiersten Diamond
September 28, 2022
This is a great tool for anyone using a great deal of data. I reached out to the company about licensing information and they were very helpful and quick with their response. The pricing is very affordable for anyone or any organization.
Is this review helpful?
Yes
No
Profile Picture
Tung Kieu
November 13, 2022
Hey, this add-on isn't safe at all. All your sensitive data can be seen. Be careful.
Is this review helpful?
Yes
No
1-10 of 16
Search
Clear search
Close search
Google apps
Main menu