marcup

## sumNonMatchingColoredCells.gs
/**
* @param {range} sumRange Range to be evaluated
* @param {range} colorRef Cell without background color to be searched for in sumRange
* @return {number}
* @customfunction
*/

function sumNonMatchingColoredCells(sumRange,colorRef) {
  var activeRange = SpreadsheetApp.getActiveRange();
  var activeSheet = activeRange.getSheet();

## sumMatchingColoredCells.gs
/**
* @param {range} sumRange Range to be evaluated
* @param {range} colorRef Cell with background color to be searched for in sumRange
* @return {number}
* @customfunction
*/

function sumMatchingColoredCells(sumRange,colorRef) {
  var activeRange = SpreadsheetApp.getActiveRange();
  var activeSheet = activeRange.getSheet();

## countNonMatchingColoredCells.gs
/**
* @param {range} countRange Range to be evaluated
* @param {range} colorRef Cell without background color to be searched for in countRange
* @return {number}
* @customfunction
*/

function countNonMatchingColoredCells(countRange,colorRef) {
  var activeRange = SpreadsheetApp.getActiveRange();
  var activeSheet = activeRange.getSheet();

## countMatchingColoredCells.gs
/**
* @param {range} countRange Range to be evaluated
* @param {range} colorRef Cell with background color to be searched for in countRange
* @return {number}
* @customfunction
*/

function countMatchingColoredCells(countRange,colorRef) {
  var activeRange = SpreadsheetApp.getActiveRange();
  var activeSheet = activeRange.getSheet();

## keybase.md

      
        
          
            
              
              1 file
            
          
          
            
              
              0 forks
            
          
            
              
                
                0 comments
              
            
          
            
              
              0 stars
            
          
        
        
          
              
          
          
            
                marcup
                / keybase.md
            
            
              Created
              January 24, 2019 11:52
            
          
        
      
        
  
      
    Keybase proof

I hereby claim:

I am marcup on github.
I am marcup (https://keybase.io/marcup) on keybase.
I have a public key ASCAmJQZ6TzjWB_dG5tZ3PUOpbwE6WNfkmYNJbQQ6i09Hwo

To claim this, I am signing this object:
	/**
	* @param {range} sumRange Range to be evaluated
	* @param {range} colorRef Cell without background color to be searched for in sumRange
	* @return {number}
	* @customfunction
	*/

	function sumNonMatchingColoredCells(sumRange,colorRef) {
	var activeRange = SpreadsheetApp.getActiveRange();
	var activeSheet = activeRange.getSheet();
	/**
	* @param {range} sumRange Range to be evaluated
	* @param {range} colorRef Cell with background color to be searched for in sumRange
	* @return {number}
	* @customfunction
	*/

	function sumMatchingColoredCells(sumRange,colorRef) {
	var activeRange = SpreadsheetApp.getActiveRange();
	var activeSheet = activeRange.getSheet();
	/**
	* @param {range} countRange Range to be evaluated
	* @param {range} colorRef Cell without background color to be searched for in countRange
	* @return {number}
	* @customfunction
	*/

	function countNonMatchingColoredCells(countRange,colorRef) {
	var activeRange = SpreadsheetApp.getActiveRange();
	var activeSheet = activeRange.getSheet();