Skip to content

Excel functions · 145 functions

Excel statistical and counting functions

Averages, counts, largest and smallest values, ranking, standard deviation and probability distributions. COUNTIF, COUNTIFS and AVERAGEIF are the most used for conditional counts and averages.

Functions explained in full

All functions

  • AVERAGEORTALAMAFull page

    Arithmetic mean.

    =AVERAGE(number1, [number2], ...)
  • AVERAGEIFEĞERORTALAMAFull page

    Average of the cells that meet a condition.

    =AVERAGEIF(range, criteria, [average_range])
  • AVERAGEIFSÇOKEĞERORTALAMAFull page

    Average of cells meeting multiple conditions.

    =AVERAGEIFS(average_range, criteria_range1, criteria1, ...)
  • COUNTBAĞ_DEĞ_SAYFull page

    Counts cells that contain numbers.

    =COUNT(value1, [value2], ...)
  • COUNTABAĞ_DEĞ_DOLU_SAYFull page

    Counts non-empty cells.

    =COUNTA(value1, [value2], ...)
  • COUNTBLANKBOŞLUKSAYFull page

    Counts empty cells.

    =COUNTBLANK(range)
  • COUNTIFEĞERSAYFull page

    Counts cells that meet a condition.

    =COUNTIF(range, criteria)
  • COUNTIFSÇOKEĞERSAYFull page

    Counts rows meeting multiple conditions.

    =COUNTIFS(criteria_range1, criteria1, ...)
  • LARGEBÜYÜKFull page

    k-th largest value.

    =LARGE(array, k)
  • MAXMAKFull page

    Largest value.

    =MAX(number1, [number2], ...)
  • MAXIFSÇOKEĞERMAKFull page

    Largest value among rows meeting conditions.

    =MAXIFS(max_range, criteria_range1, criteria1, ...)
  • MEDIANORTANCAFull page

    Median (the middle number when sorted).

    =MEDIAN(number1, [number2], ...)
  • MINMİNFull page

    Smallest value.

    =MIN(number1, [number2], ...)
  • MINIFSÇOKEĞERMİNFull page

    Smallest value among rows meeting conditions.

    =MINIFS(min_range, criteria_range1, criteria1, ...)
  • RANK.EQRANK.EŞİTFull page

    Rank; ties share the same rank.

    =RANK.EQ(number, ref, [order])
  • SMALLKÜÇÜKFull page

    k-th smallest value.

    =SMALL(array, k)
  • STDEV.SSTDSAPMA.SFull page

    Sample standard deviation.

    =STDEV.S(number1, [number2], ...)
  • AVEDEVORTSAP

    Average absolute deviation.

    =AVEDEV(number1, [number2], ...)
  • AVERAGEAORTALAMAA

    Mean counting text as 0 and logicals as 1/0.

    =AVERAGEA(value1, [value2], ...)
  • BETA.DISTBETA.DAĞ

    Beta distribution.

    =BETA.DIST(x, alpha, beta, cumulative, [A], [B])
  • BETA.INVBETA.TERS

    Inverse beta distribution.

    =BETA.INV(probability, alpha, beta, [A], [B])
  • BETADISTBETADAĞ

    Cumulative beta distribution.

    =BETADIST(x, alpha, beta, [A], [B])
  • BETAINVBETATERS

    Inverse beta distribution.

    =BETAINV(probability, alpha, beta, [A], [B])
  • BINOM.DISTBİNOM.DAĞ

    Binomial distribution.

    =BINOM.DIST(number_s, trials, probability_s, cumulative)
  • BINOM.DIST.RANGEBİNOM.DAĞ.ARALIK

    Probability of a trial result in a range.

    =BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2])
  • BINOM.INVBİNOM.TERS

    Smallest value whose cumulative binomial is ≥ alpha.

    =BINOM.INV(trials, probability_s, alpha)
  • BINOMDISTBİNOMDAĞ

    Binomial distribution.

    =BINOMDIST(number_s, trials, probability_s, cumulative)
  • CHIDISTKİKAREDAĞ

    Right-tailed chi-squared distribution.

    =CHIDIST(x, deg_freedom)
  • CHIINVKİKARETERS

    Inverse right-tailed chi-squared.

    =CHIINV(probability, deg_freedom)
  • CHISQ.DISTKİKARE.DAĞ

    Chi-squared distribution (left tail).

    =CHISQ.DIST(x, deg_freedom, cumulative)
  • CHISQ.DIST.RTKİKARE.DAĞ.SAĞK

    Right-tailed chi-squared distribution.

    =CHISQ.DIST.RT(x, deg_freedom)
  • CHISQ.INVKİKARE.TERS

    Inverse left-tailed chi-squared.

    =CHISQ.INV(probability, deg_freedom)
  • CHISQ.INV.RTKİKARE.TERS.SAĞK

    Inverse right-tailed chi-squared.

    =CHISQ.INV.RT(probability, deg_freedom)
  • CHISQ.TESTKİKARE.TEST

    Test for independence (p-value).

    =CHISQ.TEST(actual_range, expected_range)
  • CHITESTKİKARETEST

    Test for independence (p-value).

    =CHITEST(actual_range, expected_range)
  • CONFIDENCEGÜVENİRLİK

    Confidence interval half-width (normal).

    =CONFIDENCE(alpha, standard_dev, size)
  • CONFIDENCE.NORMGÜVENİLİRLİK.NORM

    Confidence interval half-width (normal).

    =CONFIDENCE.NORM(alpha, standard_dev, size)
  • CONFIDENCE.TGÜVENİLİRLİK.T

    Confidence interval half-width (t).

    =CONFIDENCE.T(alpha, standard_dev, size)
  • CORRELKORELASYON

    Correlation coefficient.

    =CORREL(array1, array2)
  • COVARKOVARYANS

    Population covariance.

    =COVAR(array1, array2)
  • COVARIANCE.PKOVARYANS.P

    Population covariance.

    =COVARIANCE.P(array1, array2)
  • COVARIANCE.SKOVARYANS.S

    Sample covariance.

    =COVARIANCE.S(array1, array2)
  • CRITBINOMKRİTİKBİNOM

    Smallest value whose cumulative binomial is ≥ alpha.

    =CRITBINOM(trials, probability_s, alpha)
  • DEVSQSAPKARE

    Sum of squared deviations.

    =DEVSQ(number1, [number2], ...)
  • EXPON.DISTÜSTEL.DAĞ

    Exponential distribution.

    =EXPON.DIST(x, lambda, cumulative)
  • EXPONDISTÜSTELDAĞ

    Exponential distribution.

    =EXPONDIST(x, lambda, cumulative)
  • F.DISTF.DAĞ

    F probability distribution (left tail).

    =F.DIST(x, deg_freedom1, deg_freedom2, cumulative)
  • F.DIST.RTF.DAĞ.SAĞK

    Right-tailed F distribution.

    =F.DIST.RT(x, deg_freedom1, deg_freedom2)
  • F.INVF.TERS

    Inverse left-tailed F distribution.

    =F.INV(probability, deg_freedom1, deg_freedom2)
  • F.INV.RTF.TERS.SAĞK

    Inverse right-tailed F distribution.

    =F.INV.RT(probability, deg_freedom1, deg_freedom2)
  • F.TEST

    F-test result.

    =F.TEST(array1, array2)
  • FDISTFDAĞ

    Right-tailed F distribution.

    =FDIST(x, deg_freedom1, deg_freedom2)
  • FINVFTERS

    Inverse right-tailed F distribution.

    =FINV(probability, deg_freedom1, deg_freedom2)
  • FISHER

    Fisher transformation.

    =FISHER(x)
  • FISHERINVFISHERTERS

    Inverse Fisher transformation.

    =FISHERINV(y)
  • FORECASTTAHMİN

    Predicts y for x by linear trend.

    =FORECAST(x, known_ys, known_xs)
  • FORECAST.LINEARTAHMİN.DOĞRUSAL

    Predicts y for x by linear trend.

    =FORECAST.LINEAR(x, known_ys, known_xs)
  • FREQUENCYSIKLIK

    Frequency distribution (vertical array).

    =FREQUENCY(data_array, bins_array)
  • FTEST

    F-test result.

    =FTEST(array1, array2)
  • GAMMAGAMA

    Gamma function.

    =GAMMA(x)
  • GAMMA.DISTGAMA.DAĞ

    Gamma distribution.

    =GAMMA.DIST(x, alpha, beta, cumulative)
  • GAMMA.INVGAMA.TERS

    Inverse gamma distribution.

    =GAMMA.INV(probability, alpha, beta)
  • GAMMADISTGAMADAĞ

    Gamma distribution.

    =GAMMADIST(x, alpha, beta, cumulative)
  • GAMMAINVGAMATERS

    Inverse gamma distribution.

    =GAMMAINV(probability, alpha, beta)
  • GAMMALNGAMALN

    Natural log of the gamma function.

    =GAMMALN(x)
  • GAMMALN.PRECISEGAMALN.DUYARLI

    Natural log of the gamma function.

    =GAMMALN.PRECISE(x)
  • GAUSS

    Probability between the mean and z.

    =GAUSS(z)
  • GEOMEANGEOORT

    Geometric mean.

    =GEOMEAN(number1, [number2], ...)
  • GROWTHBÜYÜME

    Values along an exponential trend (array).

    =GROWTH(known_ys, [known_xs], [new_xs], [const])
  • HARMEANHARORT

    Harmonic mean.

    =HARMEAN(number1, [number2], ...)
  • HYPGEOM.DISTHİPERGEOM.DAĞ

    Hypergeometric distribution.

    =HYPGEOM.DIST(sample_s, number_sample, population_s, number_pop, cumulative)
  • HYPGEOMDISTHİPERGEOMDAĞ

    Hypergeometric distribution.

    =HYPGEOMDIST(sample_s, number_sample, population_s, number_pop)
  • INTERCEPTKESMENOKTASI

    Intercept of the linear regression line.

    =INTERCEPT(known_ys, known_xs)
  • KURTBASIKLIK

    Kurtosis.

    =KURT(number1, [number2], ...)
  • LINESTDOT

    Linear regression coefficients (array).

    =LINEST(known_ys, [known_xs], [const], [stats])
  • LOGESTLOT

    Exponential curve coefficients (array).

    =LOGEST(known_ys, [known_xs], [const], [stats])
  • LOGINVLOGTERS

    Inverse lognormal distribution.

    =LOGINV(probability, mean, standard_dev)
  • LOGNORM.DISTLOGNORM.DAĞ

    Lognormal distribution.

    =LOGNORM.DIST(x, mean, standard_dev, cumulative)
  • LOGNORM.INVLOGNORM.TERS

    Inverse lognormal distribution.

    =LOGNORM.INV(probability, mean, standard_dev)
  • LOGNORMDISTLOGNORMDAĞ

    Cumulative lognormal distribution.

    =LOGNORMDIST(x, mean, standard_dev)
  • MAXAMAKA

    Largest value including text and logicals.

    =MAXA(value1, [value2], ...)
  • MINAMİNA

    Smallest value including text and logicals.

    =MINA(value1, [value2], ...)
  • MODEENÇOK_OLAN

    Most frequent value.

    =MODE(number1, [number2], ...)
  • MODE.MULTENÇOK_OLAN.ÇOK

    All most frequent values (vertical array).

    =MODE.MULT(number1, [number2], ...)
  • MODE.SNGLENÇOK_OLAN.TEK

    Most frequent value.

    =MODE.SNGL(number1, [number2], ...)
  • NEGBINOM.DISTNEGBİNOM.DAĞ

    Negative binomial distribution.

    =NEGBINOM.DIST(number_f, number_s, probability_s, cumulative)
  • NEGBINOMDISTNEGBİNOMDAĞ

    Negative binomial distribution.

    =NEGBINOMDIST(number_f, number_s, probability_s)
  • NORM.DISTNORM.DAĞ

    Normal distribution.

    =NORM.DIST(x, mean, standard_dev, cumulative)
  • NORM.INVNORM.TERS

    Inverse of the normal distribution.

    =NORM.INV(probability, mean, standard_dev)
  • NORM.S.DISTNORM.S.DAĞ

    Standard normal distribution.

    =NORM.S.DIST(z, cumulative)
  • NORM.S.INVNORM.S.TERS

    Inverse of the standard normal distribution.

    =NORM.S.INV(probability)
  • NORMDISTNORMDAĞ

    Normal distribution.

    =NORMDIST(x, mean, standard_dev, cumulative)
  • NORMINVNORMTERS

    Inverse of the normal distribution.

    =NORMINV(probability, mean, standard_dev)
  • NORMSDISTNORMSDAĞ

    Standard normal cumulative distribution.

    =NORMSDIST(z)
  • NORMSINVNORMSTERS

    Inverse of the standard normal distribution.

    =NORMSINV(probability)
  • PEARSON

    Pearson correlation coefficient.

    =PEARSON(array1, array2)
  • PERCENTILEYÜZDEBİRLİK

    k-th percentile (0–1).

    =PERCENTILE(array, k)
  • PERCENTILE.EXCYÜZDEBİRLİK.HRC

    k-th percentile, exclusive.

    =PERCENTILE.EXC(array, k)
  • PERCENTILE.INCYÜZDEBİRLİK.DHL

    k-th percentile, inclusive.

    =PERCENTILE.INC(array, k)
  • PERCENTRANKYÜZDERANK

    Percentage rank of a value.

    =PERCENTRANK(array, x, [significance])
  • PERCENTRANK.EXCYÜZDERANK.HRC

    Percentage rank, exclusive.

    =PERCENTRANK.EXC(array, x, [significance])
  • PERCENTRANK.INCYÜZDERANK.DHL

    Percentage rank, inclusive.

    =PERCENTRANK.INC(array, x, [significance])
  • PERMUTPERMÜTASYON

    Number of permutations.

    =PERMUT(number, number_chosen)
  • PERMUTATIONAPERMÜTASYONA

    Permutations with repetitions.

    =PERMUTATIONA(number, number_chosen)
  • PHI

    Standard normal density.

    =PHI(x)
  • POISSON

    Poisson distribution.

    =POISSON(x, mean, cumulative)
  • POISSON.DISTPOISSON.DAĞ

    Poisson distribution.

    =POISSON.DIST(x, mean, cumulative)
  • PROBOLASILIK

    Probability that values are between two limits.

    =PROB(x_range, prob_range, lower_limit, [upper_limit])
  • QUARTILEDÖRTTEBİRLİK

    Quartile (0–4).

    =QUARTILE(array, quart)
  • QUARTILE.EXCDÖRTTEBİRLİK.HRC

    Quartile (1–3), exclusive.

    =QUARTILE.EXC(array, quart)
  • QUARTILE.INCDÖRTTEBİRLİK.DHL

    Quartile (0–4), inclusive.

    =QUARTILE.INC(array, quart)
  • RANK

    Rank of a number in a list (0 = descending).

    =RANK(number, ref, [order])
  • RANK.AVGRANK.ORT

    Rank; ties get the average rank.

    =RANK.AVG(number, ref, [order])
  • RSQRKARE

    Coefficient of determination (R²).

    =RSQ(known_ys, known_xs)
  • SKEWÇARPIKLIK

    Sample skewness.

    =SKEW(number1, [number2], ...)
  • SKEW.PÇARPIKLIK.P

    Population skewness.

    =SKEW.P(number1, [number2], ...)
  • SLOPEEĞİM

    Slope of the linear regression line.

    =SLOPE(known_ys, known_xs)
  • STANDARDIZESTANDARTLAŞTIRMA

    Normalized value (z-score).

    =STANDARDIZE(x, mean, standard_dev)
  • STDEVSTDSAPMA

    Sample standard deviation.

    =STDEV(number1, [number2], ...)
  • STDEV.PSTDSAPMA.P

    Population standard deviation.

    =STDEV.P(number1, [number2], ...)
  • STDEVASTDSAPMAA

    Sample std. deviation including text and logicals.

    =STDEVA(value1, [value2], ...)
  • STDEVPSTDSAPMAS

    Population standard deviation.

    =STDEVP(number1, [number2], ...)
  • STDEVPASTDSAPMASA

    Population std. deviation including text and logicals.

    =STDEVPA(value1, [value2], ...)
  • STEYXSTHYX

    Standard error of the predicted y.

    =STEYX(known_ys, known_xs)
  • T.DISTT.DAĞ

    Student's t-distribution (left tail).

    =T.DIST(x, deg_freedom, cumulative)
  • T.DIST.2TT.DAĞ.2K

    Two-tailed Student's t-distribution.

    =T.DIST.2T(x, deg_freedom)
  • T.DIST.RTT.DAĞ.SAĞK

    Right-tailed Student's t-distribution.

    =T.DIST.RT(x, deg_freedom)
  • T.INVT.TERS

    Inverse left-tailed t-distribution.

    =T.INV(probability, deg_freedom)
  • T.INV.2TT.TERS.2K

    Inverse two-tailed t-distribution.

    =T.INV.2T(probability, deg_freedom)
  • T.TEST

    Probability of Student's t-test.

    =T.TEST(array1, array2, tails, type)
  • TDISTTDAĞ

    Student's t-distribution (1 or 2 tails).

    =TDIST(x, deg_freedom, tails)
  • TINVTTERS

    Inverse two-tailed t-distribution.

    =TINV(probability, deg_freedom)
  • TRENDEĞİLİM

    Values along a linear trend (array).

    =TREND(known_ys, [known_xs], [new_xs], [const])
  • TRIMMEANKIRPORTALAMA

    Mean excluding a percentage of outliers.

    =TRIMMEAN(array, percent)
  • TTEST

    Probability of Student's t-test.

    =TTEST(array1, array2, tails, type)
  • VAR

    Sample variance.

    =VAR(number1, [number2], ...)
  • VAR.P

    Population variance.

    =VAR.P(number1, [number2], ...)
  • VAR.S

    Sample variance.

    =VAR.S(number1, [number2], ...)
  • VARA

    Sample variance including text and logicals.

    =VARA(value1, [value2], ...)
  • VARPVARS

    Population variance.

    =VARP(number1, [number2], ...)
  • VARPAVARSA

    Population variance including text and logicals.

    =VARPA(value1, [value2], ...)
  • WEIBULL

    Weibull distribution.

    =WEIBULL(x, alpha, beta, cumulative)
  • WEIBULL.DISTWEIBULL.DAĞ

    Weibull distribution.

    =WEIBULL.DIST(x, alpha, beta, cumulative)
  • Z.TEST

    One-tailed z-test probability.

    =Z.TEST(array, x, [sigma])
  • ZTEST

    One-tailed z-test probability.

    =ZTEST(array, x, [sigma])

Excel functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free