04060101.xhp (67e470da) 04060101.xhp (6f9008d8)
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

--- 481 unchanged lines hidden (view full) ---

490 <paragraph xml-lang="en-US" id="par_id3149453" role="paragraph" l10n="U" oldref="85">
491<emph>Database</emph> is the cell range defining the database.</paragraph>
492 <paragraph xml-lang="en-US" id="par_id3151272" role="paragraph" l10n="U" oldref="86">
493<emph>DatabaseField</emph> specifies the column where the function operates on after the search criteria of the first parameter is applied and the data rows are selected. It is not related to the search criteria itself. Use the number 0 to specify the whole data range. <variable id="quotes">To reference a column by means of the column header name, place quotation marks around the header name.
494</variable></paragraph>
495 <paragraph xml-lang="en-US" id="par_id3147083" role="paragraph" l10n="U" oldref="87">
496<emph>SearchCriteria</emph> is the cell range containing search criteria. If you write several criteria in one row they are connected by AND. If you write the criteria in different rows they are connected by OR. Empty cells in the search criteria range will be ignored.</paragraph>
497 <paragraph xml-lang="en-US" id="par_id3151188" role="paragraph" l10n="U" oldref="188">Choose <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href="text/shared/optionen/01060500.xhp" name="Spreadsheet - Calculate">%PRODUCTNAME Calc - Calculate</link> to define how $[officename] Calc acts when searching for identical entries.</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

--- 481 unchanged lines hidden (view full) ---

490 <paragraph xml-lang="en-US" id="par_id3149453" role="paragraph" l10n="U" oldref="85">
491<emph>Database</emph> is the cell range defining the database.</paragraph>
492 <paragraph xml-lang="en-US" id="par_id3151272" role="paragraph" l10n="U" oldref="86">
493<emph>DatabaseField</emph> specifies the column where the function operates on after the search criteria of the first parameter is applied and the data rows are selected. It is not related to the search criteria itself. Use the number 0 to specify the whole data range. <variable id="quotes">To reference a column by means of the column header name, place quotation marks around the header name.
494</variable></paragraph>
495 <paragraph xml-lang="en-US" id="par_id3147083" role="paragraph" l10n="U" oldref="87">
496<emph>SearchCriteria</emph> is the cell range containing search criteria. If you write several criteria in one row they are connected by AND. If you write the criteria in different rows they are connected by OR. Empty cells in the search criteria range will be ignored.</paragraph>
497 <paragraph xml-lang="en-US" id="par_id3151188" role="paragraph" l10n="U" oldref="188">Choose <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href="text/shared/optionen/01060500.xhp" name="Spreadsheet - Calculate">%PRODUCTNAME Calc - Calculate</link> to define how $[officename] Calc acts when searching for identical entries.</paragraph>
498 <paragraph xml-lang="en-US" id="par_id3882869" role="paragraph" l10n="NEW">See also the Wiki page about <link href="http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Conditional_Counting_and_Summation">Conditional Counting and Summation</link>.</paragraph>
498 <paragraph xml-lang="en-US" id="par_id3882869" role="paragraph" l10n="NEW">See also the Wiki page about <link href="https://wiki.openoffice.org/wiki/Documentation/How_Tos/Conditional_Counting_and_Summation">Conditional Counting and Summation</link>.</paragraph>
499<sort order="asc">
500<section id="Section1">
501<bookmark xml-lang="en-US" branch="index" id="bm_id3150882"><bookmark_value>DCOUNT function</bookmark_value>
502 <bookmark_value>counting rows;with numeric values</bookmark_value>
503</bookmark><comment>mw added "counting rows;"</comment>
504<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBANZAHL" id="bm_id3152926" localize="false"/>
505<paragraph xml-lang="en-US" id="hd_id3150882" role="heading" level="2" l10n="U"
506 oldref="88">DCOUNT</paragraph>

--- 254 unchanged lines hidden --- 		499<sort order="asc">
500<section id="Section1">
501<bookmark xml-lang="en-US" branch="index" id="bm_id3150882"><bookmark_value>DCOUNT function</bookmark_value>
502 <bookmark_value>counting rows;with numeric values</bookmark_value>
503</bookmark><comment>mw added "counting rows;"</comment>
504<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBANZAHL" id="bm_id3152926" localize="false"/>
505<paragraph xml-lang="en-US" id="hd_id3150882" role="heading" level="2" l10n="U"
506 oldref="88">DCOUNT</paragraph>

--- 254 unchanged lines hidden ---