问在有两个值匹配的情况下限制对一个结果的查询

EN

function onOpen() { //Will run every time you open the sheet

  //Gets the active Spreadsheet and sheet
  let sprsheet = SpreadsheetApp.getActiveSpreadsheet();
  let sheet = sprsheet.getActiveSheet();

  var lastRow = sheet.getLastRow();

  var getNames = sheet.getRange(3, 1, lastRow).getValues(); //Names from row 2, col 1, until the last row
  var totalNames = sheet.getRange("D4:D5").getValues(); //Change the range for more names

  let prodColor = '#f2f4f7'; //hexadecimal codes of the background colors of names in A
  let utilColor = '#cfe2f3'; //

  for (var i = 0; i < totalNames.length; i++) {

    var totalProd = 0, totalUtil = 0; //Starts at 0 for each name in D

    for (var j = 0; j < getNames.length; j++) {

      if (totalNames[i][0] == getNames[j][0]) {

        if (sheet.getRange(j + 3, 1).getBackgroundObject().asRgbColor().asHexString() == prodColor) { //if colors coincide

          totalProd += sheet.getRange(j + 3, 2).getValue();

        } else if (sheet.getRange(j + 3, 1).getBackgroundObject().asRgbColor().asHexString() == utilColor) {

          totalUtil += sheet.getRange(j + 3, 2).getValue();

        }        
      }      
    }
    sheet.getRange(i+4, 5, 1 ,2).setValues([[totalProd, totalUtil]]);

  }  
}