Manuals/calci/SUMIF

SUMIF (Array,Condition,SumArray)

where

• $Array$ is the range of cells that is evaluated by the specified criteria,
• $Condition$ is a condition to evaluate in the form of a number, expression or text, and
• $SumArray$ is the actual range of cells to be added.
  • SUMIF(), adds the cells specified by a given criteria.

Description

SUMIF (Array,Condition,SumArray)

For Example,

SUMIF([10,20,30],">15", [50,60,70]) returns 130

In above example, Calci checks for the values > 15 in first array (20 and 30) and returns the sum of corresponding values in second array (60 and 70) and displays 130 as a result.

• Blank values in $Array$ are ignored.
• $Condition$ can be in the form of a number, expression, a cell reference, function or text. Expression, function or text criteria should be written in double quotation marks (e.g. ">30" or "A2+A3<100" or "Banana").
• Argument $SumArray$ is an optional. It specifies the range of cells to add if the mentioned condition is satisfied.
• If $SumArray$ is omitted, Calci adds the values in the same range for which criteria is applied.
• $SumArray$ and $Array$ can be of different sizes. The actual cell to be added are determined by using upper leftmost cell in $SumArray$ as the beginning cell, till the cells corresponding in size and shape to $Array$.
• If $Condition$ is not satisfied, Calci displays zero (0) as a result.

Examples

Fruit	Quantity	Price
Orange	20	$10
Apple	10	$15
Banana	15	$5
Mango	10	$15
Pear	15	$20

=SUMIF(B2:B6,"10",C2:C6) : Checks for the fruits with Quantity equal to '10' and adds the corresponding prices. 
Returns 30 as a result.
=SUMIF(B2:B6,">10") : Adds up the quantity of fruits that are greater than '10'. Returns 50 as a result.
=SUMIF(A2:A6,"=Pear",C2:C6) : checks for the Pear fruit in the list and adds the price. Returns 20 as a result.

Related Videos

SUMIF

See Also

• SUM
• COUNTIF

References

• SUM

• List of Main Z Functions

• Z3 home