Color Counter

The Color Counter is a custom Google Sheets tool that lets you calculate data based on cell background colors something standard formulas cannot do. It automatically detects the colors used in your sheet, allowing you to select multiple swatches and instantly count matching cells, rows, or columns within any range. Once your data is tallied, a single click on the "Export Result" button generates a neatly formatted summary table in a brand-new tab, complete with visual color blocks and totals for easy reporting.

Make a copy of this sheet document to get going.

When running it for the first time you will need to authenticate with your account.