CountIf Command

From GeoGebra Manual
Revision as of 21:07, 9 March 2013 by Zbynek (talk | contribs) (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 )
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.
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