function countbackgrounds() {

  var str = "DEFGH";
  for (var i = 0; i < str.length; i++) {

    var col = str.charAt(i);

    var book = SpreadsheetApp.getActiveSpreadsheet();
    var sheet = book.getActiveSheet();
    var range_input = sheet.getRange(col + "1:" + col + "40");
    var range_output_red = sheet.getRange(col + "22");
    var range_output_green = sheet.getRange(col + "23");
    var range_output_yellow = sheet.getRange(col + "24");
    var range_output_grey = sheet.getRange(col + "25");
    var cell_colors = range_input.getBackgroundColors();
    var color_green = "#6aa84f";
    var color_red = "#a61c00";
    var color_yellow = "#ffd966";
    var color_grey = "#999999";
    var count_green = 0;
    var count_red = 0;
    var count_yellow = 0;
    var count_grey = 0;

    for (var r = 0; r < cell_colors.length; r++) {
      for (var c = 0; c < cell_colors[0].length; c++) {
        if (cell_colors[r][c] == color_red) {
          count_red = count_red + 1;
        } else if (cell_colors[r][c] == color_green) {
          count_green = count_green + 1;
        } else if (cell_colors[r][c] == color_yellow) {
          count_yellow = count_yellow + 1;
        } else if (cell_colors[r][c] == color_grey) {
          count_grey = count_grey + 1;
        }
      }
    }
    range_output_red.setValue(count_red);
    range_output_green.setValue(count_green);
    range_output_yellow.setValue(count_yellow);
    range_output_grey.setValue(count_grey);
  }

}