Sum and count cells by color: font, background, or both
This add-on will sum and count colored cells in Google Sheets if they share background or text hues. It will process your data in different ways: check cell color and count blanks; find the maximum, minimum, or the average values, and more. In addition, the tool will recognize existing formulas so you could quickly review and edit shades and even ranges used for calculations.
