Example library
Formula Examples
Browse copyable Excel and Google Sheets formula examples with sample tables, returned results, common errors, and links to related builders.
Find examples by task
Start from the job you need the formula to do.
Lookup
XLOOKUP multiple criteria, VLOOKUP, and INDEX MATCH examples.
Lookup builders
=XLOOKUP(H2, A2:A100, D2:D100, "Not found")Dates
SUMIFS by month, QUERY date range, FILTER rows by date, and days between dates.
Date difference sample
=B2-A2Clean and check
Extract domains, count unique values, and find duplicates.
Cleanup formula sample
=IF(COUNTIF($A$2:$A$100, A2)>1, "Duplicate", "")Counting and totals
SUMIFS multiple criteria and COUNTIFS-related patterns.
Totals sample
=SUMIFS(D2:D100, B2:B100, "East", C2:C100, "Widget")SUMIFS by Month Formula Example
Copy a SUMIFS by month formula example for Excel and Google Sheets with sample sales data, returned totals, current-month criteria, and error fixes.
SUMIFS Multiple Criteria Formula Example
Copy SUMIFS formulas with multiple criteria in Excel and Google Sheets, using sample sales data, returned totals, cell references, dates, and zero-result fixes.
XLOOKUP Multiple Criteria Formula Example
Copy XLOOKUP multiple criteria formulas for Excel and Google Sheets with sample data, returned price, not-found handling, duplicate notes, and alternatives.
INDEX MATCH with Multiple Criteria
Copy INDEX MATCH multiple-criteria formulas with sample data, array notes, three-criteria lookup, and a Google Sheets version.
Google Sheets QUERY Date Range Formula
Copy a Google Sheets QUERY date range formula with fixed dates, start and end date cells, current month, extra conditions, and timestamp-safe boundaries.
Google Sheets QUERY Another Sheet
Copy Google Sheets QUERY formulas for another tab, a tab name without spaces, or another spreadsheet file with IMPORTRANGE.
FILTER Rows by Date Formula Example
Copy Excel and Google Sheets FILTER rows by date formulas with sample data, returned rows, between-date versions, date-cell notes, and no-match handling.
Extract Domain from URL in Google Sheets Formula
Copy Google Sheets REGEXEXTRACT formulas that extract domains from URLs with sample results, IFERROR handling, lowercase cleanup, and Excel alternatives.
Count Unique Values in Google Sheets Formula
Copy Google Sheets formulas that count unique nonblank values with sample results, blank handling, space cleanup, unique-list output, and Excel alternatives.
Find Duplicates in Excel Formula Example
Copy Excel and Google Sheets formulas that find duplicate values with sample flags, blank-row handling, second-duplicate logic, and cleanup tips.
Calculate Days Between Dates Formula Example
Copy Excel and Google Sheets formulas for days between dates with sample results, inclusive counting, business days, negative dates, and date text fixes.
Google Sheets QUERY GROUP BY and SUM
Copy Google Sheets QUERY GROUP BY formulas to sum, count, average, sort totals, build a leaderboard, and fix aggregation, data-type, and clause-order errors.