04060106.xhp (1b402507) | 04060106.xhp (4a205835) |
---|---|
1<?xml version="1.0" encoding="UTF-8"?> 2<helpdocument version="1.0"> 3 4<!--*********************************************************** 5 * 6 * Licensed to the Apache Software Foundation (ASF) under one 7 * or more contributor license agreements. See the NOTICE file 8 * distributed with this work for additional information --- 1370 unchanged lines hidden (view full) --- 1379<paragraph xml-lang="en-US" id="par_id3164926K" role="paragraph" l10n="CHG"><ahelp hid="HID_FUNC_ZAEHLENWNRNG">Count the number of cells that meet multiple criteria in multiple ranges.</ahelp></paragraph> 1380<embed href="text/shared/00/00000001.xhp#regulaer"/> 1381<paragraph xml-lang="en-US" id="hd_id3164953K" role="heading" level="3" l10n="U">Syntax</paragraph> 1382<paragraph xml-lang="en-US" id="par_id3164967K" role="code" l10n="U" >COUNTIFS( Reference R1 ; Criterion C1 [ ; Reference R2 ; Criterion C2 ]... )</paragraph> 1383<paragraph xml-lang="en-US" id="par_id3164980K" role="paragraph" l10n="U" ><emph>Reference R1</emph> is the range to which the <emph>Criterion C1</emph> applies. <emph>Reference R2</emph> is the range to which the <emph>Criterion C2</emph> applies, and so on.</paragraph> 1384<paragraph xml-lang="en-US" id="par_id3165000K" role="paragraph" l10n="CHG">All <emph>Reference </emph> ranges shall have the same dimension and size, else an Error is returned. <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> 1385<paragraph xml-lang="en-US" id="hd_id3165037K" role="heading" level="3" l10n="U" 1386oldref="553">Examples:</paragraph> | 1<?xml version="1.0" encoding="UTF-8"?> 2<helpdocument version="1.0"> 3 4<!--*********************************************************** 5 * 6 * Licensed to the Apache Software Foundation (ASF) under one 7 * or more contributor license agreements. See the NOTICE file 8 * distributed with this work for additional information --- 1370 unchanged lines hidden (view full) --- 1379<paragraph xml-lang="en-US" id="par_id3164926K" role="paragraph" l10n="CHG"><ahelp hid="HID_FUNC_ZAEHLENWNRNG">Count the number of cells that meet multiple criteria in multiple ranges.</ahelp></paragraph> 1380<embed href="text/shared/00/00000001.xhp#regulaer"/> 1381<paragraph xml-lang="en-US" id="hd_id3164953K" role="heading" level="3" l10n="U">Syntax</paragraph> 1382<paragraph xml-lang="en-US" id="par_id3164967K" role="code" l10n="U" >COUNTIFS( Reference R1 ; Criterion C1 [ ; Reference R2 ; Criterion C2 ]... )</paragraph> 1383<paragraph xml-lang="en-US" id="par_id3164980K" role="paragraph" l10n="U" ><emph>Reference R1</emph> is the range to which the <emph>Criterion C1</emph> applies. <emph>Reference R2</emph> is the range to which the <emph>Criterion C2</emph> applies, and so on.</paragraph> 1384<paragraph xml-lang="en-US" id="par_id3165000K" role="paragraph" l10n="CHG">All <emph>Reference </emph> ranges shall have the same dimension and size, else an Error is returned. <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> 1385<paragraph xml-lang="en-US" id="hd_id3165037K" role="heading" level="3" l10n="U" 1386oldref="553">Examples:</paragraph> |
1387<paragraph xml-lang="en-US" id="par_id3166505K" role="paragraph" l10n="CHG">A1:A10 is a cell range containing the numbers <item type="input">2000</item> to <item type="input">2009</item>. B1:B10 is a cell range containing the numbers 1388<item type="input">2007</item> to <item type="input">2016</item>:</paragraph> | 1387<paragraph xml-lang="en-US" id="par_id3166505K" role="paragraph" l10n="CHG">A1:A10 is a cell range containing the numbers <item type="input">2000</item> to <item type="input">2009</item>. B1:B10 is a cell range containing the numbers <item type="input">2007</item> to <item type="input">2016</item>:</paragraph> |
1389<paragraph xml-lang="en-US" id="par_id3581652K" role="paragraph" l10n="NEW"> 1390<item type="input">=COUNTIFS(A1:A10;2006;B1:B10;2014)</item> - this returns 2</paragraph> 1391<paragraph xml-lang="en-US" id="par_id5169225K" role="paragraph" l10n="NEW"> 1392<item type="input">=COUNTIFS(A1:A10;">=2006";B1:B10;">=2006") </item>- this returns 14</paragraph> 1393</section> 1394</sort> 1395<section id="relatedtopics"> 1396<embed href="text/scalc/01/04060100.xhp#drking"/> 1397</section> 1398</body> 1399</helpdocument> | 1388<paragraph xml-lang="en-US" id="par_id3581652K" role="paragraph" l10n="NEW"> 1389<item type="input">=COUNTIFS(A1:A10;2006;B1:B10;2014)</item> - this returns 2</paragraph> 1390<paragraph xml-lang="en-US" id="par_id5169225K" role="paragraph" l10n="NEW"> 1391<item type="input">=COUNTIFS(A1:A10;">=2006";B1:B10;">=2006") </item>- this returns 14</paragraph> 1392</section> 1393</sort> 1394<section id="relatedtopics"> 1395<embed href="text/scalc/01/04060100.xhp#drking"/> 1396</section> 1397</body> 1398</helpdocument> |