Difference between revisions of "CountIf Command"
From GeoGebra Manual
Line 1: | Line 1: | ||
<noinclude>{{Manual Page|version=4.0}}[[Category:Manual (official)|{{PAGENAME}}]]</noinclude> | <noinclude>{{Manual Page|version=4.0}}[[Category:Manual (official)|{{PAGENAME}}]]</noinclude> | ||
{{command|logical}} | {{command|logical}} | ||
− | ; CountIf[Condition, List]: Counts the number of elements in the list satisfying the condition. | + | ; CountIf[ <Condition>, <List> ]: Counts the number of elements in the list satisfying the condition. |
: {{Example|1=<br/> | : {{Example|1=<br/> | ||
:* <code>CountIf[x < 3, {1, 2, 3, 4, 5}]</code> gives you the number 2. | :* <code>CountIf[x < 3, {1, 2, 3, 4, 5}]</code> gives you the number 2. | ||
:* <code>CountIf[x < 3, A1:A10]</code>, where ''A1:A10'' is a range of cells in the spreadsheet, counts all cells whose values are less than 3.}} | :* <code>CountIf[x < 3, A1:A10]</code>, where ''A1:A10'' is a range of cells in the spreadsheet, counts all cells whose values are less than 3.}} | ||
{{note|1=For list of numbers arbitrary condition may be used. For list of other objects one can use only conditions of the form <code>x==constant</code> or <code>x!=constant</code>.}} | {{note|1=For list of numbers arbitrary condition may be used. For list of other objects one can use only conditions of the form <code>x==constant</code> or <code>x!=constant</code>.}} | ||
+ | |||
+ | {{betamanual|version=4.2| | ||
+ | 1=; CountIf[ <Condition>, <Variable>, <List> ] | ||
+ | : This allows a more flexible syntax, eg for Points P, Q, R <code>CountIf[x(A) < 3, A, {P, Q, R}]</code> will count only the points whose x-coordinate is less than 3. The Variable A is replaced in turn with P then Q then R for the check. | ||
+ | }} |
Revision as of 21:29, 13 August 2012
- CountIf[ <Condition>, <List> ]
- Counts the number of elements in the list satisfying the condition.
- Example:
CountIf[x < 3, {1, 2, 3, 4, 5}]
gives you the number 2.CountIf[x < 3, A1:A10]
, where A1:A10 is a range of cells in the spreadsheet, counts all cells whose values are less than 3.
Note: For list of numbers arbitrary condition may be used. For list of other objects one can use only conditions of the form
x==constant
or x!=constant
. Following text is about a feature that is supported only in GeoGebra 4.2.
|