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.
|