Difference between revisions of "CountIf Command"
From GeoGebra Manual
m (1 revision: tt => code) |
|||
| Line 2: | Line 2: | ||
{{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| | + | : {{Example|1=<br/> |
:* <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.}} | ||
Revision as of 13:55, 18 April 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.
