Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Date & Time

Count birthdays and list names by calendar month across years

Group the example birthday dates by month number while ignoring year.

Read the guide →
Dates & Time

Count Calls or Log Events Inside a Specific Time-of-Day Window (COUNTIFS)

Count support calls, ER arrivals, or API requests occurring inside an intraday shift bucket (such as >= 09:00 and < 12:00) using half-open [Start, End) COUNTIFS intervals.

Read the guide →
Statistical

Count category labels and calculate their share of nonblank responses

Build a literal-label frequency summary with an explicit blank policy and unrounded percentage values.

Read the guide →
Math & Trig

Count cells containing specific text: substrings and literal ? or * wildcards

Wrap search terms in "*" & B2 & "*" inside COUNTIF for partial matches, and escape literal question marks or asterisks with ~.

Read the guide →
Conditional Aggregation

Count Cells Greater Than or Less Than a Cell Reference (COUNTIF & COUNTIFS)

Concatenate comparison operators with cell references—COUNTIF(range, ">" & E2), COUNTIF(range, "<" & E2), and two-sided COUNTIFS(range, ">=" & E2, range, "<=" & F2)—without falling into the literal ">E2" string trap.

Read the guide →
Statistical & Conditional Counting

Count Cells Not Between Two Numbers (Out-of-Tolerance Spec Gate)

Count numeric observations that fall strictly outside a [Lower, Upper] specification interval while ignoring blanks and guarding reversed min/max inputs with MIN and MAX.

Read the guide →
Math & Trig

Count cells not equal to a value (without counting blank cells)

Pair "<>Value" with "<>" inside COUNTIFS so empty rows in pre-allocated ranges are not counted as active orders.

Read the guide →
Counting & Conditional Math

Count Cells Over N Characters (REPT("?", N+1) & "*" Wildcard COUNTIF)

Count how many text cells exceed a strict character limit N (such as 60-character SEO titles or 160-character SMS messages) using wildcard COUNTIF(range, REPT("?", N + 1) & "*") without helper columns.

Read the guide →
Conditional Aggregation

Count Cells That Contain Either X or Y Without Double-Counting Overlaps

Count text cells containing substring X or substring Y accurately by subtracting the dual-match intersection COUNTIFS("*X*","*Y*") from COUNTIF("*X*") + COUNTIF("*Y*").

Read the guide →
Data Auditing & Collaboration

Count Cells That Do Not Contain Errors & Sign Off Imported Sheets

Count valid non-error cells versus broken formulas across imported schedules using per-row NOT(ISERROR(...)) flags, and coordinate multi-user remediation in Arte Sheets.

Read the guide →
Counting & Conditional Aggregation

Count Cells With Exact N Characters Using COUNTIF & REPT("?", N)

Count text codes, SKUs, ZIP codes, or IBANs that match an exact N-character length dynamically using COUNTIF(B2:B7, REPT("?", D2))—and audit mismatched lengths automatically.

Read the guide →
Statistical

Count consecutive monthly orders: active retention streak across columns

Count how many unbroken trailing months a customer has ordered right up to the latest close using reverse XMATCH(0, (Row > 0)*1, 0, -1).

Read the guide →
Date & Time

Count Dates & Sum Amounts in a Given Calendar Year (COUNTIFS & DATE)

Count transactions and sum revenue occurring in any target year Y using blank-safe Jan 1 to Dec 31 DATE boundaries inside COUNTIFS and SUMIFS.

Read the guide →
Statistical

Count exact items in baskets and calculate an attach rate

Use delimiter-aware helper flags to count baskets containing both items and calculate P(B | A), without matching a product name inside a longer name.

Read the guide →
Date & Time

Count holidays between two dates (all calendar holidays vs weekday-only)

Distinguish total listed holidays inside a window (COUNTIFS) from weekday holidays that actually reduce working days (NETWORKDAYS difference).

Read the guide →
Text

Count how many times a word or substring appears in a cell

Divide the characters removed by SUBSTITUTE by the length of the search word, and guard empty search terms against #DIV/0!.

Read the guide →
Conditional Aggregation

Count Item Occurrences Across Multiple Worksheets or Regional Logs

Total how many times a SKU, employee ID, or ticket code appears across separate regional tabs or log blocks without #REF. 3D-COUNTIF errors.

Read the guide →
Text

Count line breaks, build multiline cells & extract specific lines with CHAR(10)

Count line breaks and lines inside Alt+Enter cells using LEN - LEN(SUBSTITUTE(A2, CHAR(10), "")), extract the Nth line via TEXTSPLIT, and join lines with CHAR(10).

Read the guide →
Statistical & Conditional Counting

Count Matches Between Two Columns: Row-by-Row Alignment vs. Set Overlap

Distinguish exact same-row positional matches, case-sensitive row matches, and unordered cross-column membership counts while preventing empty padding rows from inflating match totals.

Read the guide →
Date & Time Formulas

Count New (First-Time) Customers Per Month (MINIFS & COUNTIFS)

Distinguish genuine first-time customer acquisitions from repeat monthly orders by tagging each customer’s earliest purchase date with MINIFS and counting monthly cohort entries with COUNTIFS and EOMONTH.

Read the guide →
Statistical

Count non-blank and missing cells by category (COUNTIFS data completeness %)

Audit CRM or vendor master-data completeness per region using COUNTIFS with "<>" (populated) and "" (blank) criteria.

Read the guide →
Conditional Aggregation

Count Non-Blank Cells That Do Not Contain Any Blocklisted Substrings

Count clean transaction or SKU rows that exclude multiple unwanted substrings simultaneously using multi-criteria COUNTIFS wildcard exclusions and row-level SEARCH flags.

Read the guide →
Text & String

Count Numeric Digits (0–9) Inside an Alphanumeric Text String

Count how many numeric digits (0–9) appear anywhere inside a mixed serial number, SKU, or password string by subtracting digit-stripped length from LEN(A2).

Read the guide →
Text

Count occurrences of a specific word in a cell or range (whole-word safe)

Count case-insensitive space-delimited tokens or non-overlapping literal substrings in a small text range.

Read the guide →
Data Validation & Auditing

Count Positive, Negative, Numeric & Formula-Error Cells in a Ledger Range

Reconcile mixed audit columns containing gains, losses, zeros, text notes, and #DIV/0! errors using COUNTIF(">0"), COUNTIF("<0"), COUNT, and --ISERROR(B2) flags.

Read the guide →
Date & Time

Count Records by Age Bracket Directly from Birthdates (EDATE + COUNTIFS)

Count people in age bands such as 25–34 as of a reference date by translating age bounds into EDATE birth-date cutoffs; check the leap-day convention.

Read the guide →
Conditional Aggregation

Count Rows Meeting Internal Column-vs-Column Criteria (SUMPRODUCT)

Count table rows where one column exceeds or precedes another column on the same row—such as Actual > Budget AND Ship_Date <= Due_Date—using Boolean SUMPRODUCT.

Read the guide →
Statistical & Conditional Counting

Count Rows Not Equal to Multiple Criteria (COUNTIFS Multi-Exclusion)

Count active operational rows that simultaneously exclude Cancelled, Refunded, and Blank status entries—Avoiding the classic OR("<>A", "<>B") logical trap.

Read the guide →
Conditional Aggregation

Count Rows Where Column C Exceeds Column B (Row-by-Row SUMPRODUCT)

Count how many table rows satisfy an internal column-to-column test (such as Actual > Budget or Shipped_Days > SLA_Days) and sum the excess variance in one formula using SUMPRODUCT(--(C2:C6 > B2:B6)) without helper columns.

Read the guide →
Statistical

Count rows with at least N matching values across columns (COUNTIF & FILTER)

Count or list records with at least N Pass labels across four training modules, using a per-row COUNTIF helper.

Read the guide →
Statistical

Count sold vs. remaining seats or inventory and sell-through percentage

Count assigned and available slots in a fixed six-row roster and calculate its assigned fraction.

Read the guide →
Text

Count specific characters across a range of cells

Count every hashtag, comma, or letter across an entire column at once by combining TEXTJOIN, LEN, and SUBSTITUTE.

Read the guide →
Text

Count specific characters in a cell: case-sensitive and case-insensitive

Count how many times a delimiter or letter appears inside a string by comparing original text length against SUBSTITUTE length.

Read the guide →
Date & Time

Count specific weekdays between two dates (e.g., Mondays in a month)

Jump to the first matching weekday on or after StartDate using MOD and WEEKDAY, then divide the remaining span by 7.

