Excel Function Categories (Explained with Examples)

Excel includes hundreds of powerful functions. Numstro organizes them into simple categories so you can quickly find the function you need — with step-by-step examples and plain-English explanations.

Category	Example Functions	What They're Used For
Conditional Logic	`IF`, `COUNTIF`, `COUNTIFS`, `SUMIF`, `SUMIFS`, `AVERAGEIF`, `AVERAGEIFS`	Return values or perform calculations based on specific conditions
Math & Aggregation	`SUM`, `COUNT`, `AVERAGE`, `ROUND`	Add, count, average, or round numbers
Lookup & Reference	`VLOOKUP`, `INDEX`, `MATCH`	Retrieve values from other tables or ranges
Text	`LEFT`, `RIGHT`, `LEN`, `CONCATENATE`	Format or extract text from cells

Want help writing formulas?

Try the AI Formula Builder — generate Excel formulas from your own data.

Launch Formula Builder