diff options
Diffstat (limited to 'source/text/scalc/01/04060181.xhp')
| -rw-r--r-- | source/text/scalc/01/04060181.xhp | 43 |
1 files changed, 43 insertions, 0 deletions
diff --git a/source/text/scalc/01/04060181.xhp b/source/text/scalc/01/04060181.xhp index 6505696b67..a27a4c3051 100644 --- a/source/text/scalc/01/04060181.xhp +++ b/source/text/scalc/01/04060181.xhp @@ -88,6 +88,49 @@ <paragraph xml-lang="en-US" id="par_id3158000" role="paragraph" l10n="U" oldref="29"> <item type="input">=COUNTA(2;4;6;"eight")</item> = 4. The count of values is therefore 4.</paragraph> </section> +<section id="countblank"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3150896"><bookmark_value>COUNTBLANK function</bookmark_value> +<bookmark_value>counting;empty cells</bookmark_value> +<bookmark_value>empty cells;counting</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ANZAHLLEEREZELLEN" id="bm_id3149730" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id3150896" role="heading" level="2">COUNTBLANK</paragraph> +<paragraph xml-lang="en-US" id="par_id3155260" role="paragraph"><ahelp hid="HID_FUNC_ANZAHLLEEREZELLEN">Returns the number of empty cells.</ahelp></paragraph> +<paragraph xml-lang="en-US" id="hd_id3145144" role="heading" level="3">Syntax</paragraph> +<paragraph xml-lang="en-US" id="par_id3153931" role="code">COUNTBLANK(Range)</paragraph> +<paragraph xml-lang="en-US" id="par_id3149512" role="paragraph">Returns the number of empty cells in the cell range <emph>Range</emph>.</paragraph> +<paragraph xml-lang="en-US" id="hd_id3146139" role="heading" level="3">Example</paragraph> +<paragraph xml-lang="en-US" id="par_id3148586" role="paragraph"> +<item type="input">=COUNTBLANK(A1:B2)</item> returns 4 if cells A1, A2, B1, and B2 are all empty.</paragraph><comment>see also COUNTIF</comment> +</section> +<section id="countif"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3164897"><bookmark_value>COUNTIF function</bookmark_value> +<bookmark_value>counting;specified cells</bookmark_value> +</bookmark><comment>mw added one entry</comment> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZAEHLENWENN" id="bm_id3164909" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id3164897" role="heading" level="2" l10n="U" +oldref="547">COUNTIF</paragraph> +<paragraph xml-lang="en-US" id="par_id3164926" role="paragraph"><ahelp hid="HID_FUNC_ZAEHLENWENN">Returns the number of cells that meet with certain criteria within a cell range.</ahelp></paragraph> +<embed href="text/shared/00/00000001.xhp#regulaer"/> +<paragraph xml-lang="en-US" id="hd_id3164953" role="heading" level="3">Syntax</paragraph> +<paragraph xml-lang="en-US" id="par_id3164967" role="code">COUNTIF(Range; Criteria)</paragraph> +<paragraph xml-lang="en-US" id="par_id3164980" role="paragraph"><emph>Range</emph> is the range to which the criteria are to be applied.</paragraph> +<paragraph xml-lang="en-US" id="par_id3165000" role="paragraph"><emph>Criteria</emph> indicates the criteria in the form of a number, an expression or a character string. These criteria determine which cells are counted. You may also enter a search text in the form of a regular expression, e.g. b.* for all words that begin with b. You may also indicate a cell range that contains the search criterion. If you search for literal text, enclose the text in double quotes.</paragraph> +<paragraph xml-lang="en-US" id="hd_id3165037" role="heading" level="3">Example</paragraph> +<paragraph xml-lang="en-US" id="par_id3166505" role="paragraph">A1:A10 is a cell range containing the numbers <item type="input">2000</item> to <item type="input">2009</item>. Cell B1 contains the number <item type="input">2006</item>. In cell B2, you enter a formula:</paragraph> +<paragraph xml-lang="en-US" id="par_id3581652" role="paragraph"> +<item type="input">=COUNTIF(A1:A10;2006)</item> - this returns 1</paragraph> +<paragraph xml-lang="en-US" id="par_id708639" role="paragraph"> +<item type="input">=COUNTIF(A1:A10;B1)</item> - this returns 1</paragraph> +<paragraph xml-lang="en-US" id="par_id5169225" role="paragraph"> +<item type="input">=COUNTIF(A1:A10;">=2006") </item>- this returns 4</paragraph> +<paragraph xml-lang="en-US" id="par_id2118594" role="paragraph"> +<item type="input">=COUNTIF(A1:A10;"<"&B1)</item> - when B1 contains <item type="input">2006</item>, this returns 6</paragraph> +<paragraph xml-lang="en-US" id="par_id166020" role="paragraph"> +<item type="input">=COUNTIF(A1:A10;C2)</item> where cell C2 contains the text <item type="input">>2006</item> counts the number of cells in the range A1:A10 which are >2006 </paragraph> +<paragraph xml-lang="en-US" id="par_id6386913" role="paragraph">To count only negative numbers: <item type="input">=COUNTIF(A1:A10;"<0")</item> +</paragraph> +</section> <section id="b"> <bookmark xml-lang="en-US" branch="index" id="bm_id3150267"><bookmark_value>B function</bookmark_value> <bookmark_value>probabilities of samples with binomial distribution</bookmark_value> |