Sum and count colored cells in Google Sheets.
Listing updated:October 18, 2024
Works with:
703K+
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
Matthew Verley
May 17, 2024
It did everything I wanted it to, but it could definitely use some work especially since it's a paid add-on (after the 30-day trial). Definitely needs improved instructions. Took awhile to figure out how to use the different formulas. Took even longer to figure out how to pull up the side menu. If you have it counting the number of colored cells, it doesn't update the number when you add colors. I had to clear the cell and put in the formula again for it to update.
Is this review helpful?
Yes
No
Profile Picture
Roger Formanek
December 2, 2024
For what I ask it to do, it's great. And fun! I still haven't explored everything it can do, but I am happy with I'm using it for.
Is this review helpful?
Yes
No
Profile Picture
Horowitz Lee
October 27, 2024
An useful function to have insight into data.
Is this review helpful?
Yes
No
Profile Picture
Pavlína Meľuchová
July 17, 2024
I want to thank Customer Support and their special treatment, the Function by Color works correctly after help from Katerina from AbleBits support team. Thank you :)
Is this review helpful?
Yes
No
Profile Picture
Joe S.
March 13, 2024
I do some data analysis in Google Sheets instantly. Sometimes I need to sum and count some data based on conditional formatting. Function by Color is very useful and helps me a lot. I only need to use different Color identification, Function by Color can help me sum and count synchronously and accurately, thus reducing a lot of my workload. A great auxiliary tool for Google Sheets!
Is this review helpful?
Yes
No
Profile Picture
Natalia Vodyanitskaya
February 14, 2024
Very good customization for Google Sheet. I'm really glad for buying it. It help's me to make different calculation faster. Thank you!
Is this review helpful?
Yes
No
Profile Picture
Maciej Karbownik
October 23, 2024
shame does not work on mobile, and on computer, formulas do not automatically refresh results, you have to open the extension and manually refresh... disappointing...
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
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
Mary Young
August 15, 2023
Once I figured it out works great!
Is this review helpful?
Yes
No
1-10 of 25
Search
Clear search
Close search
Google apps
Main menu