Version 2.0
May 2026
New functions
- New Filter functions — FILTERBGCOLOR FILTERFONTCOLOR FILTERFONTSTYLE FILTERCOLORANDSTYLE extract matching values as a spill array, so you can list or process them elsewhere in your sheet
-
New
Boolean functions —
ISFONTSTYLE
ISFONTCOLOR
ISBGCOLOR
ISCOLORANDSTYLE
return TRUE or FALSE per cell, making them composable with native formulas like
=SUMPRODUCT(ISBGCOLOR("A2:A20","C1")*B2:B20). Use these with SUMPRODUCT instead of many COUNT or SUM formulas to reduce server calls. -
New
Include or exclude empty cells —
COUNTSTYLE
COUNTFONTCOLOR
COUNTBACKGROUNDCOLOR
COUNTCOLORANDSTYLE
accept an optional extra argument: pass
FALSEto count only non-empty cells, or omit it to include empty cells (default)
Multi-range support
-
New
All COUNT, SUM, AVERAGE and FILTER functions now accept multiple ranges at once — pass them as an array literal, e.g.
=COUNTBACKGROUNDCOLOR({"A1:A10","C1:C10"}, "D1"). Single ranges continue to work exactly as before.
Free & Pro plans
- New Free tier — all functions work on ranges up to 30 cells with no account or license required
- New Pro subscription — unlock unlimited ranges with a monthly (€1.50/mo), yearly (€15/yr) or lifetime (€40) plan, processed securely via Stripe
- New 7-day free trial — new users get full Pro access automatically on first use
Sidebar
- Improved Completely redesigned sidebar with a cleaner layout, updated branding and improved typography
- New Account tab — view your plan, manage your subscription and see your expiry date at a glance
- New Support form — send questions, bug reports or feature requests directly from the sidebar without leaving your spreadsheet
- New Recalculate button — formatting changes (colors, font styles) don't trigger recalculation automatically; the new Recalculate all formulas button in the sidebar forces an immediate refresh across all sheets