SUM
The SUM formula adds up a range of numbers.
=SUM(range)
Excel Cheatsheet
Find the formula you need, copy its syntax, and get back to your spreadsheet.
No matching formulas. Try another name or keyword.
Math & counting
AVERAGE
The AVERAGE formula calculates the average of a range of numbers.
=AVERAGE(range)MAX
The MAX formula returns the largest number in a range.
=MAX(range)MIN
The MIN formula returns the smallest number in a range.
=MIN(range)COUNT
The COUNT formula counts the number of cells in a range that contain numbers.
=COUNT(range)COUNTA
The COUNTA formula counts the number of non-empty cells in a range.
=COUNTA(range)Lookups
VLOOKUP
The VLOOKUP formula searches for a value in the first column of a table and returns a corresponding value from the specified column.
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])HLOOKUP
The HLOOKUP formula searches for a value in the first row of a table and returns a corresponding value from the specified row.
=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])INDEX
The INDEX formula returns the value of a cell in a specified row and column of a range.
=INDEX(array, row_num, col_num)MATCH
The MATCH formula searches for a value in a range and returns its relative position.
=MATCH(lookup_value, lookup_array, [match_type])Logic
IF
The IF formula performs a logical test and returns one value if the test is true and another value if the test is false.
=IF(logical_test, value_if_true, value_if_false)AND
The AND formula checks if all conditions are true and returns TRUE if they are, otherwise it returns FALSE.
=AND(condition1, condition2, ...)OR
The OR formula checks if at least one condition is true and returns TRUE if it is, otherwise it returns FALSE.
=OR(condition1, condition2, ...)NOT
The NOT formula reverses the value of a logical argument (TRUE becomes FALSE and vice versa).
=NOT(logical)IFERROR
The IFERROR formula returns a custom result when a formula generates an error, and a standard result when no error is detected.
=IFERROR(value, value_if_error)Text
CONCATENATE
The CONCATENATE formula combines two or more text strings into one string.
=CONCATENATE(text1, text2, ...)LEFT
The LEFT formula returns a specified number of characters from the beginning of a text string.
=LEFT(text, num_chars)RIGHT
The RIGHT formula returns a specified number of characters from the end of a text string.
=RIGHT(text, num_chars)LEN
The LEN formula returns the number of characters in a text string.
=LEN(text)Date & time
NOW
The NOW formula returns the current date and time.
=NOW()