| 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 non-empty 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 one-row or one-column 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.
|
