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.
Open exampleSUMIFS with Multiple Criteria
Copy a SUMIFS formula that totals values by region and product with sample data.
Open exampleXLOOKUP with Multiple Criteria
Copy an XLOOKUP multiple-criteria formula that matches two columns at once.
Open exampleINDEX MATCH with Multiple Criteria
Copy an INDEX MATCH multiple criteria formula to look up a value by two or more columns. Includes the array and concatenation methods, sample data, Ctrl+Shift+Enter notes, three-criteria, and a Google Sheets version.
Open exampleGoogle 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.
Open exampleGoogle Sheets QUERY Another Sheet
Copy a QUERY formula that reads data from another sheet tab in Google Sheets.
Open exampleFILTER Rows by Date
Copy Excel and Google Sheets FILTER formulas that return rows on or after a selected date.
Open exampleExtract Domain from URL in Google Sheets
Copy a REGEXEXTRACT formula that returns the domain from a URL in Google Sheets.
Open exampleCount Unique Values in Google Sheets
Copy a Google Sheets formula that counts unique nonblank values in a range.
Open exampleFind Duplicates in Excel
Copy an Excel formula that flags duplicate values in a column with COUNTIF.
Open exampleCalculate Days Between Dates
Copy a simple Excel and Google Sheets formula for calculating days between two date cells.
Open example