Tool category
Excel Formula Builders and Examples
Excel formula builders and examples for SUMIFS, COUNTIFS, XLOOKUP, VLOOKUP, INDEX MATCH, date formulas, duplicates, and VBA SUMIFS.
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.
SUMIFS formula builder
=SUMIFS(D2:D100, B2:B100, "East", C2:C100, "Widget")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.
Lookup builders
Use XLOOKUP for modern lookups; use INDEX MATCH when you need broad compatibility.
INDEX MATCH builder
Build exact-match lookup formulas from lookup and return ranges.
VLOOKUP exact match
=VLOOKUP(F2, A2:D100, 4, FALSE)Date difference builder
=B2-A2Flag duplicates
=IF(A2="", "", IF(COUNTIF($A$2:$A$100, A2)>1, "Duplicate", ""))Choose the right Excel workflow
Use this chooser when a workbook problem can be solved by several formula families.
Use SUMIFS for totals with criteria
Choose SUMIFS for totals by month, region, product, status, or any combination of stable criteria ranges.
Use COUNTIFS for row counts
Choose COUNTIFS when the answer should be how many rows match, not how much value those rows add up to.
Use XLOOKUP or INDEX MATCH for lookups
Use XLOOKUP when available, INDEX MATCH for compatibility and left lookups, and VLOOKUP for simple right-side exact matches.
Use date builders for due dates
Use date tools when reports need elapsed days, due-date gaps, current-month boundaries, or month-end calculations.
Use VBA SUMIFS for macro reports
Use the VBA SUMIFS examples when the workbook already has a macro and the formula must be generated or run from code.
Use duplicate checks before cleanup
Flag duplicates before import, lookup, or reporting steps so repeated keys do not silently change totals or lookup results.
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 XLOOKUP formulas for Excel and Google Sheets with exact match, multiple criteria, not-found handling, left lookup examples, and #N/A fixes.
VLOOKUP Formula Builder
Build a VLOOKUP formula for Excel and Google Sheets with exact match, approximate match, column index examples, sample data, and #N/A fixes.
INDEX MATCH Formula Builder
Build an INDEX MATCH formula for Excel and Google Sheets with lookup range, return range, left lookup examples, and #N/A fixes.
COUNTIFS Formula Builder
Build a COUNTIFS formula for Excel or Google Sheets with up to three criteria pairs, date examples, sample task data, and #VALUE! fixes.
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 Excel and Google Sheets duplicate checker formulas with COUNTIF, blank-row protection, all-duplicate or after-first modes, sample flags, and cleanup tips.
Excel SUMIF by Month
Copy an Excel SUMIF by month date formula using SUMIFS month boundaries, with current-month, Google Sheets, ignore-year, and error-fix examples.
Excel VBA SUMIFS: Syntax, Examples, Dates, and Current Month
Copy VBA SUMIFS examples using Application.SumIfs and WorksheetFunction.SumIfs for text criteria, dates, between dates, current month, and Excel Tables.