Statistical
★ 90 · ◉ 424 · All versions
=MIN()
Returns the smallest number among the input numbers or ranges
=MIN(number1, [number2], ...)
Daily Tasks
Reporting
Reporting
66 functions for this use case · out of 12 defined
Math & Trig
★ 80 · ◉ 409 · All versions
=SUMPRODUCT()
Sums the products
=SUMPRODUCT(array1, [array2], ...)
Conditional Aggregation
Reporting
Math & Trig
★ 90 · ◉ 404 · Excel 2007
=SUMIFS()
Sums with one or more conditions
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Daily Tasks
Conditional Aggregation
Lookup & Reference
★ 80 · ◉ 394 · Excel 2021
=UNIQUE()
Returns the distinct values of a range without duplicates
=UNIQUE(array, [by_col], [exactly_once])
Daily Tasks
Reporting
Statistical
★ 75 · ◉ 362 · All versions
=COUNT()
Counts numeric values only
=COUNT(value1, [value2], ...)
Daily Tasks
Reporting
Statistical
★ 65 · ◉ 346 · All versions
=AVERAGE()
Arithmetic mean
=AVERAGE(number1, [number2], ...)
Daily Tasks
Reporting
Statistical
★ 70 · ◉ 344 · Excel 2007
=COUNTIFS()
Count with one condition or multiple conditions
=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Daily Tasks
Conditional Aggregation
Statistical
★ 70 · ◉ 333 · All versions
=COUNTA()
Counts the cells that are not empty
=COUNTA(value1, [value2], ...)
Daily Tasks
Reporting
Lookup & Reference
★ 50 · ◉ 289 · Excel 365
=PIVOTBY()
Groups data simultaneously by row and column and creates a two-dimensional report similar to a PivotTable
=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
Lookup & Reference
★ 55 · ◉ 284 · Excel 365
=GROUPBY()
Groups data by one or more columns and returns a sum, count, or another calculation for each group
=GROUPBY(row_fields, values, function, [field_headers], [total_depth], [sort_order], [filter_array], [field_relationship])
Reporting
Lookup & Reference
★ 45 · ◉ 226 · All versions
=GETPIVOTDATA()
Returns a specific number from inside a PivotTable based on field and item names
=GETPIVOTDATA(data_field, pivot_table, [field1, item1, field2, item2], ...)
Lookup & Retrieval
Reporting
Statistical
★ 35 · ◉ 201 · All versions
=FREQUENCY()
Counts the numbers in each interval
=FREQUENCY(data_array, bins_array)
Conditional Aggregation
Reporting
Database
★ 35 · ◉ 199 · All versions
=DSUM()
Sums the numbers in a column for the rows that match the criteria
=DSUM(database, field, criteria)
Conditional Aggregation
Reporting
Cube
★ 35 · ◉ 196 · Excel 2007
=CUBEVALUE()
Returns a computed value from the data model or cube
=CUBEVALUE(connection, [member_expression1], [member_expression2], ...)
Reporting
Dynamic Ranges & Dashboards
Math & Trig
★ 25 · ◉ 172 · Excel 365
=PERCENTOF()
Calculates the share of a subset relative to the total
=PERCENTOF(data_subset, data_all)
Reporting
Rounding & Numeric
Compatibility
★ 28 · ◉ 61 · Excel 2007 (Compatibility)
=NORMDIST()
Normal distribution (compatibility) — cumulative or probability density
=NORMDIST(x, mean, standard_dev, cumulative)
Reporting
Compatibility
★ 23 · ◉ 61 · Excel 2007 (Compatibility)
=POISSON()
Returns the Poisson distribution (compatibility)
=POISSON(x, mean, cumulative)
Reporting
Compatibility
★ 21 · ◉ 59 · Excel 2007 (Compatibility)
=PERCENTRANK()
Returns the percent rank of a value in a data set (compatibility) — between 0 and 1
=PERCENTRANK(array, x, [significance])
Reporting
Compatibility
★ 19 · ◉ 52 · Excel 2007 (Compatibility)
=CSCH()
Returns the hyperbolic cosecant of a number
=CSCH(number)
Reporting
Compatibility
★ 29 · ◉ 52 · Excel 2007 (Compatibility)
=ERFC.PRECISE()
Returns the complementary error function with high precision
=ERFC.PRECISE(x)
Reporting
Compatibility
★ 18 · ◉ 51 · Excel 2007 (Compatibility)
=FDIST()
F distribution (compatibility) — the right-tail probability of the F distribution
=FDIST(x, deg_freedom1, deg_freedom2)
Reporting
Compatibility
★ 10 · ◉ 48 · Excel 2007 (Compatibility)
=FTEST()
Returns the result of the F-test (compatibility) — equality of variances
=FTEST(array1, array2)
Reporting
Compatibility
★ 19 · ◉ 47 · Excel 2007 (Compatibility)
=CHIINV()
Inverse of the chi-square distribution (compatibility) — returns the x value corresponding to the probability
=CHIINV(probability, deg_freedom)
Reporting
Compatibility
★ 19 · ◉ 47 · Excel 2007 (Compatibility)
=NEGBINOMDIST()
Returns the negative binomial distribution (compatibility)
=NEGBINOMDIST(number_f, number_s, probability_s)
Reporting
Compatibility
★ 18 · ◉ 46 · Excel 2007 (Compatibility)
=ISO.CEILING()
Rounds a number up to the nearest multiple with the ISO standard — negatives toward negative infinity
=ISO.CEILING(number, [significance])
Reporting
Compatibility
★ 27 · ◉ 45 · Excel 2007 (Compatibility)
=CRITBINOM()
Returns the smallest value for which the cumulative binomial distribution is greater than or equal to the criterion α
=CRITBINOM(trials, probability_s, alpha)
Reporting
Compatibility
★ 25 · ◉ 43 · Excel 2007 (Compatibility)
=ACOT()
Returns the arccotangent of a number (0 to π) — the angle whose cotangent equals the value
=ACOT(number)
Reporting
Compatibility
★ 15 · ◉ 43 · Excel 2007 (Compatibility)
=BINOMDIST()
Returns the binomial distribution (compatibility) — the probability of successes in a number of trials
=BINOMDIST(number_s, trials, probability_s, cumulative)
Reporting
Compatibility
★ 15 · ◉ 43 · Excel 2007 (Compatibility)
=HYPGEOMDIST()
Returns the hypergeometric distribution (compatibility)
=HYPGEOMDIST(sample_s, number_sample, population_s, number_pop)
Reporting
Compatibility
★ 15 · ◉ 43 · Excel 2007 (Compatibility)
=NORMSDIST()
Returns the standard normal distribution (compatibility)
=NORMSDIST(z)
Reporting
Compatibility
★ 24 · ◉ 42 · Excel 2007 (Compatibility)
=ERF.PRECISE()
Returns the error function with high precision (lower limit only)
=ERF.PRECISE(x)
Reporting
Compatibility
★ 29 · ◉ 42 · Excel 2007 (Compatibility)
=GAMMADIST()
Returns the gamma distribution (compatibility)
=GAMMADIST(x, alpha, beta, cumulative)
Reporting
Compatibility
★ 17 · ◉ 40 · Excel 2007 (Compatibility)
=CSC()
Returns the cosecant of an angle (1/sin)
=CSC(number)
Reporting
Compatibility
★ 12 · ◉ 40 · Excel 2007 (Compatibility)
=REGISTER.ID()
Returns the register ID of a DLL or registered code resource
=REGISTER.ID(module_text, procedure, [type_text])
Reporting
Compatibility
★ 11 · ◉ 39 · Excel 2007 (Compatibility)
=TINV()
Returns the inverse of the two-tailed t-distribution (compatibility)
=TINV(probability, deg_freedom)
Reporting
Compatibility
★ 20 · ◉ 38 · Excel 2007 (Compatibility)
=CHIDIST()
Chi-square distribution (compatibility) — returns the right-tail probability of the chi-square distribution
=CHIDIST(x, deg_freedom)
Reporting
Compatibility
★ 10 · ◉ 38 · Excel 2007 (Compatibility)
=ZTEST()
Z-test (compatibility) — one-tailed p-value of the Z-test for the mean
=ZTEST(array, x, [sigma])
Reporting
Compatibility
★ 29 · ◉ 37 · Excel 2007 (Compatibility)
=BETAINV()
Returns the inverse of the cumulative beta distribution (compatibility)
=BETAINV(probability, alpha, beta, [A], [B])
Reporting
Compatibility
★ 12 · ◉ 35 · Excel 2007 (Compatibility)
=TDIST()
Returns the Student t-distribution (compatibility)
=TDIST(x, deg_freedom, tails)
Reporting
Compatibility
★ 24 · ◉ 32 · Excel 2007 (Compatibility)
=TTEST()
Student's t-test (compatibility) — probability associated with the t-test
=TTEST(array1, array2, tails, type)
Reporting
Compatibility
★ 23 · ◉ 31 · Excel 2007 (Compatibility)
=VARP()
Returns population variance (compatibility)
=VARP(number1, [number2], ...)
Reporting
Compatibility
★ 12 · ◉ 30 · Excel 2007 (Compatibility)
=GAMMAINV()
Returns the inverse of the gamma distribution (compatibility)
=GAMMAINV(probability, alpha, beta)
Reporting
Compatibility
★ 17 · ◉ 25 · Excel 2007 (Compatibility)
=FINV()
Returns the inverse of the F distribution (compatibility)
=FINV(probability, deg_freedom1, deg_freedom2)
Reporting
Compatibility
★ 21 · ◉ 24 · Excel 2007 (Compatibility)
=SECH()
Returns the hyperbolic secant of a number
=SECH(number)
Reporting
Compatibility
★ 20 · ◉ 23 · Excel 2007 (Compatibility)
=BETADIST()
Returns the cumulative beta distribution (the legacy compatibility version BETADIST) — for compatibility with Excel 2007
=BETADIST(x, alpha, beta, [A], [B])
Reporting
Compatibility
★ 15 · ◉ 23 · Excel 2007 (Compatibility)
=COMBINA()
Returns the number of combinations with repetition — COMBIN with repeated selections allowed
=COMBINA(number, number_chosen)
Reporting
Compatibility
★ 29 · ◉ 22 · Excel 2007 (Compatibility)
=COVAR()
Covariance — returns the average of the products of deviations (compatibility)
=COVAR(array1, array2)
Reporting
Financial
★ 12 · ◉ 22 · Excel 2007 (Compatibility)
=EUROCONVERT()
Converts an amount between the currencies of the euro zone (pre-euro) — at the fixed 1998 rates
=EUROCONVERT(number, source, target, [full_precision], [triangulation_precision])
Reporting
Compatibility
★ 13 · ◉ 21 · Excel 2007 (Compatibility)
=LOGINV()
Returns the inverse of the lognormal distribution (compatibility)
=LOGINV(probability, mean, standard_dev)
Reporting
Compatibility
★ 16 · ◉ 19 · Excel 2007 (Compatibility)
=NORMSINV()
Returns the inverse of the standard normal distribution (compatibility)
=NORMSINV(probability)
Reporting
Math & Trig
★ 100 · ◉ 4 · All versions
=SUM()
Mathematical sum
=SUM(number1, [number2], ...)
Daily Tasks
Reporting
Math & Trig
★ 85 · ◉ 2 · Excel 2010
=AGGREGATE()
Performs calculations with awareness of filtered or hidden rows, with advanced options
=AGGREGATE(function_num, options, ref1, [ref2], ...)
Reporting
Ranking & Top N
Statistical
★ 90 · ◉ 2 · All versions
=MAX()
Returns the largest number among the input numbers or ranges
=MAX(number1, [number2], ...)
Daily Tasks
Reporting
Math & Trig
★ 80 · ◉ 2 · All versions
=SUBTOTAL()
Calculates with awareness of filtered or hidden rows
=SUBTOTAL(function_num, ref1, [ref2], ...)
Daily Tasks
Reporting
Compatibility
★ 27 · ◉ 1 · Excel 2007 (Compatibility)
=ACOTH()
Returns the inverse hyperbolic cotangent of a number
=ACOTH(number)
Reporting
Statistical
★ 60 · ◉ 1 · Excel 2007
=AVERAGEIFS()
Average with one condition or multiple conditions (up to 127 conditions)
=AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Daily Tasks
Conditional Aggregation
Compatibility
★ 28 · ◉ 1 · Excel 2007 (Compatibility)
=CHITEST()
Returns the chi-square test of independence (compatibility)
=CHITEST(actual_range, expected_range)
Reporting
Compatibility
★ 28 · ◉ 1 · Excel 2007 (Compatibility)
=CONFIDENCE()
Returns the confidence interval for a population mean (compatibility) — for the normal distribution
=CONFIDENCE(alpha, standard_dev, size)
Reporting
Compatibility
★ 10 · ◉ 1 · Excel 2007 (Compatibility)
=COT()
Returns the cotangent of an angle (in radians)
=COT(number)
Reporting
Compatibility
★ 22 · ◉ 1 · Excel 2007 (Compatibility)
=COTH()
Returns the hyperbolic cotangent of a number
=COTH(number)
Reporting
Compatibility
★ 24 · ◉ 1 · Excel 2007 (Compatibility)
=DBCS()
Converts half-width (single-byte) characters to full-width (double-byte)
=DBCS(text)
Reporting
Compatibility
★ 16 · ◉ 1 · Excel 2007 (Compatibility)
=LOGNORMDIST()
Returns the lognormal distribution (compatibility)
=LOGNORMDIST(x, mean, standard_dev)
Reporting
Compatibility
★ 14 · ◉ 1 · Excel 2007 (Compatibility)
=NUMBERVALUE()
Converts text to a number using locale-specific decimal and group separators
=NUMBERVALUE(text, [decimal_separator], [group_separator])
Reporting
Compatibility
★ 19 · ◉ 1 · Excel 2007 (Compatibility)
=SEC()
Returns the secant of an angle (1/cos)
=SEC(number)
Reporting
Compatibility
★ 26 · ◉ 1 · Excel 2007 (Compatibility)
=STDEVP()
Returns the population standard deviation (compatibility) — includes the entire population
=STDEVP(number1, [number2], ...)
Reporting
Compatibility
★ 24 · ◉ 1 · Excel 2007 (Compatibility)
=WEIBULL()
Returns the Weibull distribution (compatibility)
=WEIBULL(x, alpha, beta, cumulative)
Reporting