Excel Function Categories

CategoryExample FunctionsPurpose
Condition-Based LogicIF, COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFSApply logic to return different outputs based on conditions
Math & AggregationSUM, COUNT, AVERAGE, ROUNDPerform totals, counts, averages, or round values
Lookup & ReferenceVLOOKUP, INDEX, MATCHRetrieve values from other cells or tables
Text ManipulationLEFT, RIGHT, LEN, CONCATENATEFormat or extract text from cells