Formulas - TechyTools

Illustration of a spreadsheet where highlighted rows flow into a large plus-sign total card

November 5, 2026 admin

SUMIF in Excel: How to Use It with Examples

SUMIF adds up only the numbers that meet a condition you set. Instead of adding a whole column and then

Illustration of a spreadsheet with a magnifying glass finding a highlighted matching row and an arrow pointing to the result

November 5, 2026 admin

INDEX MATCH in Excel: How to Use It with Examples

INDEX and MATCH are two separate Excel formulas that become far more powerful together. Used as a pair, they do

XLOOKUP in Excel — spreadsheet lookup connecting a search cell to its result, illustration

November 4, 2026 admin

XLOOKUP in Excel: How to Use It with Examples

XLOOKUP is the modern replacement for VLOOKUP: it does the same job — find a value, return matching information —

VLOOKUP formula tutorial — spreadsheet with a magnifying glass over a highlighted column, illustration

November 4, 2026 admin

VLOOKUP Formula in Excel: How to Use It with Examples

VLOOKUP is the Excel formula beginners meet first — and the one that saves the most time once it clicks.