Spyridon Pikoulas

Workspace add-ons

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.

Pro $9.00 onceInstall free
ColorSum: Count & Sum Colored Cells by Color screenshotColorSum: Count & Sum Colored Cells by Color screenshotColorSum: Count & Sum Colored Cells by Color screenshotColorSum: Count & Sum Colored Cells by Color screenshot

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.

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

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