SUM
★☆☆Returns the sum of selected values or ranges.
SUM(number1, [number2], ...)
Category: Aggregation
Excel Functions Reference
97 major functions. Move between detail pages and hands-on practice.
SUMIF
★☆☆Sums values that meet a condition.
SUMIF(range, criteria, [sum_range])
Category: Aggregation
SUMIFS
★★☆Sums values that meet multiple conditions.
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Category: Aggregation
SUBTOTAL
★★☆Returns a subtotal with specified aggregate function.
SUBTOTAL(function_num, ref1, [ref2], ...)
Category: Aggregation
AGGREGATE
★★★Performs aggregate calculations with ignore options.
AGGREGATE(function_num, options, array, [k])
Category: Aggregation
AVERAGE
★☆☆Returns the arithmetic mean.
AVERAGE(number1, [number2], ...)
Category: Aggregation
AVERAGEIF
★★☆Returns average for values matching a condition.
AVERAGEIF(range, criteria, [average_range])
Category: Aggregation
AVERAGEIFS
★★☆Returns average for values matching multiple conditions.
AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Category: Aggregation
COUNT
★☆☆Counts cells that contain numbers.
COUNT(value1, [value2], ...)
Category: Aggregation
COUNTA
★☆☆Counts non-empty cells.
COUNTA(value1, [value2], ...)
Category: Aggregation
COUNTBLANK
★☆☆Counts blank cells in a range.
COUNTBLANK(range)
Category: Aggregation
COUNTIF
★☆☆Counts cells matching a condition.
COUNTIF(range, criteria)
Category: Aggregation
COUNTIFS
★★☆Counts cells matching multiple conditions.
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Category: Aggregation
MAX
★☆☆Returns the largest value.
MAX(number1, [number2], ...)
Category: Aggregation
MIN
★☆☆Returns the smallest value.
MIN(number1, [number2], ...)
Category: Aggregation
LARGE
★★☆Returns the k-th largest value in an array.
LARGE(array, k)
Category: Aggregation
SMALL
★★☆Returns the k-th smallest value in an array.
SMALL(array, k)
Category: Aggregation
RANK.EQ
★★☆Returns the rank of a number in a list.
RANK.EQ(number, ref, [order])
Category: Aggregation
IF
★☆☆Basic conditional branching function.
IF(logical_test, value_if_true, value_if_false)
Category: Conditional
IFS
★★☆Evaluates multiple conditions in order.
IFS(logical_test1, value_if_true1, ...)
Category: Conditional
IFERROR
★★☆Returns fallback value when formula errors.
IFERROR(value, value_if_error)
Category: Conditional
IFNA
★★☆Returns fallback value for #N/A errors.
IFNA(value, value_if_na)
Category: Conditional
AND
★☆☆Returns TRUE when all conditions are TRUE.
AND(logical1, [logical2], ...)
Category: Logical
OR
★☆☆Returns TRUE when any condition is TRUE.
OR(logical1, [logical2], ...)
Category: Logical
NOT
★☆☆Reverses a logical value.
NOT(logical)
Category: Logical
SWITCH
★★☆Matches expression to values and returns mapped result.
SWITCH(expression, value1, result1, [default])
Category: Conditional
CHOOSE
★★☆Returns a value from a list by index.
CHOOSE(index_num, value1, [value2], ...)
Category: Conditional
VLOOKUP
★☆☆Looks up a value in the first column and returns matching value.
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Category: Lookup
HLOOKUP
★★☆Looks up a value in first row and returns matching value.
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Category: Lookup
XLOOKUP
★★☆Modern lookup function with flexible matching.
XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found])
Category: Lookup
LOOKUP
★★☆Performs vector lookup in sorted data.
LOOKUP(lookup_value, lookup_vector, [result_vector])
Category: Lookup
INDEX
★★☆Returns value from array by row/column position.
INDEX(array, row_num, [column_num])
Category: Lookup
MATCH
★★☆Returns relative position of lookup value in a range.
MATCH(lookup_value, lookup_array, [match_type])
Category: Lookup
XMATCH
★★★Enhanced MATCH with additional matching/search options.
XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])
Category: Lookup
OFFSET
★★★Returns reference offset from a starting reference.
OFFSET(reference, rows, cols, [height], [width])
Category: Lookup
INDIRECT
★★★Converts text to a cell reference.
INDIRECT(ref_text, [a1])
Category: Lookup
ROW
★☆☆Returns row number of a reference.
ROW([reference])
Category: Lookup
ROWS
★☆☆Returns number of rows in an array.
ROWS(array)
Category: Lookup
COLUMN
★☆☆Returns column number of a reference.
COLUMN([reference])
Category: Lookup
COLUMNS
★☆☆Returns number of columns in an array.
COLUMNS(array)
Category: Lookup
LEFT
★☆☆Returns leftmost characters from text.
LEFT(text, [num_chars])
Category: Text
RIGHT
★☆☆Returns rightmost characters from text.
RIGHT(text, [num_chars])
Category: Text
MID
★☆☆Returns characters from middle of text.
MID(text, start_num, num_chars)
Category: Text
LEN
★☆☆Returns the number of characters in text.
LEN(text)
Category: Text
FIND
★★☆Finds text position (case-sensitive).
FIND(find_text, within_text, [start_num])
Category: Text
SEARCH
★★☆Finds text position (case-insensitive).
SEARCH(find_text, within_text, [start_num])
Category: Text
REPLACE
★★☆Replaces part of text based on position.
REPLACE(old_text, start_num, num_chars, new_text)
Category: Text
SUBSTITUTE
★★☆Substitutes occurrences of text with new text.
SUBSTITUTE(text, old_text, new_text, [instance_num])
Category: Text
TEXT
★★☆Formats value as text using a format code.
TEXT(value, format_text)
Category: Text
TEXTJOIN
★★☆Joins text values with a delimiter.
TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)
Category: Text
CONCAT
★☆☆Concatenates multiple text values.
CONCAT(text1, [text2], ...)
Category: Text
CONCATENATE
★☆☆Legacy function to concatenate text values.
CONCATENATE(text1, [text2], ...)
Category: Text
TRIM
★☆☆Removes extra spaces from text.
TRIM(text)
Category: Text
CLEAN
★★☆Removes non-printable characters.
CLEAN(text)
Category: Text
UPPER
★☆☆Converts text to uppercase.
UPPER(text)
Category: Text
LOWER
★☆☆Converts text to lowercase.
LOWER(text)
Category: Text
PROPER
★☆☆Capitalizes the first letter of each word.
PROPER(text)
Category: Text
VALUE
★★☆Converts text that represents a number into number.
VALUE(text)
Category: Text
TODAY
★☆☆Returns current date.
TODAY()
Category: Date/Time
NOW
★☆☆Returns current date and time.
NOW()
Category: Date/Time
DATE
★☆☆Builds a date from year, month, day.
DATE(year, month, day)
Category: Date/Time
TIME
★☆☆Builds a time from hour, minute, second.
TIME(hour, minute, second)
Category: Date/Time
YEAR
★☆☆Extracts year from a date.
YEAR(serial_number)
Category: Date/Time
MONTH
★☆☆Extracts month from a date.
MONTH(serial_number)
Category: Date/Time
DAY
★☆☆Extracts day from a date.
DAY(serial_number)
Category: Date/Time
WEEKDAY
★★☆Returns day-of-week number.
WEEKDAY(serial_number, [return_type])
Category: Date/Time
WEEKNUM
★★☆Returns week number in a year.
WEEKNUM(serial_number, [return_type])
Category: Date/Time
EDATE
★★☆Returns date shifted by specified months.
EDATE(start_date, months)
Category: Date/Time
EOMONTH
★★☆Returns last day of month shifted by months.
EOMONTH(start_date, months)
Category: Date/Time
DATEDIF
★★☆Returns difference between dates in selected unit.
DATEDIF(start_date, end_date, unit)
Category: Date/Time
NETWORKDAYS
★★☆Returns number of working days between dates.
NETWORKDAYS(start_date, end_date, [holidays])
Category: Date/Time
NETWORKDAYS.INTL
★★★Returns working days with customizable weekends.
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
Category: Date/Time
WORKDAY
★★☆Returns date shifted by working days.
WORKDAY(start_date, days, [holidays])
Category: Date/Time
WORKDAY.INTL
★★★Returns workday-based date with customizable weekends.
WORKDAY.INTL(start_date, days, [weekend], [holidays])
Category: Date/Time
ROUND
★☆☆Rounds a number to specified digits.
ROUND(number, num_digits)
Category: Math
ROUNDUP
★☆☆Rounds a number up.
ROUNDUP(number, num_digits)
Category: Math
ROUNDDOWN
★☆☆Rounds a number down.
ROUNDDOWN(number, num_digits)
Category: Math
INT
★☆☆Rounds number down to nearest integer.
INT(number)
Category: Math
MROUND
★★☆Rounds number to nearest specified multiple.
MROUND(number, multiple)
Category: Math
CEILING
★★☆Rounds number up to nearest multiple.
CEILING(number, significance)
Category: Math
FLOOR
★★☆Rounds number down to nearest multiple.
FLOOR(number, significance)
Category: Math
ABS
★☆☆Returns absolute value.
ABS(number)
Category: Math
MOD
★☆☆Returns remainder after division.
MOD(number, divisor)
Category: Math
SUMPRODUCT
★★★Returns sum of products of arrays.
SUMPRODUCT(array1, [array2], ...)
Category: Math
PRODUCT
★☆☆Returns product of given numbers.
PRODUCT(number1, [number2], ...)
Category: Math
RAND
★☆☆Returns random number between 0 and 1.
RAND()
Category: Math
RANDBETWEEN
★☆☆Returns random integer between two numbers.
RANDBETWEEN(bottom, top)
Category: Math
FILTER
★★☆Filters rows using include condition.
FILTER(array, include, [if_empty])
Category: Dynamic Array
SORT
★★☆Sorts an array by specified index/order.
SORT(array, [sort_index], [sort_order], [by_col])
Category: Dynamic Array
SORTBY
★★★Sorts array by another array.
SORTBY(array, by_array1, [sort_order1], ...)
Category: Dynamic Array
UNIQUE
★★☆Returns unique values from a range.
UNIQUE(array, [by_col], [exactly_once])
Category: Dynamic Array
SEQUENCE
★★☆Generates sequential numbers in an array.
SEQUENCE(rows, [columns], [start], [step])
Category: Dynamic Array
ISBLANK
★☆☆Checks whether value is blank.
ISBLANK(value)
Category: Information
ISNUMBER
★☆☆Checks whether value is a number.
ISNUMBER(value)
Category: Information
ISTEXT
★☆☆Checks whether value is text.
ISTEXT(value)
Category: Information
ISERROR
★★☆Checks whether value is any error.
ISERROR(value)
Category: Information
ISNA
★★☆Checks whether value is #N/A error.
ISNA(value)
Category: Information