SumIf

Description of formula:
Calculates the sum of the values from a specified range, which meet the criteria.
First parameter is an array of values, to which the condition is applied. If some element satisfies the condition, corresponding value from result_values array is included in the calculations. Both arrays must have the same number of elements. The third parameter of the formula is optional – if you do not specify it, values from query_values array will be used both for checking the condition and for calculating the sum.
The condition is an expression, which returns a logical value (true / false). You can use there any formula, comparison operator and join several criteria with and and or. Use value keyword to refer to evaluated element from the query_values array.
Syntax:
sumif(query_values, condition, [result_values])
Parameters:
query_values
(type: array of values of any type) Values to which the condition is applied
condition
(type: Logical value) Logical expression, defining which elements will be used for calculations
result_values
(type: array of Numbers) (optional parameter) Values to be used in calculations (if you want to use another values than passed in the first parameter)
Returned type:
Number
Examples:
=sumif(A1:A5,value>100)
=sumif(A1:A5, value>100, B1:B5)
=sumif(section1.B, value=’product1’, section1.A)
=sumif(A, abs(value)/2>section1.A1, C)
=sumif(A, value>20 and value<50)
Remarks:
Empty cells are considered as 0 in calculations.
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk