Math
SUM
Local name: SUM
Syntax
SUM(number1, [number2], ...)
Adds numbers, cells, or ranges and returns their total.
Excel Reference
Each card shows the function title, its local Excel name for the selected language, syntax, and a short description.
Math
Local name: SUM
Syntax
SUM(number1, [number2], ...)
Adds numbers, cells, or ranges and returns their total.
Statistics
Local name: AVERAGE
Syntax
AVERAGE(number1, [number2], ...)
Calculates the arithmetic mean of the supplied values.
Logic
Local name: IF
Syntax
IF(logical_test, value_if_true, value_if_false)
Returns one result when a condition is true and another when it is false.
Lookup
Local name: INDEX
Syntax
INDEX(array, row_num, [column_num])
Returns a value from a range based on a row and column position.
Lookup
Local name: MATCH
Syntax
MATCH(lookup_value, lookup_array, [match_type])
Finds the relative position of an item inside a row or column.
7 days of Excel intensive in Lake Como with pool sessions, mentorship, and hands-on projects.
Criteria
Local name: COUNTIF
Syntax
COUNTIF(range, criteria)
Counts how many cells in a range satisfy one condition.
Math
Local name: ROUND
Syntax
ROUND(number, num_digits)
Rounds a number to the number of digits you specify.
Date
Local name: TODAY
Syntax
TODAY()
Returns the current date and updates automatically when the sheet recalculates.