Guest User

Untitled

a guest
Jan 12th, 2018
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. function sumColoredCells(sumRange) {
  2. var activeRange = SpreadsheetApp.getActiveRange();
  3. var activeSheet = activeRange.getSheet();
  4. var formula = activeRange.getFormula();
  5.  
  6. var rangeA1Notation = formula.match(/\((.*)\)/).pop();
  7. var range = activeSheet.getRange(rangeA1Notation);
  8. var bg = range.getBackgrounds();
  9. var values = range.getValues();
  10.  
  11. var sum = 0;
  12. for(var i=0;i<bg.length;i++)
  13. for(var j=0;j<bg[0].length;j++)
  14. if(bg[i][j] == activeRange.getBackground())
  15. sum += parseFloat(values[i][j]);
  16.  
  17. return sum;
  18. };
Add Comment
Please, Sign In to add comment