Learn one useful thing today.
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 & TimeCount 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 →StatisticalCount 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 & TrigCount 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 AggregationCount 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 CountingCount 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 & TrigCount 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 MathCount 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 AggregationCount 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 & CollaborationCount 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 AggregationCount 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 →StatisticalCount 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 & TimeCount 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 →StatisticalCount 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 & TimeCount 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 →TextCount 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 AggregationCount 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 →TextCount 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 CountingCount 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 FormulasCount 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 →StatisticalCount 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 AggregationCount 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 & StringCount 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 →TextCount 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 & AuditingCount 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 & TimeCount 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 AggregationCount 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 CountingCount 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 AggregationCount 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 →StatisticalCount 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 →StatisticalCount 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 →TextCount 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 →TextCount 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 & TimeCount 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 & CleaningCount 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 & TimeCount 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 →TextCount 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 CleaningCount 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 & TimeCount 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 & ReferenceCount 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 AggregationCount 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 arraysCount 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 ArraysCount 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 AggregationCount 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 ManipulationCount 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 & TrigCount 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 →TextCount 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 & TimeCount 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 EngineeringCount-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 dataCOUNT, 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 →