Excel Function Finder
Search Excel functions by name or by what you want to do.
SUM
MathAdds all numbers in a range of cells.
SUM(number1, [number2], ...)
=SUM(A1:A10) → adds values in cells A1 through A10
AVERAGE
StatsReturns the arithmetic mean of its arguments.
AVERAGE(number1, [number2], ...)
=AVERAGE(B2:B20) → mean of B2:B20
IF
LogicalReturns one value when a condition is true, another when false.
IF(logical_test, value_if_true, [value_if_false])
=IF(A1>100,"High","Low")
VLOOKUP
LookupLooks up a value in the first column of a table and returns a value from another column.
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
=VLOOKUP(A2, Sheet2!A:D, 4, FALSE)
XLOOKUP
LookupModern replacement for VLOOKUP/HLOOKUP — searches a range and returns matching values.
XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])
=XLOOKUP(A2, B:B, C:C, "Not found")
COUNTIF
StatsCounts cells in a range that meet a single condition.
COUNTIF(range, criteria)
=COUNTIF(A:A, ">100")
SUMIF
MathSums cells in a range that meet a single condition.
SUMIF(range, criteria, [sum_range])
=SUMIF(A:A, ">100", B:B)
INDEX
LookupReturns a value at a given position in a range or array.
INDEX(array, row_num, [column_num])
=INDEX(B2:B10, 3) → 3rd value in B2:B10
MATCH
LookupReturns the relative position of an item in a range.
MATCH(lookup_value, lookup_array, [match_type])
=MATCH("Apple", A1:A20, 0)CONCAT
TextJoins multiple text strings into one.
CONCAT(text1, [text2], ...)
=CONCAT(A1, " ", B1)
TEXTJOIN
TextJoins text with a delimiter, optionally ignoring empty cells.
TEXTJOIN(delimiter, ignore_empty, text1, ...)
=TEXTJOIN(", ", TRUE, A1:A10)About Excel Function Finder
Excel Function Finder helps you discover the right built-in function. Search by name, category, or task and see syntax, arguments, and quick examples.