Function
 Description

AVERAGE
 Return the average. Ignore empty cells and cells that contain text.

AVERAGEA
 Return the average. The value of text is 0 and empty cells are ignored.

COUNT
 Count the number of numeric entries, text entries are ignored.

COUNTA
 Count the number of nonempty entries.

COUNTBLANK
 Return the number of empty cells.

COUNTIF
 Return the number of cells that meet the search criteria.

HLOOKUP
 Search for a specific value across the columns in the first row of an array. Return the value from a different row in the same column.

INDEX
 Return the content of a cell, specified by row and column number or an optional range name.

INDIRECT
 Return the reference specified by a text string.

LOOKUP
 Return the contents of a cell either from a onerow or onecolumn range or from an array.

MATCH
 Search an array and return the relative position of the found item.

MAX
 Return the maximum numeric value in a list of arguments.

MAXA
 Return the maximum numeric value in a list of arguments. The value of text is 0.

MIN
 Return the minimum numeric value in a list of arguments.

MINA
 Return the minimum numeric value in a list of arguments. The value of text is 0.

MEDIAN
 Return the median of a set of numbers.

MODE
 Return the most common value in a data set. If there are several values with the same frequency, it returns the smallest value. An error occurs when a value doesnâ€™t appear twice.

OFFSET
 Return the value of a cell offset by a certain number of rows and columns from a given reference point.

PRODUCT
 Return the product of the cells.

STDEV
 Estimate the standard deviation based on a sample.

STDEVA
 Estimate the standard deviation based on a sample. The value of text is 0.

STDEVP
 Calculate the standard deviation based on the entire population.

STDEVPA
 Calculate the standard deviation based on the entire population.

SUBTOTAL
 Calculate a specified function based on a subset created using AutoFilters.

SUM
 Return the sum of the cells.

SUMIF
 Calculate the sum for the cells that meet the search criteria.

VAR
 Estimate the variance based on a sample.

VARA
 Estimate the variance based on a sample. The value of text is 0.

VARP
 Estimate the variance based on the entire population.

VARPA
 Estimate the variance based on the entire population. The value of a text is 0.

VLOOKUP
 Search for a specific value across the rows in the first column of an array. Return the value from a different column in the same row.
