writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + − + − + − + Line 10:
Line 11: − + Line 18:
Line 19: − + − + − + − + − + − +
no edit summary
=SUMIF(CriRange, Criteria, SumRange)=
<div style="font-size:30px">'''SUMIF (Array,Condition,SumArray)'''</div><br/>
SUMIF(CriRange, Criteria, SumRange)=
where
where
*<math>CriRange</math> is the range of cells that is evaluated by the specified criteria,
*<math>Array</math> is the range of cells that is evaluated by the specified criteria,
*<math>Criteria</math> is a condition to evaluate in the form of a number, expression or text, and
*<math>Condition</math> is a condition to evaluate in the form of a number, expression or text, and
*<math>SumRange</math> is the actual range of cells to be added.
*<math>SumArray</math> is the actual range of cells to be added.
SUMIF() calculates the sum of values in the given range if the specified criteria is satisfied.
SUMIF() calculates the sum of values in the given range if the specified criteria is satisfied.
== Description ==
== Description ==
SUMIF(CriRange, Criteria, SumRange)
SUMIF (Array,Condition,SumArray)
For Example,
For Example,
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.
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 <math>CriRange</math> are ignored.
*Blank values in <math>Array</math> are ignored.
*<math>Criteria</math> 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").
*<math>Condition</math> 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 <math>SumRange</math> is an optional. It specifies the range of cells to add if the mentioned condition is satisfied.
*Argument <math>SumArray</math> is an optional. It specifies the range of cells to add if the mentioned condition is satisfied.
*If <math>SumRange</math> is omitted, Calci adds the values in the same range for which criteria is applied.
*If <math>SumArray</math> is omitted, Calci adds the values in the same range for which criteria is applied.
*<math>SumRange</math> and <math>CriRange</math> can be of different sizes. The actual cell to be added are determined by using upper leftmost cell in <math>SumRange</math> as the beginning cell, till the cells corresponding in size and shape to <math>CriRange</math>.
*<math>SumArray</math> and <math>Array</math> can be of different sizes. The actual cell to be added are determined by using upper leftmost cell in <math>SumArray</math> as the beginning cell, till the cells corresponding in size and shape to <math>Array</math>.
*If <math>Criteria</math> is not satisfied, Calci displays zero (0) as a result.
*If <math>Condition</math> is not satisfied, Calci displays zero (0) as a result.
== Examples ==
== Examples ==