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.
Frequently asked questions
Are the tools free?
Yes. The site provides free spreadsheet tools, examples, and CSV templates.
Do I need an account?
No. There's no account to create, and nothing you type is uploaded — it all happens right there on your own machine.
Which Excel formula builder should I start with?
Start with SUMIFS for totals, COUNTIFS for counts, XLOOKUP for modern lookups, INDEX MATCH for flexible lookups, and the date builder for elapsed days or due dates.
Should I use VLOOKUP, XLOOKUP, or INDEX MATCH in Excel?
Use XLOOKUP when your Excel version supports it, INDEX MATCH for left lookups or compatibility, and VLOOKUP for simple exact matches where the lookup key is in the first column.
Are these Excel tools macros or add-ins?
No. The builders generate copyable formulas in the browser. The VBA SUMIFS page only shows macro code examples for users who already want a VBA pattern.