Read the guide →
Text & Cleaning

Count Text-Stored Numbers With Leading Zeros (ZIP, Routing & Badge Audit Formula)

Detect and count text-stored numeric strings carrying leading zeros (such as "07030" or "0042") without false positives on true numbers, "0", decimals ("0.75"), or alphanumeric codes.

Read the guide →
Date & Time

Count Times Within a Specific Time Window (Daytime & Overnight COUNTIFS)

Count arrival, call, or transaction times between Start_Time and End_Time—handling both standard daytime windows (09:00–17:00) and cross-midnight graveyard shifts (22:00–06:00).

Read the guide →
Text

Count total characters in a range (with or without spaces)

Join an entire column with empty delimiter "" inside TEXTJOIN and measure LEN once—no helper column required.

Read the guide →
Text & Data Cleaning

Count Total Words Across a Multi-Cell Range Safely (Blank & Space Guards)

Count total space-delimited words across an entire column or block of notes—without inflating counts on blank cells, double spaces, or space-only entries—using TRIM, TEXTJOIN, LEN, and SUBSTITUTE.

Read the guide →
Date & Time

Count unique dates while ignoring timestamps (INT + UNIQUE)

Strip fractional clock times from audit timestamps with INT before counting distinct active calendar days with UNIQUE.

Read the guide →
Lookup & Reference

Count Unique Numeric Values Separately From Unique Text Values in a Mixed Column

Count distinct numbers and distinct non-blank text labels independently in mixed-type ranges using UNIQUE, FILTER, ISNUMBER, and ISTEXT with empty-set guards.

Read the guide →
Conditional Aggregation

Count Unique Rows or Columns Containing a Specific Value (Avoiding Double-Counts)

Count how many distinct rows or distinct columns in a 2D inspection matrix contain at least one "Fail" without double-counting multiple failures on the same row or station.

Read the guide →
Dynamic arrays

Count unique values in a column while ignoring blank cells

Pair UNIQUE with FILTER and ROWS to count distinct customers or SKUs without counting empty rows as an extra item.

Read the guide →
Dynamic Arrays

Count unique values with criteria (COUNTUNIQUEIFS pattern)

Count distinct customers or SKUs inside a filtered region or date window using FILTER, UNIQUE, and ROWS with a zero-match guard.

Read the guide →
Conditional Aggregation

Count Visible Rows & Filtered Criteria Matches (SUBTOTAL 103 & Helper Column)

Count visible non-empty records with SUBTOTAL(103, range) and pair a row-level visibility indicator (=SUBTOTAL(103, A2)) with SUMPRODUCT to count visible rows matching specific criteria.

Read the guide →
Text & String Manipulation

Count Whole-Word Occurrences in a Cell Without Partial Substring False Positives

Count how many times a standalone target word appears inside a sentence or log message by normalizing punctuation to spaces and padding word boundaries before measuring LEN - LEN(SUBSTITUTE).

Read the guide →
Math & Trig

Count with OR criteria: same-column addition vs two-column overlap

Add COUNTIF calls for mutually exclusive values in one column, and subtract COUNTIFS overlap when testing OR across two columns.

Read the guide →
Text

Count words in a cell: handle extra spaces and blank cells safely

Count space-separated words after normalizing repeated ordinary spaces, including empty cells and formulas returning empty text.

Read the guide →
Date & Time

Count Working Days With Custom Weekend Masks (Closed-Form NETWORKDAYS.INTL)

Calculate net working days between two dates under any custom 2-day weekend schedule (such as Friday–Saturday or Sunday–Monday) and subtract non-weekend public holidays using exact modular arithmetic.

Read the guide →
Streaming Algorithms & Data Engineering

Count-Min Sketch Sizing & Birthday Collision Formula

Size Cormode-Muthukrishnan Count-Min Sketch tables via width CEILING(EXP(1)/eps, 1) and depth CEILING(LN(1/delta), 1), and audit Birthday-Paradox hash collisions 1 - EXP(-n*(n - 1)/(2*M)).

Read the guide →
Counting and missing data

COUNT, COUNTA and COUNTBLANK: what counts as an empty cell?

Audit a small measurement log. Distinguish numeric readings, entered notes, truly empty cells and formulas that look blank.

Read the guide →