Formula task library
Excel and Google Sheets Formula Pages
Copyable Excel and Google Sheets formula pages with sample data, common errors, alternatives, and test cases.
Choose a formula by task
Pick a formula by task. Every page includes both Excel and Google Sheets versions, sample data, and common errors.
Lookup formulas
VLOOKUP, XLOOKUP, INDEX MATCH, other-sheet lookups, and multiple-criteria lookup patterns.
Conditional formulas
SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS, and date-boundary report formulas.
Date formulas
Days between dates, first and last day of month, age, workdays, and due-date calculations.
Text formulas
Split text, extract words, combine cells, remove spaces, and extract text around delimiters.
Cleanup formulas
Find duplicates, count unique values, remove blank rows, and flag duplicate rows.
VLOOKUP Exact Match Formula
Copy a VLOOKUP exact match formula with sample data, errors, alternatives, and test cases.
Open formulaVLOOKUP Approximate Match Formula
Copy a VLOOKUP approximate match formula for sorted breakpoints such as tiers, grades, or rates.
Open formulaXLOOKUP Exact Match Formula
Copy an XLOOKUP exact match formula with a not-found fallback for Excel and Google Sheets.
Open formulaINDEX MATCH Formula
Copy an INDEX MATCH exact lookup formula for Excel and Google Sheets.
Open formulaLookup Value From Another Sheet
Copy a lookup formula that returns a value from another worksheet tab.
Open formulaLookup With Multiple Criteria Formula
Copy an XLOOKUP multiple-criteria formula for matching two columns at once.
Open formulaXLOOKUP Not Found Formula
Copy an XLOOKUP formula that returns a friendly message when no match exists.
Open formulaXLOOKUP Left Lookup Formula
Copy an XLOOKUP formula that returns a value from a column to the left of the lookup column.
Open formulaVLOOKUP From Another Sheet
Copy a VLOOKUP formula that reads a table from another worksheet tab.
Open formulaINDEX MATCH Left Lookup Formula
Copy an INDEX MATCH formula that returns a value from a column to the left.
Open formulaSUMIF Formula
Copy a SUMIF formula that totals values for one condition.
Open formulaSUMIFS Formula
Copy a SUMIFS formula that totals values with multiple conditions.
Open formulaCOUNTIF Formula
Copy a COUNTIF formula that counts rows matching one condition.
Open formulaCOUNTIFS Formula
Copy a COUNTIFS formula that counts rows with multiple criteria.
Open formulaAVERAGEIF Formula
Copy an AVERAGEIF formula that averages numeric values for one condition.
Open formulaAVERAGEIFS Formula
Copy an AVERAGEIFS formula that averages values by multiple criteria.
Open formulaSUMIFS Between Dates Formula
Copy SUMIFS between dates formulas for Excel and Google Sheets, including fixed dates, cell boundaries, timestamp-safe ranges, and returned totals.
Open formulaSUMIFS by Month Formula
Copy a SUMIFS by month formula for Excel and Google Sheets. Includes month-cell, current-month, and extra-criteria variations.
Open formulaCOUNTIFS Between Dates Formula
Copy a COUNTIFS formula that counts rows between a start and end date.
Open formulaCOUNTIFS by Month Formula
Copy a COUNTIFS formula that counts rows in the month selected by a date cell.
Open formulaCOUNTIF Nonblank Formula
Copy a COUNTIF formula that counts nonblank cells in a range.
Open formulaCount Blank Cells Formula
Copy a COUNTBLANK formula for finding missing values in Excel and Google Sheets.
Open formulaDays Between Dates Formula
Copy a simple formula for calculating calendar days between two date cells.
Open formulaAdd Days to Date Formula
Copy a formula that adds a number of days to a start date.
Open formulaFirst Day of Month Formula
Copy a formula that returns the first day of the month for any date.
Open formulaLast Day of Month Formula
Copy an EOMONTH formula that returns the last day of the current month.
Open formulaCalculate Age Formula
Copy a DATEDIF formula that calculates age in completed years.
Open formulaWorkdays Between Dates Formula
Copy a NETWORKDAYS formula that counts business days between two dates.
Open formulaAdd Months to Date Formula
Copy Excel and Google Sheets EDATE formulas to add months to a date, handle month-end results, and avoid common date errors.
Open formulaDays Until Due Date Formula
Copy a formula that returns how many days remain before a due date.
Open formulaNext Business Day Formula
Copy a WORKDAY formula that returns the next business day after a date.
Open formulaSplit Text Formula
Copy Excel and Google Sheets formulas for splitting text by a delimiter.
Open formulaExtract First Word Formula
Copy a formula that extracts the first word from a cell.
Open formulaExtract Last Word Formula
Copy a formula that extracts the last word from a text cell.
Open formulaCombine Cells Formula
Copy a TEXTJOIN formula that combines cells while skipping blanks.
Open formulaRemove Extra Spaces Formula
Copy a TRIM formula that removes leading, trailing, and repeated spaces.
Open formulaExtract Text Before Character Formula
Copy formulas that extract text before a dash, comma, or other delimiter.
Open formulaExtract Text After Character Formula
Copy formulas that extract text after a dash, comma, or other delimiter.
Open formulaExtract Domain From URL Formula
Copy Excel and Google Sheets formulas that extract a domain from a URL.
Open formulaExtract Numbers From Text Formula
Copy Excel and Google Sheets formulas for keeping only digits from a text cell.
Open formulaProper Case Names Formula
Copy a PROPER and TRIM formula for cleaning names or labels.
Open formulaRemove Line Breaks Formula
Copy a formula that replaces line breaks with spaces.
Open formulaFind Duplicates Formula
Copy a formula that returns duplicate values from a list.
Open formulaCount Duplicates Formula
Copy a formula that counts how many extra duplicate entries exist in a list.
Open formulaRemove Blank Rows Formula
Copy FILTER formulas that return only rows with a nonblank key column.
Open formulaFlag Duplicate Values Formula
Copy a row-by-row formula that flags duplicate values while ignoring blanks.
Open formulaUnique List Formula
Copy a UNIQUE formula that returns a list of nonblank unique values.
Open formulaCount Unique Values Formula
Copy formulas that count unique nonblank values in Excel and Google Sheets.
Open formulaFlag Second and Later Duplicates Formula
Copy a formula that leaves the first occurrence blank and flags later duplicates.
Open formulaDuplicate Rows by Two Columns Formula
Copy a COUNTIFS formula that flags duplicate row combinations across two columns.
Open formula