Count, sum, average and filter cells by background color, font color and style — across sheets too.
Fiche mise à jour le :19 septembre 2026
Compatible avec :
300 k+
Présentation
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.
Informations supplémentaires
TarifsSans frais avec des fonctionnalités payantes
Développeur
Règles de confidentialité
Conditions d'utilisation
Custom Count and Sum vous demandera les autorisations ci-dessous. En savoir plus
Custom Count and Sum aura besoin d'accéder à votre compte Google
Custom Count and Sum pourra ainsi effectuer les actions suivantes :
Afficher et gérer les feuilles de calcul dans lesquelles cette application a été installée
Afficher et diffuser du contenu Web tiers dans les invites et les barres latérales au sein des applications Google
Vous connecter à un service externe
Afficher l'adresse e-mail principale associée à votre compte Google
Consulter vos informations personnelles, y compris celles que vous avez choisi de rendre disponibles publiquement
Créer une relation entre vous et vos informations personnelles sur Google
Avis
Langue :
Trier par :
Google ne vérifie pas les avis ni les notes. En savoir plus sur les avis
Profile Picture
Un utilisateur de Custom Count and Sum
3 juillet 2019
Adds a bunch of VERY useful functions, as for instance, counting the number of cells with a determined color, or with a style (bold, etc). But I got some troubles, for instance, I tried =COUNTSTYLE("D4:D7", "bold"), with D4:D7 an area of cells with some text, and one cell with bold text. But it returns an #ERROR! and no idea where the error is. I suggest the author add error messages if it's possible.
Cet avis est-il utile ?
Oui
Non
Profile Picture
Un utilisateur de Custom Count and Sum
6 novembre 2019
All Fonction doesn't work at this time for me
Cet avis est-il utile ?
Oui
Non
1-2 sur 2
Recherche
Effacer la recherche
Fermer le champ de recherche
Applications Google
Menu principal