Google Sheets Add-on

Count and sum by
color, style & more

38 custom functions for Google Sheets. Count bold cells, sum by background color, filter by font style — no scripts needed.

Install free — 14-day trial View functions →
No credit card required · Free plan or paid plans from €1.99/month
What's included

0 functions across 0 categories

B/I

Font style

Count, sum or average bold, italic, underline or strikethrough cells

  • COUNTSTYLE
  • SUMSTYLE
  • AVERAGESTYLE
  • MAXSTYLE
  • MINSTYLE
  • MEDIANSTYLE
  • ISFONTSTYLE
See all in the reference →
🎨

Colors

Operate on font color or background color using a reference cell

Font color
  • COUNTFONTCOLOR
  • SUMFONTCOLOR
  • AVERAGEFONTCOLOR
  • MAXFONTCOLOR
  • MINFONTCOLOR
  • MEDIANFONTCOLOR
  • ISFONTCOLOR
Background color
  • COUNTBACKGROUNDCOLOR
  • SUMBACKGROUNDCOLOR
  • AVERAGEBACKGROUNDCOLOR
  • MAXBACKGROUNDCOLOR
  • MINBACKGROUNDCOLOR
  • MEDIANBACKGROUNDCOLOR
  • ISBGCOLOR
See all in the reference →
B+🎨

Color + Style

Combine a color filter and a font style in a single formula

  • COUNTCOLORANDSTYLE
  • SUMCOLORANDSTYLE
  • AVERAGECOLORANDFONTSTYLE
  • MAXCOLORANDSTYLE
  • MINCOLORANDSTYLE
  • MEDIANCOLORANDSTYLE
  • ISCOLORANDSTYLE
See all in the reference →
⊞

Cross-sheet

Aggregate the same range across all tabs in one formula

  • SUMALLSHEETS
  • COUNTALLSHEETS
  • AVERAGEALLSHEETS
  • MAXALLSHEETS
  • MINALLSHEETS
  • MEDIANALLSHEETS
See all in the reference →
▦

Filter

Extract matching values into a spill array — no helper columns needed

  • FILTERBGCOLOR
  • FILTERFONTCOLOR
  • FILTERFONTSTYLE
  • FILTERCOLORANDSTYLE
See all in the reference →
See it in action

Write formulas like these

COUNTSTYLE

=COUNTSTYLE("A1:A100", "bold")_

// Count all bold cells
// in the range

SUMBACKGROUNDCOLOR

=SUMBACKGROUNDCOLOR("A1:A100", "C1")_

// Sum cells matching
// background color of C1

SUMALLSHEETS

=SUMALLSHEETS("A1:B10")_

// Sum range across
// every sheet in workbook
Why use it

Why use Custom Count and Sum

ƒx

Formatting becomes data

COUNTIF and SUMIF only look at values, not at how a cell looks. These functions read background color, font color and font style (bold, italic, underline, strikethrough), alone or combined. Highlighted cells can then be counted, summed, averaged, or reduced to their max, min or median.

✓

No code to copy or maintain

You could write this yourself in Apps Script, but then every spreadsheet needs its own pasted copy that you have to keep working. With the add-on you just type the formula, and updates arrive automatically.

⊞

All tabs in one formula

Google Sheets has no 3D range references. SUMALLSHEETS, COUNTALLSHEETS and their siblings aggregate the same range on every tab in one formula, and you can leave tabs out by name. No long hand-typed INDIRECT formulas.

∑

Works with native formulas

ISBGCOLOR and ISFONTSTYLE return TRUE or FALSE for each cell, so SUMPRODUCT can check the formatting in one column and sum another. Unlike the menu filter, which only hides rows, the filter functions return the matching values as a spill array. Wrap it in STDEV, MEDIAN or LARGE.

{ }

Flexible inputs

Scan several ranges at once, like {"A1:A10","C1:C10"}. Give the color as a reference cell, or type a hex code such as "#ffff00" when no cell has the color you need.

↻

Recalculate in one click

Google Sheets doesn't recalculate a formula when only a cell's color or style changes. The sidebar has a Recalculate all formulas button that refreshes every custom function on every sheet at once.

What users say

From the Marketplace reviews

Reviews of earlier versions of the add-on

“Great bundle of tools! The ability to use formatting to affect my formula is exactly what I needed. Great support too, was able to address my need for a refresh option.”
Google Workspace Marketplace review, 2016
“What a fantastic add on. I spent a monumental amount of time trying to get the 3D range function to work on my sheets, and then this cheeky number does it in minutes. Fantastic”
Google Workspace Marketplace review, 2016
“Sum for coloured text worked great for me!”
Google Workspace Marketplace review, 2020
“Fantastic Add-On! It fit my company’s need for exactly what we were looking for. JP helped with some modifications to make it scalable for our needs, so great support.”
Google Workspace Marketplace review, 2016
“I’ve been looking for something like this for years! Add the value of cells based on background color. Great for scheduling special work weeks. For auto-refresh, check the documentation! You basically just need to type the string of cells again at the end of the formula. Thanks for this JPV!”
Google Workspace Marketplace review, 2017
“Very useful. Thanks!”
Google Workspace Marketplace review, 2022

Reviews are public and unedited on the Marketplace listing.

Pricing

Simple, honest pricing

14-day free trial on all plans. No credit card required.

FREE
€0/forever
No card needed · COUNTSTYLE + single-cell IS… functions free
Install free
MONTHLY
€1.99/mo
Billed monthly · Cancel anytime
Start free trial
LIFETIME
€59.99 once
Pay once · All future updates included
Buy lifetime access
Google Workspace Marketplace badge 304,000+ installs via the Google Workspace Marketplace