Count the cells with same color in google spreadsheet

Question

I'm trying count the number of cells with the same background color and put the result in other cell with a script in google apps script, but I can't do it. I have the next script but not work and I don't know which is the problem:

function countbackgrounds() {  var book = SpreadsheetApp.getActiveSpreadsheet();  var range_input = book.getRange("B3:B4");  var range_output = book.getRange("B6");  var cell_colors = range_input.getBackgroundColors()[0];  var color = "#58FA58";  var count = 0;   for( var i in cell_colors )   if( cell_colors[i] == color ){     range_output.setValue(++count);   }   else {     return count;    }  }   

Answer 1

Easy solution if you don't want to code manually using Google Sheets Power Tools:

Note: while the tool was free when this answer was written, it is now $43.20 per year or $89.95 for a lifetime license!

1. Install Power Tools through the Add-ons panel (Add-ons -> Get add-ons)
2. From the Power Tools sidebar click on the Σ button and within that menu click on the "Sum by Color" menu item
3. Select the "Pattern cell" with the color markup you want to search for
4. Select the "Source range" for the cells you want to count
5. Use function should be set to "COUNTA"
6. Press "Insert function" and you're done :)