ColorSum: Count & Sum Colored Cells by Color
Count, sum and average cells by fill or font color in Google Sheets™, from a sidebar or with Pro formulas that refresh when colors change.
Privacy policy · Terms of service · Support: spyridwn.pd@gmail.com




ColorSum is an add-on for Google Sheets™ that counts, sums and averages cells by their fill or text color, from a sidebar or with formulas that stay up to date.
- From a sidebar: select cells and click Count: every color in them, with its number of cells and the sum and average of their numbers.
- As formulas (free over up to 5 cells for new accounts, Pro for any range):
=COUNTBYCOLOR(A2:A50, D1),=SUMBYCOLOR(A2:A50, "#f4cccc"),=SUMBYCOLOR(A2:A50, D1, C2:C50)to sum another column,AVERAGEBYCOLOR,MAXBYCOLOR,MINBYCOLOR, the same five by text color (COUNTBYFONTCOLOR…), and=COLOROF(A2)for a cell’s color code. The color is a cell that has it or a hex code; the ranges are ordinary references you can copy down. Or click a color in the sidebar, choose Sum and enter a separate numbers range from the same sheet, or select the amount cells and click Use selected cells. - Refreshed when a color changes (Pro): Google Sheets™ never recalculates a formula when only a color changes. Tick one box and ColorSum refreshes its formulas each time a color changes in the spreadsheet, including after an edit changes a rule’s colors; or refresh them from the menu when you like.
- Narrow access: ColorSum only reaches the spreadsheet you use it in, never your other files.
ColorSum counts colors as Google Sheets™ shows them, including colors set by conditional formatting. Alternating colors are not seen: those cells count by their own fill. Formulas over colors a rule sets from other cells (a custom formula or a color scale) update at the next refresh, or automatically with Pro.
Plans
- Free: 3 sidebar Counts in total, each over up to 25 cells, and color formulas over up to 5 cells, for accounts with no earlier use. Accounts with earlier recorded use, settings or a licence keep 10 a day; unclear or damaged records keep that allowance too. See the terms.
- ColorSum Pro: $9 once per Google account for unlimited counts, formulas and automatic refresh. Formulas need a successful purchase check in each spreadsheet at least every 30 days; open ColorSum or click Refresh color formulas if asked. Reopening the spreadsheet alone does not renew the check, and a billing outage cannot extend it.
Existing subscriptions and trials keep their original renewal and cancellation terms. Manage those from the sidebar. A new one-time purchase is available after the existing entitlement ends; it does not automatically cancel recurring billing.
Install it from the Google Workspace™ Marketplace, then open it from Extensions > ColorSum in any spreadsheet.
Want a small example first? Click Create sample tab for four colored amounts in a new tab. Your existing cells stay as they are. Nothing uses your free allowance until you click Count the selected cells.
Try a manually colored table (small XLSX + instructions). Import it into Google Sheets™, select Expenses!B2:B5, then use one Free sidebar Count.
Add-on will not open or uses the wrong Google account?
Privacy policy · Terms of service · Support: spyridwn.pd@gmail.com