Tool category
Excel Formula Builders
Deterministic Excel formula builders with copyable formulas, sample data, and troubleshooting notes.
Choose the right Excel formula
Use this quick chooser before opening a builder.
Add values with criteria
Use SUMIFS when you need a total by region, month, product, or status. Count matching rows
Use COUNTIFS when you need a row count instead of a sum. Return a matched value
Use XLOOKUP for modern lookups; use INDEX MATCH when you need broad compatibility. Flag duplicates
=IF(A2="", "", IF(COUNTIF($A$2:$A$100, A2)>1, "Duplicate", "")) SUMIFS Formula Builder
Build a SUMIFS formula with one or two criteria, optional month matching, and copy the Excel or Google Sheets result.
XLOOKUP Formula Builder
Build a single-criterion or multiple-criteria XLOOKUP formula with not-found handling and match mode options.
VLOOKUP Formula Builder
Build a VLOOKUP formula from lookup value, table range, column index, and exact or approximate match.
INDEX MATCH Formula Builder
Build an INDEX MATCH formula from lookup value, lookup range, and return range for flexible lookups.
COUNTIFS Formula Builder
Build a COUNTIFS formula with multiple criteria range and value pairs for Excel or Google Sheets.
Date Difference Formula Builder
Build Excel and Google Sheets formulas to calculate days, completed months, or completed years between two dates.
Duplicate Checker Formula Builder
Build a COUNTIF-based duplicate checker formula with blank-row protection for Excel or Google Sheets.