Excel Formula: Sum Values Between Two Dates
Copy-ready SUMIFS formula to sum Excel values between two dates, plus variations for named cells and the current month.
Read articleExcel XLOOKUP vs VLOOKUP: Exact Match Formula
When to use XLOOKUP instead of VLOOKUP, with copy-ready exact-match formulas and INDEX/MATCH fallbacks.
Read articleExcel Formula to Count Unique Values in a Column
Count distinct Excel values with UNIQUE+FILTER, plus a SUMPRODUCT version for Excel 2016.
Read articleExcel IF with AND / OR: Nested Logic Formula
Nested IF, AND, and OR patterns for priority labels, with an IFS alternative for newer Excel.
Read articleExcel INDEX MATCH on Two Columns
Two-criteria INDEX/MATCH formula for Excel, plus XLOOKUP and SUMIFS alternatives.
Read articleExcel Formula to Split First and Last Name
Split first and last names in Excel with TEXTBEFORE/TEXTAFTER or LEFT/FIND for older versions.
Read articleExcel Formula to Convert Text to Date
Convert text dates in Excel with DATEVALUE or DATE+LEFT/MID for yyyymmdd strings.
Read article