Category: Formulas & Functions

Formulas & Functions

XLOOKUP in Excel: the lookup formula that just works

XLOOKUP in Excel explained with one example: find a value in a list and return what sits next to it, with no column counting.

September 29, 2026

Formulas & Functions

SUM in Excel: add up a column in 5 seconds

The fastest way to add a column of numbers is =SUM(range). The formula =SUM(B2:B20) Click the cell under your numbers, type the…

September 28, 2026