Add 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

`=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.

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.

The SUMIF function is a function in Sourcetable that sums the values in a range that meet a given criteria.

The SUMIF function takes three arguments: Range, Criteria, and Sum_Range.

The range argument is required and can be numbers, arrays, names, or references to numbers.

SUMIF ignores text values and blank cells.

The criteria argument is required and can be a number, expression, a reference, a function, or text.

The Sum_Range argument is optional and is the set of extra cells to add to the range cells.

Yes, the SUMIF function accepts wildcard characters.

Yes, text, logical symbols, and math symbols must be provided in double quotes!

Drop CSV