CountIf Command

From GeoGebra Manual
Revision as of 21:49, 5 January 2013 by Zbynek (talk | contribs) (removed betamanual template)
Jump to: navigation, search


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.

1=; 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.
© 2024 International GeoGebra Institute