Difference between revisions of "CountIf Command"

From GeoGebra Manual
Jump to: navigation, search
(command syntax: changed [ ] into ( ))
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
<noinclude>{{Manual Page|version=5.0}}</noinclude>
+
<noinclude>{{Manual Page|version=5.0}}</noinclude>{{command|logical}}
{{command|logical}}
+
; CountIf( <Condition>, &lt;List> ): Counts the number of elements in the list satisfying the condition.
; CountIf[ <Condition>, &lt;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>.}}
  
  
; CountIf[ <Condition>, <Variable>, &lt;List> ]
+
; CountIf( <Condition>, <Variable>, &lt;List> )
 
: As above, using a more flexible syntax.  
 
: 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>}}
+
:{{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 18: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 or x!=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. Therefore CountIf(x(A) < 3, A, {(0, 1), (4, 2), (2, 2)}) yields the number 2.
© 2024 International GeoGebra Institute