Version 2.2

• Changed The free tier is now function-based. COUNTSTYLE stays free on any range, and ISFONTCOLOR / ISBGCOLOR / ISFONTSTYLE / ISCOLORANDSTYLE stay free on a single cell. Every other function — counting or summing by colour, all the averages / max / min / median, cross-sheet, and the FILTER functions — now needs an active plan after a 14-day free trial (no card). If you were relying on the old 30-cell free limit, start the trial from the sidebar.
• Changed The free trial is now 14 days (up from 7). If you're in a trial right now, it's been extended to the full 14 days.

Every formula runs on Google's servers as a custom function; the paid plans cover the running costs and keep the add-on maintained.

New functions

• New MAX / MIN / MEDIAN — 15 new functions extend every existing style, color and cross-sheet category with statistical aggregates: MAXSTYLE MINSTYLE MEDIANSTYLE MAXFONTCOLOR MINFONTCOLOR MEDIANFONTCOLOR MAXBACKGROUNDCOLOR MINBACKGROUNDCOLOR MEDIANBACKGROUNDCOLOR MAXCOLORANDSTYLE MINCOLORANDSTYLE MEDIANCOLORANDSTYLE MAXALLSHEETS MINALLSHEETS MEDIANALLSHEETS

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 FALSE to 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 & paid plans

• New Free tier — all functions work on ranges up to 30 cells with no account or license required
• New Paid subscription — unlock unlimited ranges with a monthly (€1.99/mo), yearly (€14.99/yr) or lifetime (€39.99) plan, processed securely via Stripe
• New 7-day free trial — new users get full access automatically on first use
• New Team plan — domain licenses at €10.99/seat/yr (minimum 5 seats) with self-serve seat management; note that licenses are per user, not per domain, so a domain-wide install alone doesn't unlock full access for every user

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
• New New website — replaces the old landing page, with clearer pricing, a full function reference, FAQ and a proper contact form