Top 100 Excel Functions

SUM

SUM(number1, [number2], …) – Adds numbers, cells, and ranges together.

AVERAGE

AVERAGE(number1, [number2], …) – Returns the arithmetic mean of supplied values.

MIN

MIN(number1, [number2], …) – Returns the smallest value in a dataset.

MAX

MAX(number1, [number2], …) – Returns the largest value in a dataset.

COUNT

COUNT(value1, [value2], …) – Counts cells containing numbers.

COUNTA

COUNTA(value1, [value2], …) – Counts all non-empty cells.

COUNTBLANK

COUNTBLANK(range) – Counts empty cells in a range.

COUNTIF

COUNTIF(range, criteria) – Counts cells meeting one condition.

COUNTIFS

COUNTIFS(criteria_range1, criteria1, [criteria_range2], [criteria2], …) – Counts cells meeting multiple conditions.

SUMIF

SUMIF(range, criteria, [sum_range]) – Sums values meeting one condition.

SUMIFS

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2], [criteria2], …) – Sums values meeting multiple conditions.

AVERAGEIF

AVERAGEIF(range, criteria, [average_range]) – Calculates the average for values meeting one condition.

AVERAGEIFS

AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2], [criteria2], …) – Calculates the average for values meeting multiple conditions.

IF

IF(logical_test, value_if_true, value_if_false) – Returns one value if a condition is TRUE and another if FALSE.

IFS

IFS(logical_test1, value_if_true1, [logical_test2], [value_if_true2], …) – Evaluates multiple conditions and returns the first matching result.

AND

AND(logical1, [logical2], …) – Returns TRUE only if all conditions are TRUE.

OR

OR(logical1, [logical2], …) – Returns TRUE if at least one condition is TRUE.

NOT

NOT(logical) – Reverses a logical value.

XOR

XOR(logical1, [logical2], …) – Returns TRUE when an odd number of conditions are TRUE.

IFERROR

IFERROR(value, value_if_error) – Returns an alternate value if a formula produces an error.

IFNA

IFNA(value, value_if_na) – Returns an alternate value only when the result is #N/A.

ISBLANK

ISBLANK(value) – Checks whether a cell is empty.

ISNUMBER

ISNUMBER(value) – Checks whether a value is numeric.

ISTEXT

ISTEXT(value) – Checks whether a value is text.

ISERROR

ISERROR(value) – Checks whether a value is an error.

ISNA

ISNA(value) – Checks specifically for the #N/A error.

TRUE

TRUE() – Returns the logical value TRUE.

FALSE

FALSE() – Returns the logical value FALSE.

XLOOKUP

XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) – Searches a range and returns the corresponding value from another range.

VLOOKUP

VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) – Searches vertically and returns data from another column.

HLOOKUP

HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) – Searches horizontally and returns data from another row.

INDEX

INDEX(array, row_num, [column_num]) – Returns the value at a specified row and column.

MATCH

MATCH(lookup_value, lookup_array, [match_type]) – Returns the relative position of a value.

XMATCH

XMATCH(lookup_value, lookup_array, [match_mode], [search_mode]) – Enhanced version of MATCH with more options.

OFFSET

OFFSET(reference, rows, cols, [height], [width]) – Returns a shifted reference.

INDIRECT

INDIRECT(ref_text, [a1]) – Converts text into a valid reference.

CHOOSE

CHOOSE(index_num, value1, [value2], …) – Returns a value from a list based on an index.

ROW

ROW([reference]) – Returns the row number.

ROWS

ROWS(array) – Returns the number of rows.

COLUMN

COLUMN([reference]) – Returns the column number.

COLUMNS

COLUMNS(array) – Returns the number of columns.

ADDRESS

ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text]) – Returns a cell reference as text.

FILTER

FILTER(array, include, [if_empty]) – Returns rows or columns that meet specified criteria.

SORT

SORT(array, [sort_index], [sort_order], [by_col]) – Sorts data dynamically.

SORTBY

SORTBY(array, by_array1, [sort_order1], …) – Sorts using another array.

UNIQUE

UNIQUE(array, [by_col], [exactly_once]) – Returns unique values.

SEQUENCE

SEQUENCE(rows, [columns], [start], [step]) – Generates a sequence of numbers.

TAKE

TAKE(array, rows, [columns]) – Returns the first or last rows or columns.

DROP

DROP(array, rows, [columns]) – Removes rows or columns from an array.

