Difference between revisions of "CountIf Command"
From GeoGebra Manual
(removed betamanual template) |
m (typo) |
||
Line 6: | Line 6: | ||
:* <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>.}} | ||
− | + | ; 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. | : 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 22:49, 5 January 2013
- 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
.- CountIf[ <Condition>, <Variable>, <List> ]
- This allows a more flexible syntax, eg for Points P, Q, R
CountIf[x(A) < 3, A, {P, Q, R}]
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.