Description of formula:
Returns the number of the values from a specified range, which meet the criteria.
First parameter is an array of values or cell range. 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 array.
Returns the number of the values from a specified range, which meet the criteria.
First parameter is an array of values or cell range. 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 array.
Syntax:
countif(values, condition)
countif(values, condition)
Parameters:
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 counted
Returned type:
Number
Examples:
=countif(A1:A5, value>100)
=countif(A, value>20 and value<50)
=countif(section1.B, value=’product1’)
=countif(A, floor(value)*10>section1.A1)
=countif(A1:A5, value>100)
=countif(A, value>20 and value<50)
=countif(section1.B, value=’product1’)
=countif(A, floor(value)*10>section1.A1)
0 Comments