Difference between revisions of "CountIf Command"
From GeoGebra Manual
(create official page from pdf) |
(create official page from pdf) |
||
Line 1: | Line 1: | ||
<noinclude>{{Manual Page}}[[Category:Manual (official)|{{PAGENAME}}]]</noinclude> | <noinclude>{{Manual Page}}[[Category:Manual (official)|{{PAGENAME}}]]</noinclude> | ||
+ | {{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. | ||
: Examples: | : Examples: | ||
:* <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 08:49, 3 November 2010
- CountIf[Condition, List]
- Counts the number of elements in the list satisfying the condition.
- Examples:
- 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.