Difference between revisions of "CountIf Command"

From GeoGebra Manual
Jump to: navigation, search
(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.
© 2022 International GeoGebra Institute