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.
Excel SUMIF by month
Use this when a SUMIF search really needs SUMIFS month boundaries.
Excel VBA SUMIFS examples
Use this when a macro needs SUMIFS syntax, date criteria, or current-month boundaries.
Count matching rows
Use COUNTIFS when you need a row count instead of a sum.
SUMIFS vs COUNTIFS guide
Compare totals and row counts before choosing a builder.
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.
Open toolXLOOKUP Formula Builder
Build a single-criterion or multiple-criteria XLOOKUP formula with not-found handling and match mode options.
Open toolVLOOKUP Formula Builder
Build a VLOOKUP formula from lookup value, table range, column index, and exact or approximate match.
Open toolINDEX MATCH Formula Builder
Build an INDEX MATCH formula from lookup value, lookup range, and return range for flexible lookups.
Open toolCOUNTIFS Formula Builder
Build a COUNTIFS formula with multiple criteria range and value pairs for Excel or Google Sheets.
Open toolDate Difference Formula Builder
Build Excel and Google Sheets formulas to calculate days, completed months, or completed years between two dates.
Open toolDuplicate Checker Formula Builder
Build a COUNTIF-based duplicate checker formula with blank-row protection for Excel or Google Sheets.
Open toolExcel SUMIF by Month
Need to sum by month in Excel? Use the correct SUMIFS pattern with start and next-month boundaries, plus current month, ignore-year, and multi-criteria variations.
Open toolExcel VBA SUMIFS: Syntax, Examples, Dates, and Current Month
Learn how to use SUMIFS in Excel VBA with WorksheetFunction.SumIfs and Application.SumIfs. Includes copy-paste examples for multiple criteria, date ranges, current month totals, and common errors.
Open tool