Open main menu
Home
Random
Log in
Settings
About ZCubes Wiki
Disclaimers
ZCubes Wiki
Search
Changes
← Older edit
Newer edit →
Manuals/calci/COUNTIF
(view source)
Revision as of 14:40, 6 November 2013
1 byte added
,
14:40, 6 November 2013
no edit summary
Line 14:
Line 14:
COUNTIF(1..1000,"<=10") ''returns 10'' as a result.
COUNTIF(1..1000,"<=10") ''returns 10'' as a result.
+
For example, COUNTIF(A1:A8,"JOHN") returns the number of cells in the range A1 through A8 that match with the text "JOHN".
For example, COUNTIF(A1:A8,"JOHN") returns the number of cells in the range A1 through A8 that match with the text "JOHN".
Swapna
writer
2,661
edits