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

How to use

  1. Open a spreadsheet and choose Extensions > Count & Sum by Color > Open sidebar.
  2. 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).
  3. 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).