Difference between revisions of "CountIf Command"
From GeoGebra Manual
(added v4 - example formatting) |
(added v4 - example formatting) |
||
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| | : {{Example| | ||
− | :* < | + | :* <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.}} |
Revision as of 18:27, 23 February 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.