38 custom functions for Google Sheets. Count bold cells, sum by background color, filter by font style — no scripts needed.
Count, sum or average bold, italic, underline or strikethrough cells
Operate on font color or background color using a reference cell
Combine a color filter and a font style in a single formula
Aggregate the same range across all tabs in one formula
Extract matching values into a spill array — no helper columns needed
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.
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.
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.
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.
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.
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.
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.”
“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”
“Sum for coloured text worked great for me!”
“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.”
“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!”
“Very useful. Thanks!”
Reviews are public and unedited on the Marketplace listing.
14-day free trial on all plans. No credit card required.