22 functions for this use case · out of 12 defined
Averages the values in a field (column) of records in a list or database that match conditions you specify.
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.
Estimates the standard deviation of a population based on a sample by using the numbers in a field (column) of records in a list or database that match conditions that you specify.
The MAXIFS function returns the maximum value among cells specified by a given set of conditions or criteria: numbers, dates, text, etc. This feature is available on Windows or Mac if you have Office 2019, or if you have a Microsoft 365 subscription. If you are a Microsoft 365 subscriber, make sure you have the latest version of Office.
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.
Conditional count (a single condition)
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.
How to use the SUMIFS function in Excel, one of Excel’s math and trig functions, to add arguments that meet multiple criteria.
Returns the average (arithmetic mean) of all cells that meet multiple criteria.
Use the COUNTBLANK function, one of the Statistical functions, to count the number of empty cells in a range of cells.
Estimates the variance of a population based on a sample by using the numbers in a field (column) of records in a list or database that match conditions that you specify.
Returns the largest number in a field (column) of records in a list or database that matches conditions you that specify.
Calculates the standard deviation of a population based on the entire population by using the numbers in a field (column) of records in a list or database that match conditions that you specify.
Calculates the variance of a population based on the entire population by using the numbers in a field (column) of records in a list or database that match conditions that you specify.
How to use the SUMIF function in Excel to add the values in a range that meet criteria that you specify.
Counts the cells that contain numbers in a field (column) of records in a list or database that match conditions that you specify. The field argument is optional. If field is omitted, DCOUNT counts all records in the database that match the criteria.
Returns the smallest number in a field (column) of records in a list or database that matches conditions that you specify.
Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.
Multiplies the values in a field (column) of records in a list or database that match conditions that you specify.
Counts the nonblank cells in a field (column) of records in a list or database that match conditions that you specify. The field argument is optional. If field is omitted, DCOUNTA counts all records in the database that match the criteria.
The MINIFS function returns the minimum value among cells specified by a given set of conditions or criteria.
In a list or database, DSUM provides the sum of the numbers in fields (columns) of records that match your specified conditions.