Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function getBackgroundColor(rangeSpecification) {
- var sheet = SpreadsheetApp.getActiveSpreadsheet();
- return sheet.getRange(rangeSpecification).getBackgroundColor();
- }
- function sumWhereBackgroundColorIs(color, rangeSpecification) {
- var sheet = SpreadsheetApp.getActiveSpreadsheet();
- var range = sheet.getRange(rangeSpecification);
- var x = 0;
- for (var i = 1; i <= range.getNumRows(); i++) {
- for (var j = 1; j <= range.getNumColumns(); j++) {
- var cell = range.getCell(i, j);
- if(cell.getBackgroundColor() == color)
- x += parseFloat(cell.getValue());
- }
- }
- return x;
- }
- function countCellsWithBackgroundColor(color, rangeSpecification) {
- var sheet = SpreadsheetApp.getActiveSpreadsheet();
- var range = sheet.getRange(rangeSpecification);
- var x = 0;
- for (var i = 1; i <= range.getNumRows(); i++) {
- for (var j = 1; j <= range.getNumColumns(); j++) {
- var cell = range.getCell(i, j);
- if(cell.getBackgroundColor() == color)
- x++;
- }
- }
- return x;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement