Home › Excel formulas › Statistical functions
Excel Statistical Functions: Full List with Examples
Statistical functions count, average, rank and measure spread in your data. COUNTIF, AVERAGEIF, MAX, MIN and RANK are the everyday ones. Open any function for its syntax, arguments, a worked example and a free practice spreadsheet.
| Function | What it does |
|---|---|
| COUNT | Counts how many cells in a range contain numbers. |
| COUNTA | Counts how many cells in a range are not empty. |
| COUNTBLANK | Counts how many cells in a range are empty. |
| COUNTIF | Counts how many cells in a range match a condition. |
| COUNTIFS | Like COUNTIF, but can check multiple conditions at once. |
| MAX | Returns the largest number in a set. |
| MIN | Returns the smallest number in a set. |
| MAXIFS | Returns the largest number in a range that meets given conditions. |
| MINIFS | Returns the smallest number in a range that meets given conditions. |
| MEDIAN | Returns the middle value in a set of numbers. |
| MODE | Returns the most frequently occurring number in a set. |
| STDEV | Measures how spread out a set of numbers is from the average. |
| VAR | Measures the variance of a set of numbers. |
| RANK | Returns the rank of a number within a list of numbers. |
| LARGE | Returns the k-th largest value in a set — e.g. the 2nd biggest sale. |
| SMALL | Returns the k-th smallest value in a set. |
| NORM.DIST | Returns the normal distribution for a given mean and standard deviation. |
| NORM.INV | Returns the inverse of the normal cumulative distribution. |
| NORM.S.DIST | Returns the standard normal distribution. |
| NORM.S.INV | Returns the inverse of the standard normal distribution. |
| T.DIST | Returns the Student's t-distribution. |
| T.INV | Returns the inverse of the Student's t-distribution. |
| CHISQ.DIST | Returns the chi-squared distribution. |
| CHISQ.INV | Returns the inverse of the chi-squared distribution. |
| F.DIST | Returns the F probability distribution. |
| F.INV | Returns the inverse of the F probability distribution. |
| BETA.DIST | Returns the beta distribution. |
| BETA.INV | Returns the inverse of the beta distribution. |
| GAMMA.DIST | Returns the gamma distribution. |
| GAMMA.INV | Returns the inverse of the gamma cumulative distribution. |
| BINOM.DIST | Returns the individual term binomial distribution probability. |
| BINOM.INV | Returns the smallest value where the binomial distribution is >= a criterion. |
| POISSON.DIST | Returns the Poisson distribution. |
| WEIBULL.DIST | Returns the Weibull distribution. |
| EXPON.DIST | Returns the exponential distribution. |
| HYPGEOM.DIST | Returns the hypergeometric distribution. |
| LOGNORM.DIST | Returns the lognormal distribution. |
| LOGNORM.INV | Returns the inverse of the lognormal distribution. |
| NEGBINOM.DIST | Returns the negative binomial distribution. |
| CONFIDENCE.NORM | Returns the confidence interval for a population mean using a normal distribution. |
| CONFIDENCE.T | Returns the confidence interval for a population mean using a Student's t-distribution. |
| PERCENTILE.INC | Returns the k-th percentile of values in a range, inclusive. |
| PERCENTILE.EXC | Returns the k-th percentile of values in a range, exclusive. |
| QUARTILE.INC | Returns the quartile of a data set, inclusive. |
| QUARTILE.EXC | Returns the quartile of a data set, exclusive. |
| RANK.EQ | Returns the rank of a number, giving equal values the same top rank. |
| RANK.AVG | Returns the rank of a number, averaging the rank for equal values. |
| STDEV.S | Estimates standard deviation based on a sample. |
| STDEV.P | Calculates standard deviation based on an entire population. |
| VAR.S | Estimates variance based on a sample. |
| VAR.P | Calculates variance based on an entire population. |
| COVARIANCE.P | Returns population covariance between two data sets. |
| COVARIANCE.S | Returns sample covariance between two data sets. |
| CORREL | Returns the correlation coefficient between two data sets. |
| PEARSON | Returns the Pearson product-moment correlation coefficient. |
| RSQ | Returns the square of the Pearson correlation coefficient. |
| SLOPE | Returns the slope of a linear regression line. |
| INTERCEPT | Returns the intercept of a linear regression line. |
| FORECAST.LINEAR | Predicts a future value along a linear trend. |
| TREND | Returns values along a linear trend line. |
| GROWTH | Returns values along an exponential growth trend. |
| LINEST | Returns statistics describing a linear regression line. |
| LOGEST | Returns statistics describing an exponential curve. |
| GEOMEAN | Returns the geometric mean of a set of numbers. |
| HARMEAN | Returns the harmonic mean of a set of numbers. |
| TRIMMEAN | Returns the mean of a data set, excluding a percentage from each end. |
| SKEW | Returns the skewness of a distribution — how lopsided it is. |
| SKEW.P | Returns the skewness of a distribution based on a population. |
| KURT | Returns the kurtosis of a data set — how peaked or flat it is. |
| DEVSQ | Returns the sum of squared deviations from the mean. |
| AVEDEV | Returns the average of absolute deviations from the mean. |
| MODE.SNGL | Returns the most frequently occurring value in a data set. |
| MODE.MULT | Returns an array of the most frequently occurring values. |
| FREQUENCY | Shows how often values occur within ranges (bins). |
| PERMUT | Returns the number of permutations for a set of objects. |
| PERMUTATIONA | Returns the number of permutations, allowing repeats. |
| COMBIN | Returns the number of combinations for a set of objects. |
| COMBINA | Returns the number of combinations, allowing repeats. |
| FISHER | Returns the Fisher transformation. |
| FISHERINV | Returns the inverse of the Fisher transformation. |
| STANDARDIZE | Returns a normalized (z-score) value. |
| PROB | Returns the probability that values fall within a range. |
| CHISQ.TEST | Returns the chi-squared test for independence. |
| T.TEST | Returns the probability from a Student's t-test. |
| F.TEST | Returns the result of an F-test comparing variances. |
| Z.TEST | Returns the one-tailed probability of a z-test. |
| T.DIST.2T | Returns the two-tailed Student's t-distribution. |
| T.DIST.RT | Returns the right-tailed Student's t-distribution. |
| CHISQ.DIST.RT | Returns the right-tailed chi-squared distribution. |
| F.DIST.RT | Returns the right-tailed F probability distribution. |
| F.INV.RT | Returns the inverse of the right-tailed F distribution. |
| CHISQ.INV.RT | Returns the inverse of the right-tailed chi-squared distribution. |
| GAMMA | Returns the gamma function value. |
| GAMMALN | Returns the natural logarithm of the gamma function. |
| GAMMALN.PRECISE | Returns a more precise natural logarithm of the gamma function. |
| PHI | Returns the value of the density function for a standard normal distribution. |
| AVERAGEA | Averages values, treating text and FALSE as 0 and TRUE as 1. |
| MAXA | Returns the largest value, treating text and FALSE as 0 and TRUE as 1. |
| MINA | Returns the smallest value, treating text and FALSE as 0 and TRUE as 1. |
| STDEVA | Estimates standard deviation from a sample, including text and logical values. |
| STDEVPA | Calculates standard deviation from a population, including text and logical values. |
| VARA | Estimates variance from a sample, including text and logical values. |
| VARPA | Calculates variance from a population, including text and logical values. |
| RANK + IF (conditional rank) | A workaround using SUMPRODUCT to rank a value only among rows that meet a certain condition, since RANK alone can't filter. |
| COUNTIFS with OR logic (multiple SUMs) | COUNTIFS only supports AND logic natively — adding two COUNTIFS together is the standard workaround for an OR condition. |
| AVERAGE + IFERROR | Wraps AVERAGE in IFERROR to avoid a #DIV/0! error when the range is empty. |
| Two COUNTIFs multiplied (AND workaround) | COUNTIFS natively supports AND logic across multiple ranges in one formula (the correct, simpler alternative to nesting COUNTIF calls). |
| COUNTIF + ISNUMBER (data quality check) | Counts only the cells that genuinely contain numbers, catching text-formatted numbers that COUNT would miss. |
Practice Statistical functions free
Type formulas in a real spreadsheet and get instant feedback.
Start practice → Formulas cheat sheetFrequently asked questions
What are the main Excel Statistical functions?
Cellgrids lists 108 Excel Statistical functions. Popular ones include COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS. Each has its own page with syntax, arguments and an example.
How can I practice Excel Statistical functions online?
Open the free live spreadsheet on Cellgrids, type the function in a cell and check your answer. No Excel install or sign-up is needed to start.
Which Excel Statistical function should a beginner learn first?
Start with COUNT. Counts how many cells in a range contain numbers.