Excel functions A to Z
Plain-English guides to the Excel functions people use most. Each page gives the syntax, what every argument does, and what Excel really returned when we ran the examples, errors included.
The functions people look at most
CONCATENATEGlues pieces of text and values into one string, for example building a full name or a code from separate cells.VLOOKUPThe classic lookup: find an item in the first column and fetch something from the same row. Common in interviews, though XLOOKUP is the modern choice.ANDChecks that all conditions hold at once. Mostly used inside IF to require several criteria together.SUMAdds numbers together. The most-used function in Excel.SUMIFAdds up values that match one condition, such as sales for one region.SUMIFSAdds values subject to several conditions at once, e.g. sales for a product in one quarter.XLOOKUPThe modern lookup: find a value in one range and return the matching entry from another, in any direction. It replaces most VLOOKUP and INDEX/MATCH uses.CONCATJoins text from several cells or values into one, and unlike CONCATENATE it accepts whole ranges. There is no delimiter option, so use TEXTJOIN when you need separators.COUNTIFCounts the cells that match a single condition, such as how many orders are over 100 or how many names start with A. One of the most used summary functions.IFThe basic decision function: show one thing if a condition holds, another if not. It underpins most conditional logic in spreadsheets.
All functions A to Z
38 functions, new ones every week