# 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 07: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.