Count, sum, average and filter cells by background color, font color and style — across sheets too.
Informações atualizadas:5 de outubro de 2026
Compatível com:
299 mil+
Visão geral
Stop manually tagging or re-sorting your data just to total up colored cells. Custom Count and Sum adds dozens of custom functions to Google Sheets™ that count, sum, average, find the max, min or median, and filter based on how your cells actually look — background color, font color, and font style (bold, italic, underline, strikethrough).

COLOR & STYLE FUNCTIONS
Sum, count, average, or find the max, min or median of 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, AVERAGEALLSHEETS, MAXALLSHEETS, MINALLSHEETS and MEDIANALLSHEETS — 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.

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.

COUNTSTYLE is free on any range, and ISFONTCOLOR / ISBGCOLOR / ISFONTSTYLE / ISCOLORANDSTYLE are free on a single cell. A 14-day free trial unlocks all 38 functions; after it, paid plans (monthly, yearly, or one-time lifetime) keep full access. 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.

Google Sheets™ is a trademark of Google LLC.
Informações adicionais
PreçosSem custo financeiro com recursos pagos
Desenvolvedor
Política de Privacidade
Termos de Serviço
O Custom Count and Sum pedirá as permissões abaixo. Saiba mais
O Custom Count and Sum precisará de acesso à sua Conta do Google
Isso permite que o Custom Count and Sum faça o seguinte:
Ver e gerenciar planilhas nas quais este aplicativo foi instalado
Exiba e execute conteúdo da Web de terceiros em prompts e barras laterais dentro dos aplicativos do Google
Conectar a um serviço externo
Ver o endereço de e-mail principal da sua Conta do Google
Ver suas informações pessoais, inclusive aquelas que você disponibilizou publicamente
Associar suas informações pessoais a você no Google
Loading
Pesquisa
Limpar pesquisa
Fechar pesquisa
Google Apps
Menu principal