Difference between revisions of "CountIf Command"
From GeoGebra Manual
(create official page from pdf) |
(command syntax: changed [ ] into ( )) |
||
(16 intermediate revisions by 6 users not shown) | |||
Line 1: | Line 1: | ||
− | <noinclude>{{Manual Page | + | <noinclude>{{Manual Page|version=5.0}}</noinclude>{{command|logical}} |
− | {{command|logical}} | + | ; CountIf( <Condition>, <List> ): Counts the number of elements in the list satisfying the condition. |
− | ; CountIf | + | : {{Example|1=<br/> |
− | : | + | :* <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''.}} |
− | :* < | + | :{{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> ) | ||
+ | : As above, using a more flexible syntax. | ||
+ | :{{example|1=<div>Given 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. Therefore <code><nowiki>CountIf(x(A) < 3, A, {(0, 1), (4, 2), (2, 2)})</nowiki></code> yields the number ''2''.</div>}} |
Latest revision as of 19:37, 30 September 2017
- 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
orx!=constant
.
- CountIf( <Condition>, <Variable>, <List> )
- As above, using a more flexible syntax.
- Example:Given 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. ThereforeCountIf(x(A) < 3, A, {(0, 1), (4, 2), (2, 2)})
yields the number 2.