The custom function for Google Sheets™ calculates the sum, count, max, min, average, and other colored cells with the same background and text color.
Listing updated:September 23, 2024
Works with:
194K+
Overview
Our addon for Google Sheets™ will allow you to calculate colored spreadsheet cells that have the same background (Fill color) and text color. Identify the maximum, minimum, sum, count (numbers), count (text),  average, countblank, product, mode, stdev,  var, and median values. Examine cell color and count the number of boxes left blank.

To Start Function by Color for  Google Sheets™ :
1. Install the addon
2. Open spreadsheet
3. Click the Extensions menu
4. Click Function by Color
5. Click Start
6. You will see a sidebar on the right side

How to use the function by color for  Google Sheets™.
1. Select Range and click “Select Range” input for the range to automatically add the input. For Example C3:C12
2. Select a cell and click “Select a cell” input for the cell to automatically change the “Text color” and “Fill color” or manually select “Text color” and Fill Color.
3. Select Function SUM, COUNT (numbers), COUNTA (text), COUNTBLANK, AVERAGE, MIN, MAX, PRODUCT, MODE, STDEV, VAR, or MEDIAN .
4. Select the cell (the result will be in this cell) and click “The result cell” input for the range to automatically add. For example F8
5. If needed check the “checkbox”. The resulting cell will be the same as the selected “Text color” and “Fill color”.
6. Select “Calculate In” input.
7. Click the “‘Apply Function” button.
The result should look like something like this:  =SUM(CELLSVALUEBYCOLOR(“#4a86e8″,”#0c343d”,”C3:C12″))

OUR OTHER PRODUCTS
- Form Field Limit | Removal | Eliminator - allows you to add limits to paragraphs, short answers, dates, multiple choices, checkbox options, dropdowns, linear scales, times, and more in your Google Form™
- Document File Generator | Files Generator- Create custom templates for your Google Sheet™, Google Doc™, and Google Slide™ files into PDFs, Microsoft Office documents, Excel, and Powerpoint
- Form Choice Limiter Limit | Choice Remove Removal developed to limit response counts for scheduled appointment options or limit response counts for multiple choice,  checkboxes, and dropdown question options. If the limit is reached the Form Choice remove option in the form. It is the most accurate and easy-to-use choice eliminator available in the marketplace.
- EWD Mail Merge | Document Mail | Slide Mail is built for Google Sheets™, Google Docs™,  Google Slides™, and Gmail™  in order to solve email sending campaigns so that every one of your recipients gets a personalized email.  Our Mail Merge can be used with Google Sheets, Documents, and Slides.  All your mail will be seen in the primary mail list avoiding spam, promotion, and social boxes.
- Form Response Limit | Form Enable | Form Limiter allows you to add limits to the number of responses your  Google Form™ can have. It also allows you to control when you can enable or disable your  Google Form™ based on the date and time. When your form gets disabled at a certain time, you will receive an email letting you know it is disabled, and you will also get an email when the form's response limit is reached.

SUPPORT
Need help? Just send a message to us.
Contact us: https://fbc.everestwebdeals.co/contact-us/
Website: https://fbc.everestwebdeals.co
Additional information
PricingFree of charge trial
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 :
View and manage spreadsheets that this application has been installed in
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
Ailee
September 16, 2024
I was using this for a simple tracker where I could fill in cells with a color and see the total number of cells that were colored that way. I thought it was easy to use, very convenient. All was good. Until I realized it wont automatically update the count if it changes, even when you check the option for automatically recalculating it... It doesn't quite defeat the entire purpose of it, but it is highly inconvenient that you have to manually make it recalculate every time. Disappointing.
Is this review helpful?
Yes
No
Profile Picture
marcock
August 15, 2024
The "Function by color" add-on is a lifesaver! I use color-coded cells extensively in my Google Sheets, and this add-on makes it incredibly easy to calculate totals, averages, and more based on those colors. It's intuitive and works flawlessly every time. No more manual counting or complicated formulas—this tool does it all for you. It’s a fantastic time-saver and has quickly become one of my go-to tools in Google Sheets. Highly recommend it to anyone who needs to manage color-coded data!
Is this review helpful?
Yes
No
Profile Picture
Vitor Campos
June 16, 2024
That's perfect!! Easy to use.
Is this review helpful?
Yes
No
Profile Picture
Chicharito Pualtes
March 1, 2024
This program was super helpful for me🤩👍🏼
Is this review helpful?
Yes
No
Profile Picture
Son Hyong
February 29, 2024
이 프로그램이 너무 마음에 들어서 더 많은 프로그램을 추가할 가치가 있어요
Is this review helpful?
Yes
No
Profile Picture
A User of Function by color
December 7, 2023
Thanks, this is exactly what I was looking for. Works well.
Is this review helpful?
Yes
No
Profile Picture
Tomas Soir
January 28, 2023
Great tool, works perfectly. The Google sheet has issue with loading formulas. To fix this issue please refresh page. The Function by Color working perfect. Thanks.
Is this review helpful?
Yes
No
Profile Picture
Jordan
July 29, 2022
I tried using this add-on, and it works perfectly for me. This add-on has made my spreadsheet far better than any expenditure tracking software I have ever used. Utilizing it is pretty simple. Their customer service is excellent to work with and answers swiftly if you ever have issues. Additionally, it has greatly aided in time savings and increased production for me.
Is this review helpful?
Yes
No
Profile Picture
Olga BOM
August 1, 2022
It is not convenient to use, sometimes it does not correctly consider functions. I won't use again
Is this review helpful?
Yes
No
Profile Picture
Andrey Berestovoy
July 27, 2022
I tried this parody of Ablebits Function by Color and it really turned out to be a parody.
Is this review helpful?
Yes
No
1-10 of 15
Search
Clear search
Close search
Google apps
Main menu