TRANSPOSE

TRANSPOSE(array) – Swaps rows and columns.

SUMPRODUCT

SUMPRODUCT(array1, [array2], …) – Multiplies arrays and sums the results.

SUBTOTAL

SUBTOTAL(function_num, ref1, [ref2], …) – Performs calculations while optionally ignoring filtered rows.

AGGREGATE

AGGREGATE(function_num, options, array, [k]) – Performs calculations while ignoring hidden rows or errors.

LARGE

LARGE(array, k) – Returns the k-th largest value.

SMALL

SMALL(array, k) – Returns the k-th smallest value.

RANK

RANK(number, ref, [order]) – Returns a value's rank.

RANK.EQ

RANK.EQ(number, ref, [order]) – Returns the rank with tied values receiving the same rank.

PERCENTILE.INC

PERCENTILE.INC(array, k) – Returns the specified percentile.

QUARTILE.INC

QUARTILE.INC(array, quart) – Returns the specified quartile.

MEDIAN

MEDIAN(number1, [number2], …) – Returns the median value.

MODE.SNGL

MODE.SNGL(number1, [number2], …) – Returns the most frequently occurring value.

STDEV.S

STDEV.S(number1, [number2], …) – Estimates sample standard deviation.

STDEV.P

STDEV.P(number1, [number2], …) – Calculates population standard deviation.

VAR.S

VAR.S(number1, [number2], …) – Estimates sample variance.

VAR.P

VAR.P(number1, [number2], …) – Calculates population variance.

CORREL

CORREL(array1, array2) – Calculates the Pearson correlation coefficient.

SLOPE

SLOPE(known_y's, known_x's) – Returns the slope of a regression line.

INTERCEPT

INTERCEPT(known_y's, known_x's) – Returns the y-intercept of a regression line.

FORECAST.LINEAR

FORECAST.LINEAR(x, known_y's, known_x's) – Predicts a future value using linear regression.

LINEST

LINEST(known_y's, [known_x's], [const], [stats]) – Returns linear regression statistics.

ROUND

ROUND(number, num_digits) – Rounds to a specified number of digits.

ROUNDUP

ROUNDUP(number, num_digits) – Always rounds away from zero.

ROUNDDOWN

ROUNDDOWN(number, num_digits) – Always rounds toward zero.

MROUND

MROUND(number, multiple) – Rounds to the nearest multiple.

INT

INT(number) – Rounds down to the nearest integer.

MOD

MOD(number, divisor) – Returns the remainder after division.

ABS

ABS(number) – Returns the absolute value.

SQRT

SQRT(number) – Returns the square root.

POWER

POWER(number, power) – Raises a number to a specified exponent.

EXP

EXP(number) – Returns e raised to a power.

LN

LN(number) – Returns the natural logarithm.

LOG

LOG(number, [base]) – Returns a logarithm using a specified base.

RAND

RAND() – Returns a random decimal between 0 and 1.

RANDBETWEEN

RANDBETWEEN(bottom, top) – Returns a random integer within a range.

CEILING

CEILING(number, significance) – Rounds upward to a specified multiple.

FLOOR

FLOOR(number, significance) – Rounds downward to a specified multiple.

LEFT

LEFT(text, [num_chars]) – Returns characters from the beginning of a string.

RIGHT

RIGHT(text, [num_chars]) – Returns characters from the end of a string.

MID

MID(text, start_num, num_chars) – Returns characters from the middle of a string.

LEN

LEN(text) – Returns the number of characters.

TRIM

TRIM(text) – Removes extra spaces.

TEXT

TEXT(value, format_text) – Converts a value into formatted text.

TEXTJOIN

TEXTJOIN(delimiter, ignore_empty, text1, [text2], …) – Joins text strings using a delimiter.

CONCAT

CONCAT(text1, [text2], …) – Combines multiple text strings.

UPPER

UPPER(text) – Converts text to uppercase.

LOWER

LOWER(text) – Converts text to lowercase.

PROPER

PROPER(text) – Capitalizes the first letter of each word.

FIND

FIND(find_text, within_text, [start_num]) – Finds text within another string (case-sensitive).

SEARCH

SEARCH(find_text, within_text, [start_num]) – Finds text within another string (not case-sensitive).

SUBSTITUTE

SUBSTITUTE(text, old_text, new_text, [instance_num]) – Replaces specified text.