Difference between revisions of "CountIf Command"
From GeoGebra Manual
m (1 revision) |
(added v4 - example formatting) |
||
| Line 1: | Line 1: | ||
| − | <noinclude>{{Manual Page}}[[Category:Manual (official)|{{PAGENAME}}]]</noinclude> | + | <noinclude>{{Manual Page|version=4.0}}[[Category:Manual (official)|{{PAGENAME}}]]</noinclude> |
{{command|logical}} | {{command|logical}} | ||
; 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| |
:* <tt>CountIf[x < 3, {1, 2, 3, 4, 5}]</tt> gives you the number 2. | :* <tt>CountIf[x < 3, {1, 2, 3, 4, 5}]</tt> gives you the number 2. | ||
| − | :* <tt>CountIf[x < 3, A1:A10]</tt>, where ''A1:A10'' is a range of cells in the spreadsheet, counts all cells whose values are less than 3. | + | :* <tt>CountIf[x < 3, A1:A10]</tt>, 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, 13 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.
