Comments on: How to count colored cells in Google Sheets

If you color-code your data in Google Sheets, you've probably noticed the lack of standard formulas that summarize this kind of information. In this article you will learn how to use our add-on to count and sum cells by color. Continue reading →

Comments page 3. Total comments: 166

  1. Hi Irina

    I have installed the Power Tools Add-on and would to use the Sum by Color funtion. For some reason it doesn't show me the Insert Function button as in your example. Am I missing something here?

    Many thanks!

    1. Hi Eugene,

      Thank you for contacting us.

      Could you please make sure that your browser page is not zoomed in? Please try to press Ctrl+0 (or cmd+0 if you have a Mac) or make sure you have 100% in the browser settings -> Zoom.

      If this doesn't help, please go to Control Panel\Appearance and Personalization\Display and check what sizing option you have set there.

      Please let me know about the results.

  2. Hi,
    i have a table where cells are both empty and filled.
    I want to count the blank cells in a specific background color.
    I tried with Powertool Sum by color + countblank .. but it returns zero where i know it should return quite a high number instead.
    Could you help?

    1. Hi Mishelle,

      I'm sorry, but we couldn't reproduce this issue. Please try to remove the standard function from the formula and see if you get any errors. E.g. if your formula looks the following way:
      =COUNTBLANK(valuesByColor("#b6d7a8", "#000000", C1:D9))
      Try to make it look like this:
      =valuesByColor("#b6d7a8", "#000000", C1:D9)

      If possible, please also share a sample spreadsheet where this issue occurs with gapps.ablebits@gmail.com

      We'll look into it.

  3. When I click refresh, the spinner goes on forever... My sheet has 15 counta by color cells only. What gives?

    1. Hello Brandon,

      Thank you for contacting us.

      When you see this again, could you please press F12 on your keyboard (Cmd+alt+j if you have a Mac), go to the Console tab, and check what errors you see highlighted in red? Please send the text of the errors to us, our developer will look into this issue.

  4. Hey Guys,

    For some reason the code is working perfectly but after a short period of time it is showing 0 result for all count formula.
    Reseting the sheet will display the correct counts again but only for a brief period, maybe 20 seconds.
    Do you have any idea what might be causing this?

    1. That is because the app is limited for one use per day unless you give them money.

    2. Hello Adam,

      I'm sorry to hear that you are having difficulties with the add-on.

      Could you please try to insert the same function from Power Tools and check if it behaves the same way?

      If it does, try to remove the standard function from the formula, e.g. =valuesByColor(A1,A1,A1:B10)

      Please let me know what error you see in the cell.

      1. Hello Irina,

        I am having same issue as Adam mentioned above although I did exactly step by step you guided in this page.

        I tried many times and have same the result - it gives zero value for count/sum formula so I suppose this add-on is not perfect one to help us in counting/summing values by colored cell.

        Thank to check it on your side and any advice from you to solve our issue are highly appreciated.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)