Returns a conditional sum across a range.
Examples
Returns a conditional sum of a data column.
Sample Usage
=SUMIF(table_name!price, ">5", table_name!inventory)
Syntax
SUMIF(criteria_column, criterion, sum_column)
criteria_column- The data column which is tested against criterion.criterion- The pattern or test to apply to criteria_column.sum_column- The data column to be summed, if different from `criteria_column`.
Sample Usage
SUMIF(A1:A10,">20")
SUMIF(A1:A10,"Paid",B1:B10)
Syntax
SUMIF(range, criterion, [sum_range])
-
range- The range which is tested againstcriterion. -
criterion- The pattern or test to apply torange.-
If
rangecontains text to check against,criterionmust be a string.criterioncan contain wildcards including?to match any single character or*to match zero or more contiguous characters. To match an actual question mark or asterisk, prefix the character with the tilde (~) character (i.e.~?and~*). A string criterion must be enclosed in quotation marks. Each cell inrangeis then checked againstcriterionfor equality (or match, if wildcards are used). -
If
rangecontains numbers to check against,criterionmay be either a string or a number. If a number is provided, each cell inrangeis checked for equality withcriterion. Otherwise,criterionmay be a string containing a number (which also checks for equality), or a number prefixed with any of the following operators:=(checks for equality),>(checks that the range cell value is greater than the criterion value), or<(checks that the range cell value is less than the criterion value)
-
-
sum_range- The range to be summed, if different fromrange.
Notes
SUMIFcan only perform conditional sums with a single criterion. To use multiple criteria, use the database functionDSUM.
See Also
SUMSQ: Returns the sum of the squares of a series of numbers and/or cells.
SUM: Returns the sum of a series of numbers and/or cells.
SERIESSUM: Given parameters x, n, m, and a, returns the power series sum a1xn + a2x(n+m) + ... + aix(n+(i-1)m), where i is the number of entries in range `a`.
QUOTIENT: Returns one number divided by another, without the remainder.
PRODUCT: Returns the result of multiplying a series of numbers together.
MULTIPLY: Returns the product of two numbers. Equivalent to the `*` operator.
MINUS: Returns the difference of two numbers. Equivalent to the `-` operator.
DSUM: Returns the sum of values selected from a database table-like array or range using a SQL-like query.
DIVIDE: Returns one number divided by another. Equivalent to the `/` operator.
COUNTIF: Returns a conditional count across a range.
ADD: Returns the sum of two numbers. Equivalent to the `+` operator.