Difference between revisions of "CountIf Command"
From GeoGebra Manual
m (Text replace - "<div class="box info"> 48px|left This page is part of the official manual for print and pdf. For structural reasons normal users can't edit this page. If you found any errors on this page please contact ) |
(command syntax: changed [ ] into ( )) |
||
(6 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
− | <noinclude>{{Manual Page|version= | + | <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/> | : {{Example|1=<br/> | ||
− | :* <code>CountIf | + | :* <code>CountIf(x < 3, {1, 2, 3, 4, 5})</code> gives you the number ''2''. |
− | :* <code>CountIf | + | :* <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 | + | |
− | : | + | |
+ | ; 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.