Add-ons
Check out the store for many more
Add-on

Colour Sums


(17)
797 users

Overview

A suite of functions designed to Sum cells based on a specified background colour.
A suite of functions designed to Sum all cells based on a specified background colour.

SumAllCellsThatAreNotThisColour(Range, HexColour)
SumAllCellsThatAreThisColour(Range, HexColour)

e.g. =SumAllCellsThatAreThisColour(A1:A5, "#00ff00")

Details

Version: 13
Updated: August 22, 2018
Language: English (UK)