Formula examples
Excel and Google Sheets Formula Pages
Copy Excel and Google Sheets formulas for lookups, SUMIFS, COUNTIFS, dates, text cleanup, duplicates, sample data, and troubleshooting.
Copy a common formula first
Use these starting formulas when you already know the task. Open the linked formula page for sample data, expected result, alternatives, and troubleshooting.
VLOOKUP exact match
=VLOOKUP(F2, A2:D100, 4, FALSE)SUMIFS between dates
=SUMIFS(D2:D100, A2:A100, ">="&F1, A2:A100, "<"&G1)Split text by delimiter
=TEXTSPLIT(A2, "-")Last day of month
=EOMONTH(A2, 0)Count unique values
=IFERROR(COUNTA(UNIQUE(FILTER(A2:A100, A2:A100<>""))), 0)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 for Excel and Google Sheets with FALSE, sample data, column-index guidance, #N/A fixes, and safer lookup alternatives.
VLOOKUP Approximate Match Formula
Copy VLOOKUP approximate match formulas for sorted breakpoints such as tiers, grades, or rates, with sample data, match rules, and error checks.
XLOOKUP Exact Match Formula
Copy XLOOKUP exact match formulas for Excel and Google Sheets with not-found fallback text, sample data, returned results, and #N/A troubleshooting.
INDEX MATCH Formula
Copy INDEX MATCH exact lookup formulas for Excel and Google Sheets with sample data, returned values, range alignment notes, and lookup alternatives.
Lookup Value From Another Sheet
Copy formulas that look up values from another worksheet tab, with Excel and Google Sheets examples, sheet-name syntax, sample data, and error fixes.
Lookup With Multiple Criteria Formula
Copy XLOOKUP multiple-criteria formulas for two-column matching, with Excel and Google Sheets syntax, sample data, not-found handling, and alternatives.
XLOOKUP Not Found Formula
Copy XLOOKUP formulas that return friendly not-found messages, with Excel and Google Sheets examples, fallback text, sample results, and #N/A fixes.
XLOOKUP Left Lookup Formula
Copy XLOOKUP left lookup formulas that return values from a column to the left, with sample data, exact match examples, and VLOOKUP alternatives.
VLOOKUP From Another Sheet
Copy VLOOKUP formulas for another worksheet in Excel and Google Sheets, with sheet-name syntax, exact-match examples, sample data, and common #N/A fixes.
INDEX MATCH Left Lookup Formula | Excel Sheets
Copy INDEX MATCH left lookup formulas for Excel and Google Sheets, including return-left examples, #N/A fixes, VLOOKUP limits, and XLOOKUP alternatives.
SUMIF Formula With One Condition
Copy SUMIF formulas that total values for one condition, with Excel and Google Sheets syntax, sample data, text criteria, date notes, and zero-result fixes.
SUMIFS Formula for Multiple Criteria
Copy SUMIFS formulas for Excel and Google Sheets with multiple criteria, sample data, returned totals, date criteria, zero-result fixes, and builder links.
COUNTIF Formula
Copy COUNTIF formulas that count rows matching one condition, with Excel and Google Sheets syntax, sample data, text criteria, blanks, and troubleshooting.
COUNTIFS Formula for Multiple Criteria
Copy COUNTIFS formulas for Excel and Google Sheets with multiple criteria, date criteria, sample data, returned counts, and #VALUE! fixes.
AVERAGEIF Formula
Copy AVERAGEIF formulas that average numeric values for one condition, with sample data, criteria examples, blank handling, and error checks.
AVERAGEIFS Formula
Copy AVERAGEIFS formulas that average values by multiple criteria, with sample data, date and text criteria, range alignment, and error fixes.
SUMIF / SUMIFS Between Dates Formula
Copy SUMIFS between dates formulas for Excel and Google Sheets, with SUMIF notes, fixed dates, cell boundaries, timestamp-safe ranges, and returned totals.
SUMIFS by Month Formula
Copy a SUMIFS by month formula for Excel and Google Sheets. Includes month-cell, current-month, and extra-criteria variations.
COUNTIFS Between Dates Formula
Copy COUNTIFS formulas to count rows between dates in Excel and Google Sheets with inclusive boundaries, timestamp-safe criteria, sample counts, and date fixes.
COUNTIFS by Month Formula
Copy COUNTIFS by month formulas that count rows in a selected month, with date-cell criteria, current-month options, sample counts, and boundary fixes.
COUNTIF Nonblank Formula
Copy COUNTIF nonblank formulas for Excel and Google Sheets, with sample data, blank-looking cell notes, COUNTA alternatives, and cleanup tips.
Count Blank Cells Formula
Copy COUNTBLANK formulas for finding missing values in Excel and Google Sheets, with sample data, blank-looking cell notes, and cleanup checks.
Days Between Dates Formula
Copy days-between-dates formulas for Excel and Google Sheets with elapsed days, inclusive counting, sample results, time-value notes, and alternatives.
Add Days to Date Formula
Copy formulas that add days to a start date in Excel and Google Sheets, with sample data, negative-day examples, date serial notes, and error fixes.
First Day of Month Formula
Copy first-day-of-month formulas for Excel and Google Sheets, with date-cell examples, current-month options, sample results, and date text fixes.
Last Day of Month Formula | EOMONTH
Copy Excel and Google Sheets EOMONTH formulas for the last day of this month, previous month, next month, or a month from any date cell.
Calculate Age Formula
Copy DATEDIF age formulas for Excel and Google Sheets, calculate completed years, test birthday edge cases, and fix dates stored as text with sample data.
Workdays Between Dates Formula
Copy NETWORKDAYS formulas for Excel and Google Sheets to count business days between dates, exclude weekends and holidays, and verify results with sample data.
Add 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.
Days Until Due Date Formula
Copy formulas that return days until a due date, with Excel and Google Sheets examples, overdue handling, TODAY notes, and sample results.
Next Business Day Formula
Copy WORKDAY formulas that return the next business day after a date, with weekend handling, holiday ranges, sample results, and date text fixes.
Split Text Formula | TEXTSPLIT and SPLIT
Copy Excel TEXTSPLIT and Google Sheets SPLIT formulas for commas, dashes, spaces, multiple delimiters, and split text into columns examples.
Extract First Word Formula
Copy formulas that extract the first word from a cell in Excel and Google Sheets, with sample text, blank handling, delimiter notes, and cleanup tips.
Extract Last Word Formula
Copy formulas that extract the last word from a text cell, with Excel and Google Sheets versions, sample data, extra-space handling, and alternatives.
Combine Cells Formula
Copy TEXTJOIN formulas that combine cells while skipping blanks, with Excel and Google Sheets examples, delimiter choices, sample output, and cleanup tips.
Remove Extra Spaces Formula
Copy TRIM formulas that remove leading, trailing, and repeated spaces in Excel and Google Sheets, with sample data, nonbreaking-space notes, and fixes.
Extract Text Before Character Formula
Copy formulas that extract text before a dash, comma, or delimiter, with Excel and Google Sheets versions, sample results, and missing-delimiter fixes.
Extract Text After Character Formula
Copy formulas that extract text after a dash, comma, or delimiter, with Excel and Google Sheets versions, sample results, and missing-delimiter fixes.
Extract Domain From URL Formula
Copy Excel and Google Sheets formulas that extract a domain from a URL, with sample results, www handling, query-string notes, and cleanup alternatives.
Extract Numbers From Text Formula
Copy Excel and Google Sheets formulas for keeping only digits from text, with sample data, mixed-character cleanup, blank handling, and alternatives.
Proper Case Names Formula
Copy PROPER and TRIM formulas for cleaning names or labels in Excel and Google Sheets, with sample output, spacing fixes, and capitalization notes.
Remove Line Breaks Formula
Copy formulas that replace line breaks with spaces in Excel and Google Sheets, with CLEAN/SUBSTITUTE examples, sample output, and import cleanup tips.
Find Duplicates Formula
Copy formulas that return duplicate values from a list, with Excel and Google Sheets examples, sample data, blank handling, and cleanup notes.
Count Duplicates Formula
Copy formulas that count extra duplicate entries in a list, with Excel and Google Sheets examples, sample data, blank handling, and occurrence notes.
Remove Blank Rows Formula
Copy FILTER formulas that return only rows with a nonblank key column, with Excel and Google Sheets syntax, sample output, and no-match handling.
Flag Duplicate Values Formula
Copy row-by-row formulas that flag duplicate values while ignoring blanks, with Excel and Google Sheets examples, sample flags, and cleanup tips.
Unique List Formula
Copy UNIQUE formulas that return nonblank unique values in Excel and Google Sheets, with sample output, blank handling, sorting options, and alternatives.
Count Unique Values Formula
Copy formulas that count unique nonblank values in Excel and Google Sheets, with sample results, hidden-space cleanup, and COUNTUNIQUE notes.
Flag Second and Later Duplicates Formula
Copy formulas that leave the first occurrence blank and flag later duplicates, with Excel and Google Sheets examples, sample flags, and COUNTIF notes.
Duplicate Rows by Two Columns Formula
Copy COUNTIFS formulas that flag duplicate row combinations across two columns, with sample data, blank handling, helper-key alternatives, and fixes.