SUMIF
Formulas / SUMIFAdd cells together based on a given criteria.
=SUMIF([range],criteria,[sum_range])
- range - the cell range to apply criteria to
- criteria - the criteria to applied to the range
- sum_range - [OPTIONAL] the range to sum
Examples
=SUMIF(A1:A10,">5")The example returns the sum of all the cells in the range A1:A10 that are greater than 5. This is a simple example of the SUMIF function that takes a range of cells and a condition (in this case, all cells greater than 5).
=SUMIF(B1:B10,"red",A1:A10)The example returns the sum of the cells in range A1:A10 when the cells in range B1:B10 match the color "red". This example makes use of two ranges, one for the condition and one for the result.
=SUMIF(B5:B15,"jim",D5:D15)The example returns the sum of the cells in range D5:D15 when the cells in range B5:B15 match the name "jim". This example is similar to the previous one, but this time the condition is a specific name instead of a color.
Summary
The SUMIF function is a handy function for adding up a set of cells that match a single specific criteria.
- The SUMIF function adds a range of cells matching a single condition (called criteria).
- The SUMIF function does not support multiple criteria; use SUMIFS instead.
- The sum_range argument in SUMIF is optional.
Frequently Asked Questions
What is the SUMIF Function?
The SUMIF function is a function in Sourcetable that sums the values in a range that meet a given criteria.
What are the Arguments for SUMIF?
The SUMIF function takes three arguments: Range, Criteria, and Sum_Range.
What can I use for the Range Argument?
The range argument is required and can be numbers, arrays, names, or references to numbers.
What does SUMIF ignore?
SUMIF ignores text values and blank cells.
What can I use for the Criteria Argument?
The criteria argument is required and can be a number, expression, a reference, a function, or text.
What is the Sum_Range Argument?
The Sum_Range argument is optional and is the set of extra cells to add to the range cells.
Does SUMIF accept Wildcard Characters?
Yes, the SUMIF function accepts wildcard characters.
Do Text, Logical Symbols and Math Symbols need to be in Double Quotes?
Yes, text, logical symbols, and math symbols must be provided in double quotes!
