Stop manually tagging or re-sorting your data just to total up colored cells. Custom Count & Sum adds 23 custom functions to Google Sheets that count, sum, average and filter based on how your cells actually look — background color, font color, and font style (bold, italic, underline, strikethrough).

COLOR & STYLE FUNCTIONS
Sum or count cells by background color, font color, or font style — use a reference cell or a hex code. Combine color AND style in a single condition (e.g. only bold red cells).

CROSS-SHEET FUNCTIONS
Aggregate the same range across every sheet in your spreadsheet with SUMALLSHEETS, COUNTALLSHEETS and AVERAGEALLSHEETS — no more manually summing tab by tab.

FILTER FUNCTIONS
Spill matching values into a clean vertical array with FILTERBGCOLOR, FILTERFONTCOLOR, FILTERFONTSTYLE and FILTERCOLORANDSTYLE — empty cells excluded automatically.

CHECK FUNCTIONS
ISFONTSTYLE, ISFONTCOLOR, ISBGCOLOR and ISCOLORANDSTYLE return true/false per cell, matching your range's shape — perfect for conditional logic and audits.

WORKS WITH FUNCTIONS YOU ALREADY KNOW
Filter and Check results aren't locked into this add-on — they plug straight into any native Sheets function. Wrap a Filter result in STDEV(), MEDIAN(), or LARGE(); combine a Check result with SUMPRODUCT() or MAXIFS(). No need to wait for a matching built-in function from this add-on — compose it yourself with what Sheets already offers.

Built for anyone who color-codes spreadsheets: project trackers, budget sheets, inventory logs, status boards. If you've ever wished SUM and COUNT understood color, this add-on is for you.

Free forever for smaller ranges. Paid plans unlock larger ranges — monthly, yearly, or a one-time lifetime option. Licenses are per user, not per domain — a domain-wide install doesn't include full access for every domain user on its own. A separate team plan is available for covering a whole domain. Visit base10addons.dev/custom-count-sum for full pricing, FAQ, and domain-license setup details.

Built by base:10 — practical Sheets add-ons for everyday spreadsheet work.