Math
SUM
Returns the total of all the numbers in the cells, ranges, or values you give it.
Learn Excel, one formula at a time
Look up Excel functions and work through step-by-step lessons right in your browser.
Math
AVERAGE
Returns the arithmetic mean of the numbers in the cells or ranges you give it.
Math
COUNT
Returns how many of the given cells or values contain numbers.
Math
MIN
Returns the smallest number found in the cells or ranges you give it.
Math
MAX
Returns the largest number found in the cells or ranges you give it.
Logical
IF
Returns one result when a test is true and a different result when it is false.