Example library
Formula Examples
Copyable Excel and Google Sheets formula examples with sample data, explanation, and common errors.
Find examples by task
Start from the job you need the formula to do.
Lookup
XLOOKUP multiple criteria, VLOOKUP, and INDEX MATCH examples. Dates
SUMIFS by month, QUERY date range, FILTER rows by date, and days between dates. Clean and audit
Extract domains, count unique values, and find duplicates. Counting and totals
SUMIFS multiple criteria and COUNTIFS-related patterns. SUMIFS by Month in Excel
Copy a SUMIFS by month formula with sample sales data and a month-cell criteria pattern.
SUMIFS with Multiple Criteria
Copy a SUMIFS formula that totals values by region and product with sample data.
XLOOKUP with Multiple Criteria
Copy an XLOOKUP multiple-criteria formula that matches two columns at once.
Google Sheets QUERY Date Range
Copy a Google Sheets QUERY formula that filters rows between two dates.
Google Sheets QUERY Another Sheet
Copy a QUERY formula that reads data from another sheet tab in Google Sheets.
FILTER Rows by Date
Copy Excel and Google Sheets FILTER formulas that return rows on or after a selected date.
Extract Domain from URL in Google Sheets
Copy a REGEXEXTRACT formula that returns the domain from a URL in Google Sheets.
Count Unique Values in Google Sheets
Copy a Google Sheets formula that counts unique nonblank values in a range.
Find Duplicates in Excel
Copy an Excel formula that flags duplicate values in a column with COUNTIF.
Calculate Days Between Dates
Copy a simple Excel and Google Sheets formula for calculating days between two date cells.