Cellhue

Sum and count cells by color in Google Sheets

Cellhue adds formulas that add up, count and average cells by their fill color or font color. Recolor a cell and the totals update.

Install from Google Workspace Marketplace How it works

Free plan available. Works only inside the spreadsheet you open it in. Privacy policy

127305 914320 81164
=SUMBYCOLOR(A1:D3, "#ff8d8f")46
=COUNTBYCOLOR(A1:D3, "#8be0a6")4
=AVERAGEBYCOLOR(A1:D3, "#ffe27a")13.67

What Cellhue does

Sum, count, average

Five formulas: SUMBYCOLOR, COUNTBYCOLOR, AVERAGEBYCOLOR for fill color, SUMBYFONTCOLOR and COUNTBYFONTCOLOR for font color.

Pick a color your way

Point to a sample cell, like C1, or write a color code, like "#ff0000". Upper or lower case, short "#f00" works too.

Sidebar

Select a range, click Analyze selection and see every color with its cell count, sum and average. One click inserts a ready formula.

Why Cellhue

Recalculates when a color changes

Google Sheets does not recalculate a formula when only a color changes, so color formulas can keep showing old numbers. Cellhue refreshes its formulas when you open the file and when you click Refresh all. With Pro, it also refreshes on its own while the sidebar is open.

Plain formulas with normal ranges

Write =SUMBYCOLOR(A2:A50, "#ff0000") with a normal range, the way you write SUM. No ranges in quotes, no helper columns, no scripts to copy into your file.

Free and Pro

Free

$0

  • Fill color: SUMBYCOLOR, COUNTBYCOLOR, AVERAGEBYCOLOR
  • Ranges up to 1,000 cells
  • Sidebar analysis and formula insert
  • Refresh on file open and with Refresh all

Pro Pro

$19 one-time payment

  • Everything in Free
  • Font color: SUMBYFONTCOLOR, COUNTBYFONTCOLOR
  • No range size limit
  • Auto-refresh while the sidebar is open

Payments are handled by Polar. Get Pro

Your data stays in Google Sheets

Cellhue has no server and makes no external requests. It reads only the spreadsheet you use it in, and your data is not sent anywhere. Read the Privacy Policy and Terms of Service.