Tested Excel tutorials: lookup errors, #SPILL!, dates stored as text, numbers stored as text and more, with copy-ready formulas.
COUNTIF, COUNTIFS or SUMPRODUCT? A decision table plus tested examples for AND, OR, case-sensitive, row-by-row and month counts, and the edge cases that give wrong totals.
SUMIFS returns 0 when you give one column two criteria. Sum North OR West with an array constant, a criteria list, FILTER or SUMPRODUCT, without double counting.
VLOOKUP returning the wrong value in Excel or Google Sheets? Fix the missing FALSE argument first, then check duplicates, column numbers, relative ranges and wildcards.
XLOOKUP shows #N/A even though the value is there? Find the cause fast: spaces, text numbers, ranges, match_mode and more, with copy-paste fixes.
Getting #SPILL! "Spill range in table" in an Excel table? Fix the missing @ first, then return one value per row, move the formula outside, or convert to a range.
Calculate hours worked in Excel when a shift crosses midnight. Copy the MOD formula, subtract breaks, total over 24 hours, split night hours and overtime. Free timesheet.
Excel dates left-aligned, not sorting, or giving #VALUE!? Detect dates stored as text and convert them with DATEVALUE, Text to Columns, Paste Special or DATE+MID.
Numbers stored as text break SUM, lookups and sorting. Spot them in seconds, then convert with Convert to Number, Paste Special, Text to Columns, VALUE/NUMBERVALUE or Power Query, plus the hard cases.
TRIM leaves spaces behind? Find out exactly which character it is with one formula, then remove non-breaking spaces (CHAR 160), line breaks, tabs and zero-width characters in Excel or Google Sheets.