Excel Function Categories
Category | Example Functions | Purpose |
---|---|---|
Condition-Based Logic | IF , COUNTIF , COUNTIFS , SUMIF , SUMIFS , AVERAGEIF , AVERAGEIFS | Apply logic to return different outputs based on conditions |
Math & Aggregation | SUM , COUNT , AVERAGE , ROUND | Perform totals, counts, averages, or round values |
Lookup & Reference | VLOOKUP , INDEX , MATCH | Retrieve values from other cells or tables |
Text Manipulation | LEFT , RIGHT , LEN , CONCATENATE | Format or extract text from cells |