Formula guides

Copy-ready formulas for common Excel, Sheets, and WPS tasks.

Excel Formula for Percentage of Total

Percentage-of-total and running-share formulas for Excel, with locked ranges for fill-down.

LOOKUP and TAKE formulas that always return the last non-empty Excel cell in a growing column.

Copy-ready SUMIFS formula to sum Excel values between two dates, plus variations for named cells and the current month.

When to use XLOOKUP instead of VLOOKUP, with copy-ready exact-match formulas and INDEX/MATCH fallbacks.

Count distinct Excel values with UNIQUE+FILTER, plus a SUMPRODUCT version for Excel 2016.

Nested IF, AND, and OR patterns for priority labels, with an IFS alternative for newer Excel.

Two-criteria INDEX/MATCH formula for Excel, plus XLOOKUP and SUMIFS alternatives.

Split first and last names in Excel with TEXTBEFORE/TEXTAFTER or LEFT/FIND for older versions.

Convert text dates in Excel with DATEVALUE or DATE+LEFT/MID for yyyymmdd strings.

SUMPRODUCT patterns for AND/OR criteria and weighted averages, plus when to switch to SUMIFS.

Google Sheets QUERY examples for WHERE filters, ORDER BY, GROUP BY, and dates.

Join Excel cells with TEXTJOIN, including skip-blanks and an ampersand fallback for Excel 2016.