App Icon
Sum and count colored cells in Google Sheets.
Listing updated:April 22, 2022
Works with:
217,189
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 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

2 EXTRA CUSTOM FUNCTIONS
=CELLCOLOR ()
=VALUESBYCOLORALL ()

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. 

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.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
PricingPaid with a free trial
Developer
Trader status unspecified
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
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
Reading Assist
January 31, 2022
You need to be aware of the limitations of this app, but once you get used to it, it's a fantastic way to sum cells based on color. Highly recommend!
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
Paul Bowen
April 28, 2021
Great tool, works perfectly. One thing i would change is that it had a refresh button that updates all the tabs rather than going in to the each tab individually and refreshing the app to update the numbers Other than that it's perfect. great support too
Is this review helpful?
Yes
No
Profile Picture
Blake Gearin
May 21, 2022
Works initially, then refreshes to 1 every time.
Is this review helpful?
Yes
No
Profile Picture
Elvin Roest
August 3, 2021
Very handy, does what it should and the support team took my suggestion for a change into account, great!
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
Nathank Kersinan
December 1, 2020
Baru download... biar i cuba dulu yeh
Is this review helpful?
Yes
No
Profile Picture
Vaibhav Gupta
June 29, 2022
I have been using it for months. Helped me a lot in saving time and enhancing productivity. But suddenly today it's not functioning. Kindly assist me
Is this review helpful?
Yes
No
1-9 of 9
Search
Clear search
Close search
Google apps
Main menu