
COUNT  Returns the number of numerical values in a supplied set of cells or values 
COUNTA  Returns the number of nonblanks in a supplied set of cells or values 
COUNTBLANK  Returns the number of blank cells in a supplied range 
COUNTIF  Returns the number of cells (of a supplied range), that satisfy a given criteria 
COUNTIFS  Returns the number of cells (of a supplied range), that satisfy a set of given criteria (New in Excel 2007) 
FREQUENCY  Returns an array showing the number of values from a supplied array, which fall into specified ranges 


MAX  Returns the largest value from a list of supplied numbers 
MAXA  Returns the largest value from a list of supplied values, counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1 
MAXIFS  Returns the largest value from a subset of values in a list that are specified according to one or more criteria. (New in Excel 2016) 
MIN  Returns the smallest value from a list of supplied numbers 
MINA  Returns the smallest value from a list of supplied values, counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1 
MINIFS  Returns the smallest value from a subset of values in a list that are specified according to one or more criteria. (New in Excel 2016) 
LARGE  Returns the Kth LARGEST value from a list of supplied numbers, for a given value K 
SMALL  Returns the Kth SMALLEST value from a list of supplied numbers, for a given value K 


PERCENTILE  Returns the K'th percentile of values in a supplied range, where K is in the range 0  1 (inclusive) (Replaced by Percentile.Inc function in Excel 2010) 
PERCENTILE.INC  Returns the K'th percentile of values in a supplied range, where K is in the range 0  1 (inclusive) (New in Excel 2010  replaces the Percentile function) 
PERCENTILE.EXC  Returns the K'th percentile of values in a supplied range, where K is in the range 0  1 (exclusive) (New in Excel 2010) 
QUARTILE  Returns the specified quartile of a set of supplied numbers, based on percentile value 0  1 (inclusive) (Replaced by Quartile.Inc function in Excel 2010) 
QUARTILE.INC  Returns the specified quartile of a set of supplied numbers, based on percentile value 0  1 (inclusive) (New in Excel 2010  replaces the Quartile function) 
QUARTILE.EXC  Returns the specified quartile of a set of supplied numbers, based on percentile value 0  1 (exclusive) (New in Excel 2010) 
RANK  Returns the statistical rank of a given value, within a supplied array of values (Replaced by Rank.Eq function in Excel 2010) 
RANK.EQ  Returns the Mode (the most frequently occurring value) of a list of supplied numbers (if more than one value has same rank, the top rank of that set is returned) (New in Excel 2010  replaces the Rank function) 
RANK.AVG  Returns the statistical rank of a given value, within a supplied array of values (if more than one value has same rank, the average rank is returned) (New in Excel 2010) 
PERCENTRANK  Returns the rank of a value in a data set, as a percentage (0  1 inclusive) (Replaced by Percentrank.Inc function in Excel 2010) 
PERCENTRANK.INC  Returns the rank of a value in a data set, as a percentage (0  1 inclusive) (New in Excel 2010  replaces the Percentrank function) 
PERCENTRANK.EXC  Returns the rank of a value in a data set, as a percentage (0  1 exclusive) (New in Excel 2010) 


AVERAGE  Returns the Average of a list of supplied numbers 
AVERAGEA  Returns the Average of a list of supplied numbers, counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1 
AVERAGEIF  Calculates the Average of the cells in a supplied range, that satisfy a given criteria (New in Excel 2007) 
AVERAGEIFS  Calculates the Average of the cells in a supplied range, that satisfy multiple criteria (New in Excel 2007) 
MEDIAN  Returns the Median (the middle value) of a list of supplied numbers 
MODE  Returns the Mode (the most frequently occurring value) of a list of supplied numbers (Replaced by Mode.Sngl function in Excel 2010) 
MODE.SNGL  Returns the Mode (the most frequently occurring value) of a list of supplied numbers (New in Excel 2010  replaces the Mode function) 
MODE.MULT  Returns a vertical array of the most frequently occurring values in an array or range of data (New in Excel 2010) 
GEOMEAN  Returns the geometric mean of a set of supplied numbers 
HARMEAN  Returns the harmonic mean of a set of supplied numbers 
TRIMMEAN  Returns the mean of the interior of a supplied set of values 


AVEDEV  Returns the average of the absolute deviations of data points from their mean 
DEVSQ  Returns the sum of the squares of the deviations of a set of data points from their sample mean 
STDEV  Returns the standard deviation of a supplied set of values (which represent a sample of a population) (Replaced by Stdev.S function in Excel 2010) 
STDEV.S  Returns the standard deviation of a supplied set of values (which represent a sample of a population) (New in Excel 2010  replaces the Stdev function) 
STDEVA  Returns the standard deviation of a supplied set of values (which represent a sample of a population), counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1 
STDEVP  Returns the standard deviation of a supplied set of values (which represent an entire population) (Replaced by Stdev.P function in Excel 2010) 
STDEV.P  Returns the standard deviation of a supplied set of values (which represent an entire population) (New in Excel 2010  replaces the Stdevp function) 
STDEVPA  Returns the standard deviation of a supplied set of values (which represent an entire population), counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1 
VAR  Returns the variance of a supplied set of values (which represent a sample of a population) (Replaced by Var.S function in Excel 2010) 
VAR.S  Returns the variance of a supplied set of values (which represent a sample of a population) (New in Excel 2010  replaces the Var function) 
VARA  Returns the variance of a supplied set of values (which represent a sample of a population), counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1 
VARP  Returns the variance of a supplied set of values (which represent an entire population) (Replaced by Var.P function in Excel 2010) 
VAR.P  Returns the variance of a supplied set of values (which represent an entire population) (New in Excel 2010  replaces the Varp function) 
VARPA  Returns the variance of a supplied set of values (which represent an entire population), counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1 
COVAR  Returns population covariance (i.e. the average of the products of deviations for each pair within two supplied data sets) (Replaced by Covariance.P function in Excel 2010) 
COVARIANCE.P  Returns population covariance (i.e. the average of the products of deviations for each pair within two supplied data sets) (New in Excel 2010  replaces the Covar function) 
COVARIANCE.S  Returns sample covariance (i.e. the average of the products of deviations for each pair within two supplied data sets) (New in Excel 2010) 


CONFIDENCE  Returns the confidence interval for a population mean, using a normal distribution (Replaced by Confidence.Norm function in Excel 2010) 
CONFIDENCE.NORM  Returns the confidence interval for a population mean, using a normal distribution (New in Excel 2010  replaces the Confidence function) 
CONFIDENCE.T  Returns the confidence interval for a population mean, using a Student's t distribution (New in Excel 2010) 


FORECAST  Predicts a future point on a linear trend line fitted to a supplied set of x and y values 
INTERCEPT  Calculates the best fit regression line, through a supplied series of x and y values and returns the value at which this line intercepts the yaxis 
LINEST  Returns statistical information describing the trend of the line of best fit, through a supplied series of x and y values 
SLOPE  Returns the slope of the linear regression line through a supplied series of x and y values 
TREND  Calculates the trend line through a given set of yvalues and returns additional yvalues for a supplied set of new xvalues 
GROWTH  Returns numbers in a exponential growth trend, based on a set of supplied x and y values 
LOGEST  Returns the parameters of an exponential trend for a supplied set of x and y values 
STEYX  Returns the standard error of the predicted yvalue for each x in the regression line for a set of supplied x and y values 