SUMIF

Returns the sum of a range depending on criteria

Syntax

SUMIF(range, criteria, [sum_range])

Arguments

Argument	Description	Required
range	The range which is to be tested against criteria	Required
criteria	The criteria to be tested against each element of range	Required
sum_range	The actual cells to sum. If missing, the 2nd argument is summed.	Optional

Examples

Sum values greater than 10

Sum with separate criteria and sum ranges

Sum based on text criteria

Related Functions

Other Statistical functions:

• AVEDEV - Returns the average of the absolute deviations of data points from their mean
• AVERAGE - Returns the average of given arguments. Text is ignored.
• CORREL - Returns the correlation coefficient between two data sets
• COUNT - Returns the count of numeric values in a dataset.
• COUNTA - Returns the count of values in a list of arguments including text, logical values, error values, and empty text.
• COUNTIF - Returns the count of cells that meet a specified criteria
• COUNTIFS - Returns the count of criteria_ranges based on the given criterions.
• FORECAST - Calculates, or predicts, a future value by using existing values
• LARGE - Returns the k-th largest value in a data set
• MAX - Returns the largest number from the provided arguments
• MEDIAN - Returns the median of the given numbers
• MIN - Returns the smallest number from the provided arguments
• MODE - Returns the most frequently occurring value in a data set
• PERCENTILE - Returns the k-th percentile of values in a range
• RANK - Returns the rank of a number from the list of other numeric values
• SMALL - Returns the k-th smallest value in a data set
• STDEV - Returns the estimated standard deviation based on a sample
• STDEVP - Calculates standard deviation based on the entire population
• SUMPRODUCT - Returns the sum of products for a list of arguments
• VAR - Returns the estimated variance for a sample of data
• VARP - Calculates variance based on the entire population

---

← Back to Formula Reference