Statistical
★ 90 · ◉ 18 · All versions
=MAX()
Returns the largest value in a set of values.
=MAX(number1, [number2], ...)
Daily Tasks
Reporting
Reporting
66 functions for this use case · out of 12 defined
Compatibility
★ 19 · ◉ 18 · Excel 2007 (Compatibility)
=SEC()
Returns the secant of an angle.
=SEC(number)
Reporting
Compatibility
★ 24 · ◉ 18 · Excel 2007 (Compatibility)
=TTEST()
Returns the probability associated with a Student's t-Test. Use T.TEST to determine whether two samples are likely to have come from the same two underlying populations that have the same mean. Results from the test shows if the difference is statistically significant or from chance. This function is provided for backward compatibility; consider using the T.TEST function instead.
=TTEST(array1,array2,tails,type)
Reporting
Compatibility
★ 24 · ◉ 18 · Excel 2007 (Compatibility)
=WEIBULL()
Returns the Weibull distribution. Use this distribution in reliability analysis, such as calculating a device's mean time to failure. This function is provided for backward compatibility; consider using the WEIBULL.DIST function instead.
=WEIBULL(x,alpha,beta,cumulative)
Reporting
Compatibility
★ 27 · ◉ 17 · Excel 2007 (Compatibility)
=ACOTH()
Returns the inverse hyperbolic cotangent of a number.
=ACOTH(number)
Reporting
Compatibility
★ 19 · ◉ 17 · Excel 2007 (Compatibility)
=CSCH()
Return the hyperbolic cosecant of an angle specified in radians.
=CSCH(number)
Reporting
Math & Trig
★ 85 · ◉ 16 · Excel 2010
=AGGREGATE()
The AGGREGATE function can apply different aggregate functions to a list or database with the option to ignore hidden rows and error values.
=AGGREGATE(function_num, options, ref1, [ref2], …)
Reporting
Ranking & Top N
Compatibility
★ 22 · ◉ 16 · Excel 2007 (Compatibility)
=COTH()
Return the hyperbolic cotangent of a hyperbolic angle.
=COTH(number)
Reporting
Statistical
★ 70 · ◉ 16 · Excel 2007
=COUNTIFS()
How to use the COUNTIFS function in Excel to apply criteria to cells, across multiple ranges, and count the number of times all criteria are met.
=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)
Daily Tasks
Conditional Aggregation
Compatibility
★ 13 · ◉ 15 · Excel 2007 (Compatibility)
=LOGINV()
Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard_dev. If p = LOGNORMDIST(x,...) then LOGINV(p,...) = x. Use the lognormal distribution to analyze logarithmically transformed data. For more information about the new function, see LOGNORM.INV function.
=LOGINV(probability, mean, standard_dev)
Reporting
Math & Trig
★ 100 · ◉ 15 · All versions
=SUM()
How to use the SUM function in Excel to add individual values, cell references, ranges, or a mix of all three.
=SUM(number1,[number2],...)
Daily Tasks
Reporting
Lookup & Reference
★ 80 · ◉ 15 · Excel 2021
=UNIQUE()
Learn about the UNIQUE function, which returns a list of unique values in a list or range. UNIQUE is in a class of functions called dynamic arrays.
=UNIQUE(array,[by_col],[exactly_once])
Daily Tasks
Reporting
Compatibility
★ 10 · ◉ 15 · Excel 2007 (Compatibility)
=ZTEST()
Returns the one-tailed probability-value of a z-test. For a given hypothesized population mean, μ0, ZTEST returns the probability that the sample mean would be greater than the average of observations in the data set (array) — that is, the observed sample mean.
=ZTEST(array,x,[sigma])
Reporting
Compatibility
★ 29 · ◉ 14 · Excel 2007 (Compatibility)
=ERFC.PRECISE()
Returns the complementary ERF function integrated between x and infinity.
=ERFC.PRECISE(x)
Reporting
Statistical
★ 90 · ◉ 14 · All versions
=MIN()
Returns the smallest number in a set of values.
=MIN(number1, [number2], ...)
Daily Tasks
Reporting
Compatibility
★ 15 · ◉ 14 · Excel 2007 (Compatibility)
=NORMSDIST()
Returns the standard normal cumulative distribution function.
=NORMSDIST(z)
Reporting
Compatibility
★ 14 · ◉ 14 · Excel 2007 (Compatibility)
=NUMBERVALUE()
Converts text to a number, in a locale-independent way.
=NUMBERVALUE(Text, [Decimal_separator], [Group_separator ])
Reporting
Compatibility
★ 21 · ◉ 14 · Excel 2007 (Compatibility)
=PERCENTRANK()
Returns the rank of a value in a data set as a percentage of the data set. This function can be used to evaluate the relative standing of a value within a data set. For example, you can use PERCENTRANK to evaluate the standing of an aptitude test score among all scores for the test. This function has been replaced with one or more new functions that may provide improved accuracy. Although this function is still available for backward compatibility, this function may not be available in future versions of Excel.
=PERCENTRANK(array,x,[significance])
Reporting
Math & Trig
★ 25 · ◉ 13 · Excel 365
=PERCENTOF()
PERCENTOF function
=PERCENTOF(data_subset,data_all)
Reporting
Rounding & Numeric
Compatibility
★ 23 · ◉ 13 · Excel 2007 (Compatibility)
=POISSON()
Returns the Poisson distribution. A common application of the Poisson distribution is predicting the number of events over a specific time, such as the number of cars arriving at a toll plaza in 1 minute. This function is provided for backward compatibility; consider using the POISSON.DIST function instead.
=POISSON(x,mean,cumulative)
Reporting
Cube
★ 35 · ◉ 12 · Excel 2007
=CUBEVALUE()
Returns an aggregated value from the cube.
=CUBEVALUE(connection, [member_expression1], [member_expression2], …)
Reporting
Dynamic Ranges & Dashboards
Compatibility
★ 12 · ◉ 12 · Excel 2007 (Compatibility)
=GAMMAINV()
Returns the inverse of the gamma cumulative distribution. If p = GAMMADIST(x,...), then GAMMAINV(p,...) = x. You can use this function to study a variable whose distribution may be skewed.
=GAMMAINV(probability,alpha,beta)
Reporting
Compatibility
★ 26 · ◉ 12 · Excel 2007 (Compatibility)
=STDEVP()
The STDEVP function calculates standard deviation based on the entire population given as arguments. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).
=STDEVP(number1,[number2],...)
Reporting
Math & Trig
★ 80 · ◉ 12 · All versions
=SUBTOTAL()
Returns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is created, you can modify it by editing the SUBTOTAL function.
=SUBTOTAL(function_num,ref1,[ref2],...)
Daily Tasks
Reporting
Statistical
★ 65 · ◉ 11 · All versions
=AVERAGE()
Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.
=AVERAGE(number1, [number2], ...)
Daily Tasks
Reporting
Compatibility
★ 18 · ◉ 11 · Excel 2007 (Compatibility)
=FDIST()
The FDIST function returns the (right-tailed) F probability distribution (degree of diversity) for two data sets. You can use this function to determine whether two data sets have different degrees of diversity.
=FDIST(x,deg_freedom1,deg_freedom2)
Reporting
Compatibility
★ 18 · ◉ 11 · Excel 2007 (Compatibility)
=ISO.CEILING()
ISO.CEILING returns a number that is rounded up to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. However, if the number or the significance is zero, zero is returned.
=ISO.CEILING(number, [significance])
Reporting
Math & Trig
★ 80 · ◉ 11 · All versions
=SUMPRODUCT()
How to use the SUMPRODUCT function in Excel, one of Excel’s math and trig functions, using multiplication, addition, subtraction, and/or division to return the sum of the products of corresponding ranges or arrays.
=SUMPRODUCT(array1, [array2], [array3], ...)
Conditional Aggregation
Reporting
Compatibility
★ 25 · ◉ 10 · Excel 2007 (Compatibility)
=ACOT()
Returns the principal value of the arccotangent, or inverse cotangent, of a number.
=ACOT(number)
Reporting
Compatibility
★ 16 · ◉ 10 · Excel 2007 (Compatibility)
=LOGNORMDIST()
Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev. Use this function to analyze data that has been logarithmically transformed. For more information about the new function, see LOGNORM.DIST function.
=LOGNORMDIST(x,mean,standard_dev)
Reporting
Compatibility
★ 12 · ◉ 10 · Excel 2007 (Compatibility)
=TDIST()
Returns the Percentage Points (probability) for the Student t-distribution where a numeric value (x) is a calculated value of t for which the Percentage Points are to be computed. The t-distribution is used in the hypothesis testing of small sample data sets. Use this function in place of a table of critical values for the t-distribution. For more information about the new functions, see T.DIST.2T function and T.DIST.RT function.
=TDIST(x,deg_freedom,tails)
Reporting
Compatibility
★ 11 · ◉ 10 · Excel 2007 (Compatibility)
=TINV()
Returns the two-tailed inverse of the Student's t-distribution. This function is provided for backward compatibility; consider using the T.INV.2T function instead.
=TINV(probability,deg_freedom)
Reporting
Compatibility
★ 15 · ◉ 9 · Excel 2007 (Compatibility)
=BINOMDIST()
Returns the individual term binomial distribution probability.
=BINOMDIST(number_s,trials,probability_s,cumulative)
Reporting
Compatibility
★ 28 · ◉ 9 · Excel 2007 (Compatibility)
=CONFIDENCE()
Returns the confidence interval for a population mean, using a normal distribution. The confidence interval is a range of values. Your sample mean, x, is at the center of this range and the range is x ± CONFIDENCE. For example, if x is the sample mean of delivery times for products ordered through the mail, x ± CONFIDENCE is a range of population means. For any population mean, μ0, in this range, the probability of obtaining a sample mean further from μ0 than x is greater than alpha; for any population mean, μ0, not in this range, the probability of obtaining a sample mean further from μ0 than x is less than alpha. In other words, assume that we use x, standard_dev, and size to construct a two-tailed test at significance level alpha of the hypothesis that the population mean is μ0. Then we will not reject that hypothesis if μ0 is in the confidence interval and will reject that hypothesis if μ0 is not in the confidence interval. The confidence interval does not allow us to infer that there is probability 1 – alpha that our next package will take a delivery time that is in the confidence interval. For more information about the new functions, see CONFIDENCE.NORM function and CONFIDENCE.T function.
=CONFIDENCE(alpha,standard_dev,size)
Reporting
Compatibility
★ 10 · ◉ 9 · Excel 2007 (Compatibility)
=COT()
Return the cotangent of an angle specified in radians.
=COT(number)
Reporting
Statistical
★ 70 · ◉ 9 · All versions
=COUNTA()
The COUNTA function counts the number of cells that are not empty in a range.
=COUNTA(value1, [value2], ...)
Daily Tasks
Reporting
Compatibility
★ 29 · ◉ 9 · Excel 2007 (Compatibility)
=COVAR()
Returns covariance, the average of the products of deviations for each data point pair in two data sets. Use covariance to determine the relationship between two data sets. For example, you can examine whether greater income accompanies greater levels of education.
=COVAR(array1,array2)
Reporting
Compatibility
★ 17 · ◉ 9 · Excel 2007 (Compatibility)
=CSC()
Returns the cosecant of an angle specified in radians.
=CSC(number)
Reporting
Compatibility
★ 24 · ◉ 9 · Excel 2007 (Compatibility)
=ERF.PRECISE()
Returns the error function.
=ERF.PRECISE(x)
Reporting
Compatibility
★ 17 · ◉ 9 · Excel 2007 (Compatibility)
=FINV()
Returns the inverse of the (right-tailed) F probability distribution. If p = FDIST(x,...), then FINV(p,...) = x. The F distribution can be used in an F-test that compares the degree of variability in two data sets. For example, you can analyze income distributions in the United States and Canada to determine whether the two countries have a similar degree of income diversity.
=FINV(probability,deg_freedom1,deg_freedom2)
Reporting
Compatibility
★ 28 · ◉ 9 · Excel 2007 (Compatibility)
=NORMDIST()
This function returns the normal distribution for the specified mean and standard deviation. This function has a very wide range of applications in statistics, including hypothesis testing.
=NORMDIST(x,mean,standard_dev,cumulative)
Reporting
Compatibility
★ 19 · ◉ 8 · Excel 2007 (Compatibility)
=CHIINV()
Returns the inverse of the right-tailed probability of the chi-squared distribution. If probability = CHIDIST(x,...), then CHIINV(probability,...) = x. Use this function to compare observed results with expected ones in order to decide whether your original hypothesis is valid.
=CHIINV(probability,deg_freedom)
Reporting
Statistical
★ 75 · ◉ 8 · All versions
=COUNT()
How to use the COUNT function in Excel to count the number of cells that contain numbers, and to count numbers within a list of arguments.
=COUNT(value1, [value2], ...)
Daily Tasks
Reporting
Compatibility
★ 24 · ◉ 8 · Excel 2007 (Compatibility)
=DBCS()
The function described in this Help topic converts half-width (single-byte) letters within a character string to full-width (double-byte) characters. The name of the function (and the characters that it converts) depends upon your language settings. For Japanese, this function changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters.
=DBCS(text)
Reporting
Statistical
★ 35 · ◉ 8 · All versions
=FREQUENCY()
The FREQUENCY function calculates how often values occur within a range of values, and then returns a vertical array of numbers. For example, use FREQUENCY to count the number of test scores that fall within ranges of scores.
=FREQUENCY(data_array, bins_array)
Conditional Aggregation
Reporting
Compatibility
★ 10 · ◉ 8 · Excel 2007 (Compatibility)
=FTEST()
Returns the result of an F-test. An F-test returns the two-tailed probability that the variances in array1 and array2 are not significantly different. Use this function to determine whether two samples have different variances.
=FTEST(array1,array2)
Reporting
Compatibility
★ 29 · ◉ 8 · Excel 2007 (Compatibility)
=GAMMADIST()
Returns the gamma distribution. You can use this function to study variables that may have a skewed distribution. The gamma distribution is commonly used in queuing analysis. This function is provided for backward compatibility; consider using the GAMMA.DIST function instead.
=GAMMADIST(x,alpha,beta,cumulative)
Reporting
Compatibility
★ 20 · ◉ 7 · Excel 2007 (Compatibility)
=CHIDIST()
Returns the right-tailed probability of the chi-squared distribution. The χ2 distribution is associated with a χ2 test. Use the χ2 test to compare observed and expected values. For example, a genetic experiment might hypothesize that the next generation of plants will exhibit a certain set of colors. By comparing the observed results with the expected ones, you can decide whether your original hypothesis is valid. This function is provided for backward compatibility; consider using the CHISQ.DIST.RT function instead.
=CHIDIST(x,deg_freedom)
Reporting
Compatibility
★ 28 · ◉ 7 · Excel 2007 (Compatibility)
=CHITEST()
Returns the value from the chi-squared (χ2) distribution for the statistic and the appropriate degrees of freedom. You can use χ2 tests to determine whether hypothesized results are verified by an experiment.
=CHITEST(actual_range,expected_range)
Reporting
Lookup & Reference
★ 55 · ◉ 7 · Excel 365
=GROUPBY()
The GROUPBY function in Excel allows you to create a summary of your data via a formula.
=GROUPBY(row_fields,values,function,[field_headers],[total_depth],[sort_order],[filter_array],[field_relationship])
Reporting
Compatibility
★ 15 · ◉ 7 · Excel 2007 (Compatibility)
=HYPGEOMDIST()
HYPGEOMDIST returns the probability of a given number of sample successes, given the sample size, population successes, and population size. Use HYPGEOMDIST for problems with a finite population, where each observation is either a success or a failure, and where each subset of a given size is chosen with equal likelihood.
=HYPGEOMDIST(sample_s,number_sample,population_s,number_pop)
Reporting
Compatibility
★ 19 · ◉ 7 · Excel 2007 (Compatibility)
=NEGBINOMDIST()
Returns the negative binomial distribution. NEGBINOMDIST returns the probability that there will be number_f failures before the number_s-th success, when the constant probability of a success is probability_s. This function is similar to the binomial distribution, except that the number of successes is fixed, and the number of trials is variable. Like the binomial, trials are assumed to be independent. For example, you need to find 10 people with excellent reflexes, and you know the probability that a candidate has these qualifications is 0.3. NEGBINOMDIST calculates the probability that you will interview a certain number of unqualified candidates before finding all 10 qualified candidates. For more information about the new function, see NEGBINOM.DIST function.
=NEGBINOMDIST(number_f,number_s,probability_s)
Reporting
Lookup & Reference
★ 50 · ◉ 7 · Excel 365
=PIVOTBY()
PIVOTBY function
=PIVOTBY(row_fields,col_fields,values,function,[field_headers],[row_total_depth],[row_sort_order],[col_total_depth],[col_sort_order],[filter_array],[relative_to])
Reporting
Math & Trig
★ 90 · ◉ 7 · Excel 2007
=SUMIFS()
How to use the SUMIFS function in Excel, one of Excel’s math and trig functions, to add arguments that meet multiple criteria.
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Daily Tasks
Conditional Aggregation
Compatibility
★ 23 · ◉ 7 · Excel 2007 (Compatibility)
=VARP()
Calculates variance based on the entire population.
=VARP(number1,[number2],...)
Reporting
Statistical
★ 60 · ◉ 6 · Excel 2007
=AVERAGEIFS()
Returns the average (arithmetic mean) of all cells that meet multiple criteria.
=AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Daily Tasks
Conditional Aggregation
Compatibility
★ 29 · ◉ 6 · Excel 2007 (Compatibility)
=BETAINV()
The BETAINV functionr eturns the inverse of the cumulative beta probability density function for a specified beta distribution.
=BETAINV(probability,alpha,beta,[A],[B])
Reporting
Compatibility
★ 15 · ◉ 6 · Excel 2007 (Compatibility)
=COMBINA()
Returns the number of combinations (with repetitions) for a given number of items.
=COMBINA(number, number_chosen)
Reporting
Lookup & Reference
★ 45 · ◉ 6 · All versions
=GETPIVOTDATA()
The GETPIVOTDATA function returns visible data from a PivotTable.
=GETPIVOTDATA(data_field, pivot_table, [field1, item1, field2, item2], ...)
Lookup & Retrieval
Reporting
Compatibility
★ 16 · ◉ 6 · Excel 2007 (Compatibility)
=NORMSINV()
Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one. This function is provided for backward compatibility; consider using the NORM.S.INV function instead.
=NORMSINV(probability)
Reporting
Compatibility
★ 20 · ◉ 5 · Excel 2007 (Compatibility)
=BETADIST()
Returns the cumulative beta probability density function. The beta distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television.
=BETADIST(x,alpha,beta,[A],[B])
Reporting
Compatibility
★ 21 · ◉ 5 · Excel 2007 (Compatibility)
=SECH()
Returns the hyperbolic secant of an angle.
=SECH(number)
Reporting
Compatibility
★ 12 · ◉ 4 · Excel 2007 (Compatibility)
=REGISTER.ID()
Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered. If the DLL or code resource has not been registered, this function registers the DLL or code resource and then returns the register ID. REGISTER.ID can be used on worksheets (unlike REGISTER), but you cannot specify a function name and argument names with REGISTER.ID. For more information about DLLs and code resources and data types, see Using the CALL and REGISTER functions.
=REGISTER.ID(module_text,procedure,[type_text])
Reporting
Database
★ 35 · ◉ 3 · All versions
=DSUM()
In a list or database, DSUM provides the sum of the numbers in fields (columns) of records that match your specified conditions.
=DSUM(database, field, criteria)
Conditional Aggregation
Reporting
Financial
★ 12 · ◉ 3 · Excel 2007 (Compatibility)
=EUROCONVERT()
Converts a number to euros, converts a number from euros to a euro member currency, or converts a number from one euro member currency to another by using the euro as an intermediary (triangulation). The currencies available for conversion are those of European Union (EU) members that have adopted the euro. The function uses fixed conversion rates that are established by the EU. If this function is not available, and returns the #NAME? error, install and load the Euro Currency Tools Add-in. Install and load the Euro Currency Tools Add-in add-in
=EUROCONVERT(number,source,target,full_precision,triangulation_precision)
Reporting
Compatibility
★ 27 · ◉ 2 · Excel 2007 (Compatibility)
=CRITBINOM()
CRITBINOM function
=CRITBINOM(trials,probability_s,alpha)
Reporting