Difference between revisions of "CountIf Command"

From GeoGebra Manual
Jump to: navigation, search
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 )
Line 3: Line 3:
 
; 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>.}}
 +
 
 +
 
 
; CountIf[ <Condition>, <Variable>, <List> ]
 
; 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, e.g. 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.
 +
:{{example|1=<div><code><nowiki>CountIf[x(A) < 3, A, {(0, 1), (4, 2), (2, 2)}]</nowiki></code> gives you the number ''2''.</div>}}

Revision as of 15:45, 15 July 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, e.g. 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.
Example:
CountIf[x(A) < 3, A, {(0, 1), (4, 2), (2, 2)}] gives you the number 2.
© 2024 International GeoGebra Institute