Difference between revisions of "CountIf Command"
From GeoGebra Manual
Line 5: | Line 5: | ||
:* <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>.}} |
Revision as of 21:45, 26 September 2011
- 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
.