Count & Sum by Color
An add-on for Google Sheets™ that counts, sums and averages cells by fill or font colour. Totals update by themselves a few seconds after you change a colour, so there is no manual refresh step.
Features
- Free: COUNTBYCOLOR, SUMBYCOLOR and automatic refresh when colours change.
- Pro: colour summary table, totals across tabs, copying rows of one colour to a new tab, AVERAGEBYCOLOR, font-colour functions, and colours set by single-colour conditional formatting rules.
How to use
- Open a spreadsheet and choose Extensions > Count & Sum by Color > Open sidebar.
- Enter the range to check and a cell that has the colour you want, then click Insert into selected cell. For example:
=COUNTBYCOLOR(A2:A100, B1).
- Turn on Auto-refresh in the sidebar. Results then update a few seconds after you change a cell's colour. You can turn it off at any time.
Limitations
Colour scales (gradients) and custom-formula conditional formatting rules are not counted yet.
Support
Email countsum@lrlr-master.com. We usually reply within 3 business days.
Published by 엘알엘알 (LRLR), registered in the Republic of Korea (business registration no. 603-29-75771).