diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2024-03-26 13:11:59 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2024-03-27 19:29:55 +0100 |
| commit | 9f4e1983f6edae8f5ce8ee2e319410d4e1e39084 (patch) | |
| tree | 51f07cd2f37b5f2c7e80870767b50fd60949c7eb | |
| parent | 093252967828e122a391226a7e1f0afa415f682a (diff) | |
Refactor help pages for some Calc functions
Change-Id: I06a4b2da852cac91b41ac551c4f08ad78b7e3e47
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165409
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
| -rw-r--r-- | source/text/scalc/01/ex_data_stat_func.xhp | 77 | ||||
| -rw-r--r-- | source/text/scalc/01/func_averageif.xhp | 70 | ||||
| -rw-r--r-- | source/text/scalc/01/func_averageifs.xhp | 40 | ||||
| -rw-r--r-- | source/text/scalc/01/func_countifs.xhp | 43 | ||||
| -rw-r--r-- | source/text/scalc/01/func_filter.xhp | 1 | ||||
| -rw-r--r-- | source/text/scalc/01/func_maxifs.xhp | 41 | ||||
| -rw-r--r-- | source/text/scalc/01/func_minifs.xhp | 41 | ||||
| -rw-r--r-- | source/text/scalc/01/func_sumif.xhp | 1 | ||||
| -rw-r--r-- | source/text/scalc/01/func_sumifs.xhp | 1 |
9 files changed, 160 insertions, 155 deletions
diff --git a/source/text/scalc/01/ex_data_stat_func.xhp b/source/text/scalc/01/ex_data_stat_func.xhp index a05fad017f..fef3ee0545 100644 --- a/source/text/scalc/01/ex_data_stat_func.xhp +++ b/source/text/scalc/01/ex_data_stat_func.xhp @@ -11,135 +11,134 @@ <meta> <topic id="textscalc01func_averageifxml" indexer="include" status="PUBLISH"> - <title id="tit" xml-lang="en-US">Examples Dataset for Statistical Functions</title> + <title id="tit">Examples Dataset for Statistical Functions</title> <filename>/text/scalc/01/ex_data_stat_func.xhp</filename> </topic> </meta> <body> <section id="ex_func_average"> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="hd_id2609201512474295">Consider the following table</paragraph> <table id="table_averageif_example"> <tablerow> <tablecell> </tablecell> <tablecell> - <paragraph id="par_id2509201517430799" role="tablehead" localize="false" xml-lang="en-US">A</paragraph> + <paragraph id="par_id2509201517430799" role="tablehead" localize="false">A</paragraph> </tablecell> <tablecell> - <paragraph id="par_id250920151743116" role="tablehead" localize="false" xml-lang="en-US">B</paragraph> + <paragraph id="par_id250920151743116" role="tablehead" localize="false">B</paragraph> </tablecell> <tablecell> - <paragraph id="par_id2509201517431582" role="tablehead" localize="false" xml-lang="en-US">C</paragraph> + <paragraph id="par_id2509201517431582" role="tablehead" localize="false">C</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id2509201517431967" role="tablehead" localize="false" xml-lang="en-US">1</paragraph> + <paragraph id="par_id2509201517431967" role="tablehead" localize="false">1</paragraph> </tablecell> <tablecell> - <paragraph id="par_id18260631312423" role="tablecontent" xml-lang="en-US">Product Name</paragraph> + <paragraph id="par_id18260631312423" role="tablecontent">Product Name</paragraph> </tablecell> <tablecell> - <paragraph id="par_id2509201517433075" role="tablecontent" xml-lang="en-US">Sales</paragraph> + <paragraph id="par_id2509201517433075" role="tablecontent">Sales</paragraph> </tablecell> <tablecell> - <paragraph id="par_id2509201519383294" role="tablecontent" xml-lang="en-US">Revenue</paragraph> + <paragraph id="par_id2509201519383294" role="tablecontent">Revenue</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id959660094035" role="tablehead" localize="false" xml-lang="en-US">2</paragraph> + <paragraph id="par_id959660094035" role="tablehead" localize="false">2</paragraph> </tablecell> <tablecell> - <paragraph id="par_id2855779586764" role="tablecontent" xml-lang="en-US">pencil</paragraph> + <paragraph id="par_id2855779586764" role="tablecontent">pencil</paragraph> </tablecell> <tablecell> - <paragraph id="par_id110202156219769" role="tablecontent" localize="false" xml-lang="en-US">20</paragraph> + <paragraph id="par_id110202156219769" role="tablecontent" localize="false">20</paragraph> </tablecell> <tablecell> - <paragraph id="par_id23281929326512" role="tablecontent" localize="false" xml-lang="en-US">65</paragraph> + <paragraph id="par_id23281929326512" role="tablecontent" localize="false">65</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id2509201517432278" role="tablehead" localize="false" xml-lang="en-US">3</paragraph> + <paragraph id="par_id2509201517432278" role="tablehead" localize="false">3</paragraph> </tablecell> <tablecell> - <paragraph id="par_id24967262611733" role="tablecontent" xml-lang="en-US">pen</paragraph> + <paragraph id="par_id24967262611733" role="tablecontent">pen</paragraph> </tablecell> <tablecell> - <paragraph id="par_id2509201517433391" role="tablecontent" localize="false" xml-lang="en-US">35</paragraph> + <paragraph id="par_id2509201517433391" role="tablecontent" localize="false">35</paragraph> </tablecell> <tablecell> - <paragraph id="par_id250920151938352" role="tablecontent" localize="false" xml-lang="en-US">85</paragraph> + <paragraph id="par_id250920151938352" role="tablecontent" localize="false">85</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id250920151743267" role="tablehead" localize="false" xml-lang="en-US">4</paragraph> + <paragraph id="par_id250920151743267" role="tablehead" localize="false">4</paragraph> </tablecell> <tablecell> - <paragraph id="par_id252542413030532" role="tablecontent" xml-lang="en-US">notebook</paragraph> + <paragraph id="par_id252542413030532" role="tablecontent">notebook</paragraph> </tablecell> <tablecell> - <paragraph id="par_id2509201517433781" role="tablecontent" localize="false" xml-lang="en-US">20</paragraph> + <paragraph id="par_id2509201517433781" role="tablecontent" localize="false">20</paragraph> </tablecell> <tablecell> - <paragraph id="par_id2509201519383822" role="tablecontent" localize="false" xml-lang="en-US">190</paragraph> + <paragraph id="par_id2509201519383822" role="tablecontent" localize="false">190</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id2509201519371339" role="tablehead" localize="false" xml-lang="en-US">5</paragraph> + <paragraph id="par_id2509201519371339" role="tablehead" localize="false">5</paragraph> </tablecell> <tablecell> - <paragraph id="par_id2509201519374677" role="tablecontent" xml-lang="en-US">book</paragraph> + <paragraph id="par_id2509201519374677" role="tablecontent">book</paragraph> </tablecell> <tablecell> - <paragraph id="par_id2509201519373350" role="tablecontent" localize="false" xml-lang="en-US">17</paragraph> + <paragraph id="par_id2509201519373350" role="tablecontent" localize="false">17</paragraph> </tablecell> <tablecell> - <paragraph id="par_id2509201519384171" role="tablecontent" localize="false" xml-lang="en-US">180</paragraph> + <paragraph id="par_id2509201519384171" role="tablecontent" localize="false">180</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id6009596127912" role="tablehead" localize="false" xml-lang="en-US">6</paragraph> + <paragraph id="par_id6009596127912" role="tablehead" localize="false">6</paragraph> </tablecell> <tablecell> - <paragraph id="par_id19479417931163" role="tablecontent" xml-lang="en-US">pencil-case</paragraph> + <paragraph id="par_id19479417931163" role="tablecontent">pencil-case</paragraph> </tablecell> <tablecell> - <paragraph id="par_id85353130721737" role="tablecontent" xml-lang="en-US">not</paragraph> + <paragraph id="par_id85353130721737" role="tablecontent">not</paragraph> </tablecell> <tablecell> - <paragraph id="par_id15693941827291" role="tablecontent" xml-lang="en-US">not</paragraph> + <paragraph id="par_id15693941827291" role="tablecontent">not</paragraph> </tablecell> </tablerow> </table> <warning id="par_id1191767622119">In all examples below, ranges for calculation contain the row #6, which is ignored because it contains text.</warning> </section> -<paragraph role="paragraph" id="par_id961527953004850" xml-lang="en-US"><variable id="args">Func_Range; Range1; Criterion[; Range2; Criterion2][; … ; [Range127; Criterion127]]</variable></paragraph> +<paragraph role="paragraph" id="par_id961527953004850"><variable id="args">Func_Range; Range1; Criterion[; Range2; Criterion2][; … ; [Range127; Criterion127]]</variable></paragraph> <section id="note01"> <note id="par_id94162948227556">The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given <emph>Func_Range</emph> is taken into calculation.</note> </section> <section id="warning01"> - <paragraph id="par_id14734320631377" role="paragraph" xml-lang="en-US"><emph>Func_Range</emph> and <emph>Range1, Range2...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument.</paragraph> + <paragraph id="par_id14734320631377" role="paragraph"><emph>Func_Range</emph> and <emph>Range1, Range2...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument.</paragraph> </section> <section id="par00"> - <paragraph id="par_id101585468691583" role="paragraph" xml-lang="en-US"><emph>Range1</emph> – required argument. It is a range of cells, a name of a named range, or a label of a column or a row, to which the corresponding criterion is to be applied.</paragraph> + <paragraph id="par_id101585468691583" role="paragraph"><emph>Range1</emph> – required argument. It is a range of cells, a name of a named range, or a label of a column or a row, to which the corresponding criterion is to be applied.</paragraph> <section id="criterion"> <paragraph role="paragraph" id="par_id621619279022341"><emph>Criterion</emph>: A criterion is a single cell Reference, Number or Text. It is used in comparisons with cell contents.</paragraph> <paragraph role="paragraph" id="par_id731619279029255">A reference to an empty cell is interpreted as the numeric value 0.</paragraph> <paragraph role="paragraph" id="par_id31619279035359">A matching expression can be:</paragraph> <list type="unordered"> <listitem> - <paragraph id="par_id171619279059462" role="listitem">A Number or Logical value. A matching cell content equals the Number or Logical value. </paragraph> + <paragraph id="par_id171619279059462" role="listitem">A Number or Logical value. A matching cell content equals the Number or Logical value. </paragraph> </listitem> <listitem> - <paragraph id="par_id511619279076504" role="listitem">A value beginning with a comparator (<, <=, =, >, >=, <>).</paragraph> + <paragraph id="par_id511619279076504" role="listitem">A value beginning with a comparator (<, <=, =, >, >=, <>).</paragraph> <paragraph role="paragraph" id="par_id11619279168512">For =, if the value is empty it matches empty cells.</paragraph> <paragraph role="paragraph" id="par_id161619279207350">For <>, if the value is empty it matches non-empty cells.</paragraph> <paragraph role="paragraph" id="par_id271619279215695">For <>, if the value is not empty it matches any cell content except the value, including empty cells.</paragraph> @@ -147,16 +146,16 @@ <paragraph role="paragraph" id="par_id51619279363954">For = and <>, if the value is not empty and can not be interpreted as a Number type or one of its subtypes and the property <link href="text/shared/optionen/01060500.xhp">Search criteria = and <> must apply to whole cells</link> is checked, comparison is against the entire cell contents, if unchecked, comparison is against any subpart of the field that matches the criteria. For = and <>, if the value is not empty and can not be interpreted as a Number type or one of its subtypes applies. </paragraph> </listitem> <listitem> - <paragraph id="par_id801619279323556" role="listitem">Other Text value. If the property <link href="text/shared/optionen/01060500.xhp">Search criteria = and <> must apply to whole cells</link> is true, the comparison is against the entire cell contents, if false, comparison is against any subpart of the field that matches the criteria. The expression can contain text, numbers, regular expressions or wildcards (<link href="text/shared/optionen/01060500.xhp#wildcards">if enabled in calculation options</link>).</paragraph> + <paragraph id="par_id801619279323556" role="listitem">Other Text value. If the property <link href="text/shared/optionen/01060500.xhp">Search criteria = and <> must apply to whole cells</link> is true, the comparison is against the entire cell contents, if false, comparison is against any subpart of the field that matches the criteria. The expression can contain text, numbers, regular expressions or wildcards (<link href="text/shared/optionen/01060500.xhp#wildcards">if enabled in calculation options</link>).</paragraph> </listitem> </list> </section> - <paragraph id="par_id190621657742" role="paragraph" xml-lang="en-US"><emph>Range2</emph> – Optional. Range2 and all the following mean the same as Range1.</paragraph> - <paragraph id="par_id317001803813193" role="paragraph" xml-lang="en-US"><emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion.</paragraph> + <paragraph id="par_id190621657742" role="paragraph"><emph>Range2</emph> – Optional. Range2 and all the following mean the same as Range1.</paragraph> + <paragraph id="par_id317001803813193" role="paragraph"><emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion.</paragraph> </section> <section id="par01"> - <paragraph xml-lang="en-US" id="par_id191527781733238" role="paragraph">The function can have up to 255 arguments, meaning that you can specify 127 criteria ranges and criteria for them.</paragraph> - <paragraph id="par_id175721789527973" role="paragraph" xml-lang="en-US">If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero).</paragraph> + <paragraph id="par_id191527781733238" role="paragraph">The function can have up to 255 arguments, meaning that you can specify 127 criteria ranges and criteria for them.</paragraph> + <paragraph id="par_id175721789527973" role="paragraph">If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero).</paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_averageif.xhp b/source/text/scalc/01/func_averageif.xhp index a54ef2ec52..9334626f56 100644 --- a/source/text/scalc/01/func_averageif.xhp +++ b/source/text/scalc/01/func_averageif.xhp @@ -11,75 +11,77 @@ <meta> <topic id="textscalc01func_averageifxml" indexer="include" status="PUBLISH"> - <title id="tit" xml-lang="en-US">AVERAGEIF function</title> + <title id="tit">AVERAGEIF function</title> <filename>/text/scalc/01/func_averageif.xhp</filename> </topic> </meta> <body> <section id="averageif_function"> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_AVERAGEIF" id="bm_id19444137534261" localize="false"/> -<bookmark xml-lang="en-US" branch="index" id="bm_id237812197829662"> +<bookmark branch="hid/SC_HID_FUNC_AVERAGEIF" id="bm_id19444137534261" localize="false"/> +<bookmark branch="index" id="bm_id237812197829662"> <bookmark_value>AVERAGEIF function</bookmark_value> <bookmark_value>arithmetic mean;satisfying condition</bookmark_value> </bookmark> <h1 id="hd_id16852304621982"><variable id="averageif_head"><link href="text/scalc/01/func_averageif.xhp">AVERAGEIF</link></variable> function</h1> -<paragraph id="par_id7281266615152" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="averageif_des">Returns the arithmetic mean of all cells in a range that satisfy a given condition. The AVERAGEIF function sums up all the results that match the logical test and divides this sum by the quantity of selected values.</variable></ahelp></paragraph> +<paragraph id="par_id7281266615152" role="paragraph"><ahelp hid="."><variable id="averageif_des">Returns the arithmetic mean of all cells in a range that satisfy a given condition. The AVERAGEIF function sums up all the results that match the logical test and divides this sum by the quantity of selected values.</variable></ahelp></paragraph> </section> <embed href="text/scalc/00/avail_release.xhp#4.0"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> -<paragraph id="par_id200801176228491" role="code" xml-lang="en-US">AVERAGEIF(Range; Criterion [; Average_Range ])</paragraph> -<paragraph id="par_id15226321619829" role="paragraph" xml-lang="en-US"><emph>Range</emph> – required argument. An array, a name of named range or a label of a column or a row containing numbers for averaging or numbers or text for the condition.</paragraph> +<paragraph id="par_id200801176228491" role="code">AVERAGEIF(Range; Criterion [; Average_Range ])</paragraph> +<paragraph id="par_id15226321619829" role="paragraph"><emph>Range</emph> – required argument. An array, a name of named range or a label of a column or a row containing numbers for averaging or numbers or text for the condition.</paragraph> <embed href="text/scalc/01/ex_data_stat_func.xhp#criterion"/> <embed href="text/shared/00/00000001.xhp#regex"/> -<paragraph id="par_id174711913219765" role="paragraph" xml-lang="en-US"><emph>Average_Range</emph> – optional. It is a range of values for calculating the mean.</paragraph> +<paragraph id="par_id174711913219765" role="paragraph"><emph>Average_Range</emph> – optional. It is a range of values for calculating the mean.</paragraph> <note id="par_id45123108916423">If the <emph>Average_Range</emph> is not specified, <emph>Range</emph> is used for both, the calculation of the mean and the search according to the condition. If <emph>Average_Range</emph> is specified, the <emph>Range</emph> is used only for the condition test, while <emph>Average_Range</emph> is used for the average calculation.</note> -<embed href="text/scalc/01/ODFF.xhp#odff"/> + <warning id="par_id278275053653">If a cell in a range of values for calculating the mean is empty or contains text, function AVERAGEIF ignores this cell.<br/> If the whole range is empty, contains only text or all values of the range do not satisfy the condition (or any combination of those), the function returns the #DIV/0! error. </warning> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/> <h4 id="hd_id229513120314273">Simple usage</h4> -<paragraph id="par_id2509201519225446" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(B2:B6;"<35")</item></paragraph> -<paragraph id="par_id11322891219251" role="paragraph" xml-lang="en-US">Calculates the average for values of the range B2:B6 that are less than 35. Returns 19, because the second row does not participate in the calculation.</paragraph> -<paragraph id="par_id250920151922590" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(B2:B6;"<"&MAX(B2:B6))</item></paragraph> -<paragraph id="par_id3813266131474" role="paragraph" xml-lang="en-US">Calculates the average for values of the same range that are less than the maximum value of this range. Returns 19, because the largest value (the second row) does not participate in the calculation.</paragraph> -<paragraph id="par_id2509201519230832" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(B2:B6;">"&SMALL(B2:B6;1))</item></paragraph> -<paragraph id="par_id243522732832394" role="paragraph" xml-lang="en-US">Calculates the average for values of the same range that are greater than the first smallest value of this range. Returns 25, because the first smallest value (the fourth row) does not participate in the calculation.</paragraph> +<paragraph id="par_id2509201519225446" role="paragraph"><item type="input">=AVERAGEIF(B2:B6;"<35")</item></paragraph> +<paragraph id="par_id11322891219251" role="paragraph">Calculates the average for values of the range B2:B6 that are less than 35. Returns 19, because the second row does not participate in the calculation.</paragraph> +<paragraph id="par_id250920151922590" role="paragraph"><item type="input">=AVERAGEIF(B2:B6;"<"&MAX(B2:B6))</item></paragraph> +<paragraph id="par_id3813266131474" role="paragraph">Calculates the average for values of the same range that are less than the maximum value of this range. Returns 19, because the largest value (the second row) does not participate in the calculation.</paragraph> +<paragraph id="par_id2509201519230832" role="paragraph"><item type="input">=AVERAGEIF(B2:B6;">"&SMALL(B2:B6;1))</item></paragraph> +<paragraph id="par_id243522732832394" role="paragraph">Calculates the average for values of the same range that are greater than the first smallest value of this range. Returns 25, because the first smallest value (the fourth row) does not participate in the calculation.</paragraph> <h4 id="hd_id2101254257133">Using the Average_Range</h4> -<paragraph id="par_id2509201519315584" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(B2:B6;"<35";C2:C6)</item></paragraph> -<paragraph id="par_id148222637631350" role="paragraph" xml-lang="en-US">The function searches what values are less than 35 in the B2:B6 range, and calculates the average of corresponding values from the C2:C6 range. Returns 145, because the second row does not participate in the calculation. </paragraph> -<paragraph id="par_id2509201519315535" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(B2:B6;">"&MIN(B2:B6);C2:C6)</item></paragraph> -<paragraph id="par_id2412836525208" role="paragraph" xml-lang="en-US">The function searches what values from the range B2:B6 are greater than the least value in the B2:B6 range, and calculates the average of corresponding values from the C2:C6 range. Returns 113.3, because the fourth row (where there is the least value in the range B2:B6) does not participate in the calculation.</paragraph> -<paragraph id="par_id2509201519315547" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(B2:B6;"<"&LARGE(B2:B6;2);C2:C6)</item></paragraph> -<paragraph id="par_id173931101529497" role="paragraph" xml-lang="en-US">The function searches what values from the range B2:B6 are less than the second large value in the B2:B6 range, and calculates the average of corresponding values from the C2:C6 range. Returns 180, because only the fourth row participates in the calculation. </paragraph> +<paragraph id="par_id2509201519315584" role="paragraph"><item type="input">=AVERAGEIF(B2:B6;"<35";C2:C6)</item></paragraph> +<paragraph id="par_id148222637631350" role="paragraph">The function searches what values are less than 35 in the B2:B6 range, and calculates the average of corresponding values from the C2:C6 range. Returns 145, because the second row does not participate in the calculation. </paragraph> +<paragraph id="par_id2509201519315535" role="paragraph"><item type="input">=AVERAGEIF(B2:B6;">"&MIN(B2:B6);C2:C6)</item></paragraph> +<paragraph id="par_id2412836525208" role="paragraph">The function searches what values from the range B2:B6 are greater than the least value in the B2:B6 range, and calculates the average of corresponding values from the C2:C6 range. Returns 113.3, because the fourth row (where there is the least value in the range B2:B6) does not participate in the calculation.</paragraph> +<paragraph id="par_id2509201519315547" role="paragraph"><item type="input">=AVERAGEIF(B2:B6;"<"&LARGE(B2:B6;2);C2:C6)</item></paragraph> +<paragraph id="par_id173931101529497" role="paragraph">The function searches what values from the range B2:B6 are less than the second large value in the B2:B6 range, and calculates the average of corresponding values from the C2:C6 range. Returns 180, because only the fourth row participates in the calculation. </paragraph> <h4 id="hd_id30054471316969">Using regular expressions</h4> -<paragraph id="par_id2509201519360514" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(A2:A6;"pen";B2:B6)</item></paragraph> -<paragraph id="par_id14714860719948" role="paragraph" xml-lang="en-US">The function searches what cells from the range A2:A6 contain only the word “pen”, and calculates the average of corresponding values from the B2:B6 range. Returns 35, because only the second row participates in the calculation. The search is performed in the A2:A6 range, but the values are returned from the B2:B6 range.</paragraph> -<paragraph id="par_id250920151936096" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(A2:A6;"pen.*";B2:B6)</item></paragraph> -<paragraph id="par_id26959239098104" role="paragraph" xml-lang="en-US">The function searches what cells from the range A2:A6 begin with “pen” ending with any quantity of other characters, and calculates the average of corresponding values from the B2:B6 range. Returns 27.5, because now also “pencil” satisfies the condition, and both, first and second rows participate in the calculation. </paragraph> -<paragraph id="par_id2509201519361352" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(A2:A6;".*book.*";B2:B6)</item></paragraph> -<paragraph id="par_id227041304619482" role="paragraph" xml-lang="en-US">The function searches what cells from the range A2:A6 contain “book” starting and ending with any quantity of other characters, and calculates the average of corresponding values from the B2:B6 range. Returns 18.5, because only third and fourth rows participate in the calculation.</paragraph> +<paragraph id="par_id2509201519360514" role="paragraph"><item type="input">=AVERAGEIF(A2:A6;"pen";B2:B6)</item></paragraph> +<paragraph id="par_id14714860719948" role="paragraph">The function searches what cells from the range A2:A6 contain only the word “pen”, and calculates the average of corresponding values from the B2:B6 range. Returns 35, because only the second row participates in the calculation. The search is performed in the A2:A6 range, but the values are returned from the B2:B6 range.</paragraph> +<paragraph id="par_id250920151936096" role="paragraph"><item type="input">=AVERAGEIF(A2:A6;"pen.*";B2:B6)</item></paragraph> +<paragraph id="par_id26959239098104" role="paragraph">The function searches what cells from the range A2:A6 begin with “pen” ending with any quantity of other characters, and calculates the average of corresponding values from the B2:B6 range. Returns 27.5, because now also “pencil” satisfies the condition, and both, first and second rows participate in the calculation. </paragraph> +<paragraph id="par_id2509201519361352" role="paragraph"><item type="input">=AVERAGEIF(A2:A6;".*book.*";B2:B6)</item></paragraph> +<paragraph id="par_id227041304619482" role="paragraph">The function searches what cells from the range A2:A6 contain “book” starting and ending with any quantity of other characters, and calculates the average of corresponding values from the B2:B6 range. Returns 18.5, because only third and fourth rows participate in the calculation.</paragraph> <h4 id="hd_id251309885188">Reference to a cell as a criterion</h4> -<paragraph id="par_id177972099720424" role="paragraph" xml-lang="en-US">If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of AVERAGEIF function. </paragraph> -<paragraph id="par_id134941261230060" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(A2:A6;".*"&E2&".*";B2:B6)</item></paragraph> -<paragraph id="par_id172572288310247" role="paragraph" xml-lang="en-US">The function searches what cells from the range A2:A6 contain a combination of characters specified in E2 starting and ending with any quantity of other characters, and calculates the average of corresponding values from the B2:B6 range. If E2 = book, the function returns 18.5.</paragraph> -<paragraph id="par_id316901523627285" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(B2:B6;"<"&E2;C2:C6)</item></paragraph> -<paragraph id="par_id302181300528607" role="paragraph" xml-lang="en-US">The function searches what cells from the range B2:B6 are less than the value specified in E2, and calculates the average of corresponding values from the C2:C6 range. If E2 = 35, the function returns 145.</paragraph> +<paragraph id="par_id177972099720424" role="paragraph">If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of AVERAGEIF function. </paragraph> +<paragraph id="par_id134941261230060" role="paragraph"><item type="input">=AVERAGEIF(A2:A6;".*"&E2&".*";B2:B6)</item></paragraph> +<paragraph id="par_id172572288310247" role="paragraph">The function searches what cells from the range A2:A6 contain a combination of characters specified in E2 starting and ending with any quantity of other characters, and calculates the average of corresponding values from the B2:B6 range. If E2 = book, the function returns 18.5.</paragraph> +<paragraph id="par_id316901523627285" role="paragraph"><item type="input">=AVERAGEIF(B2:B6;"<"&E2;C2:C6)</item></paragraph> +<paragraph id="par_id302181300528607" role="paragraph">The function searches what cells from the range B2:B6 are less than the value specified in E2, and calculates the average of corresponding values from the C2:C6 range. If E2 = 35, the function returns 145.</paragraph> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <section id="relatedtopics"> <tip id="par_id421677017213184"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/AVERAGEIF">AVERAGEIF wiki page</link>.</tip> - <paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US" localize="false"> + <paragraph id="par_id11921178730928" role="paragraph" localize="false"> <embedvar href="text/scalc/01/04060184.xhp#average_head"/>, <embedvar href="text/scalc/01/04060184.xhp#averagea_head"/>, <embedvar href="text/scalc/01/04060184.xhp#avedev_head"/> </paragraph> - <paragraph id="par_id11931178730928" role="paragraph" xml-lang="en-US" localize="false"> + <paragraph id="par_id11931178730928" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_countifs.xhp#countifs_head"/>, <embedvar href="text/scalc/01/func_minifs.xhp#minifs_head"/>, <embedvar href="text/scalc/01/func_maxifs.xhp#maxifs_head"/>, <embedvar href="text/scalc/01/func_averageifs.xhp#averageifs_head"/>, <embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/> </paragraph> -<paragraph id="par_id251321802714497" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph> +<paragraph id="par_id251321802714497" role="paragraph" localize="false"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_averageifs.xhp b/source/text/scalc/01/func_averageifs.xhp index 5ae669c6d8..0da2629284 100644 --- a/source/text/scalc/01/func_averageifs.xhp +++ b/source/text/scalc/01/func_averageifs.xhp @@ -11,25 +11,25 @@ <meta> <topic id="textscalc01func_averageifsxml" indexer="include" status="PUBLISH"> - <title id="tit" xml-lang="en-US">AVERAGEIFS function</title> + <title id="tit">AVERAGEIFS function</title> <filename>/text/scalc/01/func_averageifs.xhp</filename> </topic> </meta> <body> <section id="averageifs_function"> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_AVERAGEIFS" id="bm_id536295362953629" localize="false"/> -<bookmark xml-lang="en-US" branch="index" id="bm_id536715367153671"> +<bookmark branch="hid/SC_HID_FUNC_AVERAGEIFS" id="bm_id536295362953629" localize="false"/> +<bookmark branch="index" id="bm_id536715367153671"> <bookmark_value>AVERAGEIFS function</bookmark_value> <bookmark_value>arithmetic mean;satisfying conditions</bookmark_value> </bookmark> <h1 id="hd_id537445374453744"><variable id="averageifs_head"><link href="text/scalc/01/func_averageifs.xhp">AVERAGEIFS</link></variable> function</h1> -<paragraph id="par_id538405384053840" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="averageifs_des">Returns the arithmetic mean of all cells in a range that satisfy given multiple criteria. The AVERAGEIFS function sums up all the results that match the logical tests and divides this sum by the quantity of selected values.</variable></ahelp></paragraph> +<paragraph id="par_id538405384053840" role="paragraph"><ahelp hid="."><variable id="averageifs_des">Returns the arithmetic mean of all cells in a range that satisfy given multiple criteria. The AVERAGEIFS function sums up all the results that match the logical tests and divides this sum by the quantity of selected values.</variable></ahelp></paragraph> </section> <embed href="text/scalc/00/avail_release.xhp#4.0"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> -<paragraph id="par_id21050267713178" role="code" xml-lang="en-US">AVERAGEIFS(<embedvar href="text/scalc/01/ex_data_stat_func.xhp#args" markup="ignore"/>)</paragraph> -<paragraph id="par_id165832700711773" role="paragraph" xml-lang="en-US"><emph>Func_range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the mean.</paragraph> +<paragraph id="par_id21050267713178" role="code">AVERAGEIFS(<embedvar href="text/scalc/01/ex_data_stat_func.xhp#args" markup="ignore"/>)</paragraph> +<paragraph id="par_id165832700711773" role="paragraph"><emph>Func_range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the mean.</paragraph> <embed href="text/scalc/01/ex_data_stat_func.xhp#par00"/> <embed href="text/shared/00/00000001.xhp#regex"/> @@ -40,36 +40,36 @@ <embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/> <h4 id="hd_id20733192524041">Simple usage</h4> -<paragraph id="par_id24004653627203" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIFS(B2:B6;B2:B6;">=20")</item></paragraph> -<paragraph id="par_id30201168686268" role="paragraph" xml-lang="en-US">Calculates the average for values of the range B2:B6 that are greater than or equal to 20. Returns 25, because the fifth row does not meet the criterion.</paragraph> -<paragraph id="par_id30279247419921" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIFS(C2:C6;B2:B6;">=20";C2:C6;">70")</item></paragraph> -<paragraph id="par_id2930764965983" role="paragraph" xml-lang="en-US">Calculates the average for values of the range C2:C6 that are greater than 70 and correspond to cells of B2:B6 with values greater than or equal to 20. Returns 137.5, because the second and fifth rows do not meet at least one criterion.</paragraph> +<paragraph id="par_id24004653627203" role="paragraph"><item type="input">=AVERAGEIFS(B2:B6;B2:B6;">=20")</item></paragraph> +<paragraph id="par_id30201168686268" role="paragraph">Calculates the average for values of the range B2:B6 that are greater than or equal to 20. Returns 25, because the fifth row does not meet the criterion.</paragraph> +<paragraph id="par_id30279247419921" role="paragraph"><item type="input">=AVERAGEIFS(C2:C6;B2:B6;">=20";C2:C6;">70")</item></paragraph> +<paragraph id="par_id2930764965983" role="paragraph">Calculates the average for values of the range C2:C6 that are greater than 70 and correspond to cells of B2:B6 with values greater than or equal to 20. Returns 137.5, because the second and fifth rows do not meet at least one criterion.</paragraph> <h4 id="hd_id317532515726820">Using regular expressions and nested functions</h4> -<paragraph id="par_id457966021670" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIFS(C2:C6;B2:B6;">"&MIN(B2:B6);B2:B6;"<"&MAX(B2:B6))</item></paragraph> -<paragraph id="par_id66091035229950" role="paragraph" xml-lang="en-US">Calculates the average for values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 127.5, because the third and fifth rows do not meet at least one criterion.</paragraph> -<paragraph id="par_id303162761931870" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIFS(C2:C6;A2:A6;"pen.*";B2:B6;"<"&MAX(B2:B6))</item></paragraph> -<paragraph id="par_id40031348913642" role="paragraph" xml-lang="en-US">Calculates the average for values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with "pen" and to all cells of the B2:B6 range except its maximum. Returns 65, because only second row meets all criteria.</paragraph> +<paragraph id="par_id457966021670" role="paragraph"><item type="input">=AVERAGEIFS(C2:C6;B2:B6;">"&MIN(B2:B6);B2:B6;"<"&MAX(B2:B6))</item></paragraph> +<paragraph id="par_id66091035229950" role="paragraph">Calculates the average for values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 127.5, because the third and fifth rows do not meet at least one criterion.</paragraph> +<paragraph id="par_id303162761931870" role="paragraph"><item type="input">=AVERAGEIFS(C2:C6;A2:A6;"pen.*";B2:B6;"<"&MAX(B2:B6))</item></paragraph> +<paragraph id="par_id40031348913642" role="paragraph">Calculates the average for values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with "pen" and to all cells of the B2:B6 range except its maximum. Returns 65, because only second row meets all criteria.</paragraph> <h4 id="hd_id31201205191857">Reference to a cell as a criterion</h4> -<paragraph id="par_id316794795433" role="paragraph" xml-lang="en-US">If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of AVERAGEIFS function. For example, the above function can be rewritten as follows:</paragraph> -<paragraph id="par_id67531072426731" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIFS(C2:C6;A2:A6;E2&".*";B2:B6;"<"&MAX(B2:B6))</item></paragraph> -<paragraph id="par_id65612244926745" role="paragraph" xml-lang="en-US">If E2 = pen, the function returns 65, because the link to the cell is substituted with its content.</paragraph> +<paragraph id="par_id316794795433" role="paragraph">If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of AVERAGEIFS function. For example, the above function can be rewritten as follows:</paragraph> +<paragraph id="par_id67531072426731" role="paragraph"><item type="input">=AVERAGEIFS(C2:C6;A2:A6;E2&".*";B2:B6;"<"&MAX(B2:B6))</item></paragraph> +<paragraph id="par_id65612244926745" role="paragraph">If E2 = pen, the function returns 65, because the link to the cell is substituted with its content.</paragraph> <embed href="text/scalc/06/calcsamplefiles.xhp#func_ifs"/> <section id="relatedtopics"> <tip id="par_id371677017196557"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/AVERAGEIFS">AVERAGEIFS wiki page</link>.</tip> - <paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US" localize="false"> + <paragraph id="par_id11921178730928" role="paragraph" localize="false"> <embedvar href="text/scalc/01/04060184.xhp#average_head"/>, <embedvar href="text/scalc/01/04060184.xhp#averagea_head"/>, <embedvar href="text/scalc/01/04060184.xhp#avedev_head"/>, <embedvar href="text/scalc/01/func_averageif.xhp#averageif_head"/> </paragraph> - <paragraph id="par_id11931178730928" role="paragraph" xml-lang="en-US" localize="false"> + <paragraph id="par_id11931178730928" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_countifs.xhp#countifs_head"/>, <embedvar href="text/scalc/01/func_minifs.xhp#minifs_head"/>, <embedvar href="text/scalc/01/func_maxifs.xhp#maxifs_head"/>, <embedvar href="text/scalc/01/func_averageifs.xhp#averageifs_head"/>, <embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/> </paragraph> -<paragraph id="par_id20741445030307" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph> +<paragraph id="par_id20741445030307" role="paragraph" localize="false"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_countifs.xhp b/source/text/scalc/01/func_countifs.xhp index 5cec8c2aaa..02a0c07151 100644 --- a/source/text/scalc/01/func_countifs.xhp +++ b/source/text/scalc/01/func_countifs.xhp @@ -11,67 +11,68 @@ <meta> <topic id="textscalc01func_countifsxml" indexer="include" status="PUBLISH"> - <title id="tit" xml-lang="en-US">COUNTIFS function</title> + <title id="tit">COUNTIFS function</title> <filename>/text/scalc/01/func_countifs.xhp</filename> </topic> </meta> <body> <section id="countifs_function"> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COUNTIFS" id="bm_id449544954495" localize="false"/> -<bookmark xml-lang="en-US" branch="index" id="bm_id452245224522"> +<bookmark branch="hid/SC_HID_FUNC_COUNTIFS" id="bm_id449544954495" localize="false"/> +<bookmark branch="index" id="bm_id452245224522"> <bookmark_value>COUNTIFS function</bookmark_value> <bookmark_value>counting row;satisfying criteria</bookmark_value> <bookmark_value>counting column;satisfying criteria</bookmark_value> </bookmark> <h1 id="hd_id456845684568"><variable id="countifs_head"><link href="text/scalc/01/func_countifs.xhp">COUNTIFS</link></variable></h1> -<paragraph id="par_id462646264626" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="countifs_des">Returns the count of cells that meet criteria in multiple ranges.</variable></ahelp></paragraph> +<paragraph id="par_id462646264626" role="paragraph"><ahelp hid="."><variable id="countifs_des">Returns the count of cells that meet criteria in multiple ranges.</variable></ahelp></paragraph> </section> <embed href="text/scalc/00/avail_release.xhp#4.0"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> -<paragraph id="par_id27421466710275" role="code" xml-lang="en-US">COUNTIFS(Range; Criterion[; Range2; Criterion2][; ... ; [Range127; Criterion127]])</paragraph> +<paragraph id="par_id27421466710275" role="code">COUNTIFS(Range; Criterion[; Range2; Criterion2][; ... ; [Range127; Criterion127]])</paragraph> <embed href="text/scalc/01/ex_data_stat_func.xhp#par00"/> <embed href="text/shared/00/00000001.xhp#regex"/> <paragraph role="paragraph" id="par_id14734320631377"><emph>Range, Range2, ...</emph> and <emph>Criterion, Criterion2, ...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument.</paragraph> <embed href="text/scalc/01/ex_data_stat_func.xhp#note01"/> <embed href="text/scalc/01/ex_data_stat_func.xhp#par01"/> <embed href="text/scalc/01/ODFF.xhp#odff"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/> <h4 id="hd_id3861259759512">Simple usage</h4> -<paragraph id="par_id15856592423333" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIFS(B2:B6;">=20")</item></paragraph> -<paragraph id="par_id323511393121175" role="paragraph" xml-lang="en-US">Counts the amount of rows of the range B2:B6 with values greater than or equal to 20. Returns 3, because the fifth and the sixth rows do not meet the criterion.</paragraph> -<paragraph id="par_id74301057922522" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIFS(B2:B6;">=20";C2:C6;">70")</item></paragraph> -<paragraph id="par_id109622995127628" role="paragraph" xml-lang="en-US">Counts the amount of rows that contain simultaneously values greater than 70 in the C2:C6 range and values greater than or equal to 20 in the B2:B6 range. Returns 2, because the second, the fifth and the sixth rows do not meet at least one criterion.</paragraph> +<paragraph id="par_id15856592423333" role="paragraph"><item type="input">=COUNTIFS(B2:B6;">=20")</item></paragraph> +<paragraph id="par_id323511393121175" role="paragraph">Counts the amount of rows of the range B2:B6 with values greater than or equal to 20. Returns 3, because the fifth and the sixth rows do not meet the criterion.</paragraph> +<paragraph id="par_id74301057922522" role="paragraph"><item type="input">=COUNTIFS(B2:B6;">=20";C2:C6;">70")</item></paragraph> +<paragraph id="par_id109622995127628" role="paragraph">Counts the amount of rows that contain simultaneously values greater than 70 in the C2:C6 range and values greater than or equal to 20 in the B2:B6 range. Returns 2, because the second, the fifth and the sixth rows do not meet at least one criterion.</paragraph> <h4 id="hd_id298462825526166">Using regular expressions and nested functions</h4> <paragraph role="paragraph" id="par_id831605805755075">For these examples to work as described, make sure that <emph>Enable regular expressions in formulas</emph> is selected in <switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - $[officename] Calc - Calculate</menuitem>.</paragraph> -<paragraph id="par_id22736248573471" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIFS(B2:B6;"[:alpha:]*")</item></paragraph> -<paragraph id="par_id22137303324873" role="paragraph" xml-lang="en-US">Counts the amount of rows of the B2:B6 range that contain only alphabet symbols. Returns 1, because only sixth row meets the criterion.</paragraph> -<paragraph id="par_id82271340221411" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIFS(B2:B6;">"&MIN(B2:B6);B2:B6;"<"&MAX(B2:B6))</item></paragraph> -<paragraph id="par_id1105320769334" role="paragraph" xml-lang="en-US">Counts the amount of rows of the B2:B6 range excluding rows with minimum and maximum values of this range. Returns 2, because the third, the fifth and the sixth rows do not meet at least one criterion.</paragraph> -<paragraph id="par_id267603146513224" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIFS(A2:A6;"pen.*";B2:B6;"<"&MAX(B2:B6))</item></paragraph> -<paragraph id="par_id111252614832220" role="paragraph" xml-lang="en-US">Counts the amount of rows that correspond to all cells of the A2:A6 range starting with "pen" and to all cells of the B2:B6 range with exception of its maximum. Returns 1, because only second row meets all criteria.</paragraph> +<paragraph id="par_id22736248573471" role="paragraph"><item type="input">=COUNTIFS(B2:B6;"[:alpha:]*")</item></paragraph> +<paragraph id="par_id22137303324873" role="paragraph">Counts the amount of rows of the B2:B6 range that contain only alphabet symbols. Returns 1, because only sixth row meets the criterion.</paragraph> +<paragraph id="par_id82271340221411" role="paragraph"><item type="input">=COUNTIFS(B2:B6;">"&MIN(B2:B6);B2:B6;"<"&MAX(B2:B6))</item></paragraph> +<paragraph id="par_id1105320769334" role="paragraph">Counts the amount of rows of the B2:B6 range excluding rows with minimum and maximum values of this range. Returns 2, because the third, the fifth and the sixth rows do not meet at least one criterion.</paragraph> +<paragraph id="par_id267603146513224" role="paragraph"><item type="input">=COUNTIFS(A2:A6;"pen.*";B2:B6;"<"&MAX(B2:B6))</item></paragraph> +<paragraph id="par_id111252614832220" role="paragraph">Counts the amount of rows that correspond to all cells of the A2:A6 range starting with "pen" and to all cells of the B2:B6 range with exception of its maximum. Returns 1, because only second row meets all criteria.</paragraph> <h4 id="hd_id212582362610399">Reference to a cell as a criterion</h4> -<paragraph id="par_id3245551524846" role="paragraph" xml-lang="en-US">If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the COUNTIFS function. For example, the above function can be rewritten as follows:</paragraph> -<paragraph id="par_id109501907712434" role="paragraph" xml-lang="en-US"><item type="input">=COUNTIFS(A2:A6;E2&".*";B2:B6;"<"&MAX(B2:B6))</item></paragraph> -<paragraph id="par_id738533068520" role="paragraph" xml-lang="en-US">If E2 = pen, the function returns 1, because the link to the cell is substituted with its content and it works as a function above.</paragraph> +<paragraph id="par_id3245551524846" role="paragraph">If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the COUNTIFS function. For example, the above function can be rewritten as follows:</paragraph> +<paragraph id="par_id109501907712434" role="paragraph"><item type="input">=COUNTIFS(A2:A6;E2&".*";B2:B6;"<"&MAX(B2:B6))</item></paragraph> +<paragraph id="par_id738533068520" role="paragraph">If E2 = pen, the function returns 1, because the link to the cell is substituted with its content and it works as a function above.</paragraph> <embed href="text/scalc/06/calcsamplefiles.xhp#func_ifs"/> <section id="relatedtopics"> <tip id="par_id131677016670241"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/COUNTIFS">COUNTIFS wiki page</link>.</tip> - <paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US" localize="false"> + <paragraph id="par_id11921178730928" role="paragraph" localize="false"> <embedvar href="text/scalc/01/04060181.xhp#count_head"/>, <embedvar href="text/scalc/01/04060181.xhp#countif_head"/>, <embedvar href="text/scalc/01/04060181.xhp#countblank_head"/>, <embedvar href="text/scalc/01/04060181.xhp#counta_head"/> </paragraph> - <paragraph id="par_id11931178730928" role="paragraph" xml-lang="en-US" localize="false"> + <paragraph id="par_id11931178730928" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_countifs.xhp#countifs_head"/>, <embedvar href="text/scalc/01/func_minifs.xhp#minifs_head"/>, <embedvar href="text/scalc/01/func_maxifs.xhp#maxifs_head"/>, <embedvar href="text/scalc/01/func_averageifs.xhp#averageifs_head"/>, <embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/> </paragraph> -<paragraph id="par_id235992404316585" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph> +<paragraph id="par_id235992404316585" role="paragraph" localize="false"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_filter.xhp b/source/text/scalc/01/func_filter.xhp index b1e1d53a34..35a6622ab4 100644 --- a/source/text/scalc/01/func_filter.xhp +++ b/source/text/scalc/01/func_filter.xhp @@ -29,7 +29,6 @@ <paragraph role="paragraph" id="par_id411709395137111"><emph>Range</emph>: The array or range to filter.</paragraph> <paragraph role="paragraph" id="par_id471709395141324"><emph>Criteria</emph>: A boolean array whose height (filtering by columns) or width (filtering by rows) is the same as the array, used to select data from the <emph>Range</emph>.</paragraph> <paragraph role="paragraph" id="par_id421709395146863"><emph>Return if empty</emph>: the value to return if all values in the Include array are empty (filter return nothing).</paragraph> -<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <embed href="text/scalc/01/stat_data.xhp#sampledata01"/> <paragraph role="paragraph" id="par_id21709506838932"><input>{=FILTER(A2:C13,A2:A13>50)}</input> returns the array {57,49,12|56,33,60|57,,} containing all grades with Maths grade above 50. Note that this is an array formula.</paragraph> <paragraph role="paragraph" id="par_id561709507935610"><input>{=FILTER(A2:C13,B2:B13>90,"No results")}</input> Returns the string "No results", since no grade on Physics is above 90.</paragraph> diff --git a/source/text/scalc/01/func_maxifs.xhp b/source/text/scalc/01/func_maxifs.xhp index 79f35edc96..1da5e07ac2 100644 --- a/source/text/scalc/01/func_maxifs.xhp +++ b/source/text/scalc/01/func_maxifs.xhp @@ -11,47 +11,48 @@ <meta> <topic id="textscalc01func_sumifsxml" indexer="include" status="PUBLISH"> - <title id="tit" xml-lang="en-US">MAXIFS function</title> + <title id="tit">MAXIFS function</title> <filename>/text/scalc/01/func_maxifs.xhp</filename> </topic> </meta> <body> <section id="maxifs_function"> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MAXIFS" id="bm_id657666576665766" localize="false"/> -<bookmark xml-lang="en-US" branch="index" id="bm_id658066580665806"> +<bookmark branch="hid/SC_HID_FUNC_MAXIFS" id="bm_id657666576665766" localize="false"/> +<bookmark branch="index" id="bm_id658066580665806"> <bookmark_value>MAXIFS function</bookmark_value> <bookmark_value>maximum;satisfying conditions</bookmark_value> </bookmark> <h1 id="hd_id658866588665886"><variable id="maxifs_head"><link href="text/scalc/01/func_maxifs.xhp">MAXIFS</link></variable> function</h1> -<paragraph id="par_id659756597565975" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="maxifs_des">Returns the maximum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp></paragraph> +<paragraph id="par_id659756597565975" role="paragraph"><ahelp hid="."><variable id="maxifs_des">Returns the maximum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp></paragraph> </section> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> -<paragraph id="par_id11655988824213" role="code" xml-lang="en-US">MAXIFS(<embedvar href="text/scalc/01/ex_data_stat_func.xhp#args" markup="ignore"/>)</paragraph> +<paragraph id="par_id11655988824213" role="code">MAXIFS(<embedvar href="text/scalc/01/ex_data_stat_func.xhp#args" markup="ignore"/>)</paragraph> -<paragraph id="par_id59901690530236" role="paragraph" xml-lang="en-US"><emph>Func_Range</emph> – required argument. A range of cells, a name of a named range or a label of a column or a row containing values for calculating the maximum.</paragraph> +<paragraph id="par_id59901690530236" role="paragraph"><emph>Func_Range</emph> – required argument. A range of cells, a name of a named range or a label of a column or a row containing values for calculating the maximum.</paragraph> <embed href="text/scalc/01/ex_data_stat_func.xhp#par00"/> <embed href="text/shared/00/00000001.xhp#regex"/> <embed href="text/scalc/01/ex_data_stat_func.xhp#warning01"/> <embed href="text/scalc/01/ex_data_stat_func.xhp#note01"/> <embed href="text/scalc/01/ex_data_stat_func.xhp#par01"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/> <h4 id="hd_id193452436229521">Simple usage</h4> -<paragraph id="par_id94321051525036" role="paragraph" xml-lang="en-US"><item type="input">=MAXIFS(B2:B6;B2:B6;"<35")</item></paragraph> -<paragraph id="par_id28647227259438" role="paragraph" xml-lang="en-US">Calculates the maximum of values of the range B2:B6 that are greater than or equal to 20. Returns 35. The fifth row does not meet the criterion.</paragraph> -<paragraph id="par_id36952767622741" role="paragraph" xml-lang="en-US"><item type="input">=MAXIFS(C2:C6;B2:B6;">=20";C2:C6;"<90")</item></paragraph> -<paragraph id="par_id189772445525114" role="paragraph" xml-lang="en-US">Calculates the maximum of values of the range C2:C6 that are lower than 90 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 85, because the fourth and fifth rows do not meet at least one criterion.</paragraph> +<paragraph id="par_id94321051525036" role="paragraph"><item type="input">=MAXIFS(B2:B6;B2:B6;"<35")</item></paragraph> +<paragraph id="par_id28647227259438" role="paragraph">Calculates the maximum of values of the range B2:B6 that are greater than or equal to 20. Returns 35. The fifth row does not meet the criterion.</paragraph> +<paragraph id="par_id36952767622741" role="paragraph"><item type="input">=MAXIFS(C2:C6;B2:B6;">=20";C2:C6;"<90")</item></paragraph> +<paragraph id="par_id189772445525114" role="paragraph">Calculates the maximum of values of the range C2:C6 that are lower than 90 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 85, because the fourth and fifth rows do not meet at least one criterion.</paragraph> <h4 id="hd_id30455222431067">Using regular expressions and nested functions</h4> -<paragraph id="par_id307691022525348" role="paragraph" xml-lang="en-US"><item type="input">=MAXIFS(C2:C6;B2:B6;">"&MIN(B2:B6);B2:B6;"<"&MAX(B2:B6))</item></paragraph> -<paragraph id="par_id27619246864839" role="paragraph" xml-lang="en-US">Calculates the maximum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 190, because only the fourth row meet the criteria.</paragraph> -<paragraph id="par_id220502883332563" role="paragraph" xml-lang="en-US"><item type="input">=MAXIFS(C2:C6;A2:A6;"pen.*";B2:B6;"<="&MAX(B2:B6))</item></paragraph> -<paragraph id="par_id15342189586295" role="paragraph" xml-lang="en-US">Calculates the maximum of values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with "pen" and to all cells of the B2:B6 range except its maximum. Returns 85, because only the third row meets all criteria.</paragraph> +<paragraph id="par_id307691022525348" role="paragraph"><item type="input">=MAXIFS(C2:C6;B2:B6;">"&MIN(B2:B6);B2:B6;"<"&MAX(B2:B6))</item></paragraph> +<paragraph id="par_id27619246864839" role="paragraph">Calculates the maximum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 190, because only the fourth row meet the criteria.</paragraph> +<paragraph id="par_id220502883332563" role="paragraph"><item type="input">=MAXIFS(C2:C6;A2:A6;"pen.*";B2:B6;"<="&MAX(B2:B6))</item></paragraph> +<paragraph id="par_id15342189586295" role="paragraph">Calculates the maximum of values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with "pen" and to all cells of the B2:B6 range except its maximum. Returns 85, because only the third row meets all criteria.</paragraph> <h4 id="hd_id8168283329426">Reference to a cell as a criterion</h4> -<paragraph id="par_id50762995519951" role="paragraph" xml-lang="en-US">If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the MAXIFS function. For example, the above function can be rewritten as follows:</paragraph> -<paragraph id="par_id135761606425300" role="paragraph" xml-lang="en-US"><item type="input">=MAXIFS(C2:C6;A2:A6;E2&".*";B2:B6;"<"&MAX(B2:B6))</item></paragraph> -<paragraph id="par_id30574750215839" role="paragraph" xml-lang="en-US">If E2 = "pen", the function returns 65, because the reference to the cell is substituted with its content.</paragraph> +<paragraph id="par_id50762995519951" role="paragraph">If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the MAXIFS function. For example, the above function can be rewritten as follows:</paragraph> +<paragraph id="par_id135761606425300" role="paragraph"><item type="input">=MAXIFS(C2:C6;A2:A6;E2&".*";B2:B6;"<"&MAX(B2:B6))</item></paragraph> +<paragraph id="par_id30574750215839" role="paragraph">If E2 = "pen", the function returns 65, because the reference to the cell is substituted with its content.</paragraph> <embed href="text/scalc/06/calcsamplefiles.xhp#func_ifs"/> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> <embed href="text/scalc/00/avail_release.xhp#5.2"/> @@ -59,20 +60,20 @@ <paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.MICROSOFT.MAXIFS</literal></paragraph> <section id="relatedtopics"> <tip id="par_id401677015482616"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/MAXIFS">MAXIFS wiki page</link>.</tip> -<paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US" localize="false"> +<paragraph id="par_id11921178730928" role="paragraph" localize="false"> <embedvar href="text/scalc/01/04060184.xhp#max_head"/>, <embedvar href="text/scalc/01/04060184.xhp#maxa_head"/>, <embedvar href="text/scalc/01/04060184.xhp#min_head"/>, <embedvar href="text/scalc/01/04060184.xhp#mina_head"/>, </paragraph> -<paragraph id="par_id11931178730928" role="paragraph" xml-lang="en-US" localize="false"> +<paragraph id="par_id11931178730928" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_countifs.xhp#countifs_head"/>, <embedvar href="text/scalc/01/func_minifs.xhp#minifs_head"/>, <embedvar href="text/scalc/01/func_maxifs.xhp#maxifs_head"/>, <embedvar href="text/scalc/01/func_averageifs.xhp#averageifs_head"/>, <embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/> </paragraph> -<paragraph id="par_id15970172625152" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph> +<paragraph id="par_id15970172625152" role="paragraph" localize="false"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_minifs.xhp b/source/text/scalc/01/func_minifs.xhp index 25a95b3e2b..4f0fc46e66 100644 --- a/source/text/scalc/01/func_minifs.xhp +++ b/source/text/scalc/01/func_minifs.xhp @@ -11,47 +11,48 @@ <meta> <topic id="textscalc01func_minifsxml" indexer="include" status="PUBLISH"> - <title id="tit" xml-lang="en-US">MINIFS function</title> + <title id="tit">MINIFS function</title> <filename>/text/scalc/01/func_minifs.xhp</filename> </topic> </meta> <body> <section id="minifs_function"> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MINIFS" id="bm_id657666576665766" localize="false"/> -<bookmark xml-lang="en-US" branch="index" id="bm_id658066580665806"> +<bookmark branch="hid/SC_HID_FUNC_MINIFS" id="bm_id657666576665766" localize="false"/> +<bookmark branch="index" id="bm_id658066580665806"> <bookmark_value>MINIFS function</bookmark_value> <bookmark_value>minimum;satisfying conditions</bookmark_value> </bookmark> <h1 id="hd_id658866588665886"><variable id="minifs_head"><link href="text/scalc/01/func_minifs.xhp">MINIFS</link></variable> function</h1> -<paragraph id="par_id659756597565975" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="minifs_des">Returns the minimum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp></paragraph> +<paragraph id="par_id659756597565975" role="paragraph"><ahelp hid="."><variable id="minifs_des">Returns the minimum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp></paragraph> </section> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> -<paragraph id="par_id11655988824213" role="code" xml-lang="en-US">MINIFS(<embedvar href="text/scalc/01/ex_data_stat_func.xhp#args" markup="ignore"/>)</paragraph> +<paragraph id="par_id11655988824213" role="code">MINIFS(<embedvar href="text/scalc/01/ex_data_stat_func.xhp#args" markup="ignore"/>)</paragraph> -<paragraph id="par_id59901690530236" role="paragraph" xml-lang="en-US"><emph>Func_Range</emph> – required argument. A range of cells, a name of a named range or a label of a column or a row containing values for calculating the minimum.</paragraph> +<paragraph id="par_id59901690530236" role="paragraph"><emph>Func_Range</emph> – required argument. A range of cells, a name of a named range or a label of a column or a row containing values for calculating the minimum.</paragraph> <embed href="text/scalc/01/ex_data_stat_func.xhp#par00"/> <embed href="text/shared/00/00000001.xhp#regex"/> <embed href="text/scalc/01/ex_data_stat_func.xhp#warning01"/> <embed href="text/scalc/01/ex_data_stat_func.xhp#note01"/> <embed href="text/scalc/01/ex_data_stat_func.xhp#par01"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/> <h4 id="hd_id193452436229521">Simple usage</h4> -<paragraph id="par_id94321051525036" role="paragraph" xml-lang="en-US"><item type="input">=MINIFS(B2:B6;B2:B6;"<35")</item></paragraph> -<paragraph id="par_id28647227259438" role="paragraph" xml-lang="en-US">Calculates the minimum of values of the range B2:B6 that are lower than or equal to 20. Returns 17.</paragraph> -<paragraph id="par_id36952767622741" role="paragraph" xml-lang="en-US"><item type="input">=MINIFS(C2:C6;B2:B6;">=20";C2:C6;">90")</item></paragraph> -<paragraph id="par_id189772445525114" role="paragraph" xml-lang="en-US">Calculates the minimum of values of the range C2:C6 that are lower than 90 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 190.</paragraph> +<paragraph id="par_id94321051525036" role="paragraph"><item type="input">=MINIFS(B2:B6;B2:B6;"<35")</item></paragraph> +<paragraph id="par_id28647227259438" role="paragraph">Calculates the minimum of values of the range B2:B6 that are lower than or equal to 20. Returns 17.</paragraph> +<paragraph id="par_id36952767622741" role="paragraph"><item type="input">=MINIFS(C2:C6;B2:B6;">=20";C2:C6;">90")</item></paragraph> +<paragraph id="par_id189772445525114" role="paragraph">Calculates the minimum of values of the range C2:C6 that are lower than 90 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 190.</paragraph> <h4 id="hd_id30455222431067">Using regular expressions and nested functions</h4> -<paragraph id="par_id307691022525348" role="paragraph" xml-lang="en-US"><item type="input">=MINIFS(C2:C6;B2:B6;">"&MIN(B2:B6);B2:B6;"<"&MAX(B2:B6))</item></paragraph> -<paragraph id="par_id27619246864839" role="paragraph" xml-lang="en-US">Calculates the minimum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 65.</paragraph> -<paragraph id="par_id220502883332563" role="paragraph" xml-lang="en-US"><item type="input">=MINIFS(C2:C6;A2:A6;".*book";B2:B6;">"&MIN(B2:B6))</item></paragraph> -<paragraph id="par_id15342189586295" role="paragraph" xml-lang="en-US">Calculates the minimum of values of the range C2:C6 that correspond to all cells of the A2:A6 range ending with "book" and to all cells of the B2:B6 range except its minimum. Returns 190.</paragraph> +<paragraph id="par_id307691022525348" role="paragraph"><item type="input">=MINIFS(C2:C6;B2:B6;">"&MIN(B2:B6);B2:B6;"<"&MAX(B2:B6))</item></paragraph> +<paragraph id="par_id27619246864839" role="paragraph">Calculates the minimum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 65.</paragraph> +<paragraph id="par_id220502883332563" role="paragraph"><item type="input">=MINIFS(C2:C6;A2:A6;".*book";B2:B6;">"&MIN(B2:B6))</item></paragraph> +<paragraph id="par_id15342189586295" role="paragraph">Calculates the minimum of values of the range C2:C6 that correspond to all cells of the A2:A6 range ending with "book" and to all cells of the B2:B6 range except its minimum. Returns 190.</paragraph> <h4 id="hd_id8168283329426">Reference to a cell as a criterion</h4> -<paragraph id="par_id50762995519951" role="paragraph" xml-lang="en-US">If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the MINIFS function. For example, the above function can be rewritten as follows:</paragraph> -<paragraph id="par_id135761606425300" role="paragraph" xml-lang="en-US"><item type="input">=MINIFS(C2:C6;A2:A6;".*"&E2;B2:B6;"<"&MAX(B2:B6))</item></paragraph> -<paragraph id="par_id30574750215839" role="paragraph" xml-lang="en-US">If E2 = "book", the function returns 180, because the reference to the cell is substituted with its content.</paragraph> +<paragraph id="par_id50762995519951" role="paragraph">If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the MINIFS function. For example, the above function can be rewritten as follows:</paragraph> +<paragraph id="par_id135761606425300" role="paragraph"><item type="input">=MINIFS(C2:C6;A2:A6;".*"&E2;B2:B6;"<"&MAX(B2:B6))</item></paragraph> +<paragraph id="par_id30574750215839" role="paragraph">If E2 = "book", the function returns 180, because the reference to the cell is substituted with its content.</paragraph> <embed href="text/scalc/06/calcsamplefiles.xhp#func_ifs"/> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> <embed href="text/scalc/00/avail_release.xhp#5.2"/> @@ -59,13 +60,13 @@ <paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.MICROSOFT.MINIFS</literal></paragraph> <section id="relatedtopics"> <tip id="par_id941677015454359"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/MINIFS">MINIFS wiki page</link>.</tip> -<paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US" localize="false"> +<paragraph id="par_id11921178730928" role="paragraph" localize="false"> <embedvar href="text/scalc/01/04060184.xhp#max_head"/>, <embedvar href="text/scalc/01/04060184.xhp#maxa_head"/>, <embedvar href="text/scalc/01/04060184.xhp#min_head"/>, <embedvar href="text/scalc/01/04060184.xhp#mina_head"/>, </paragraph> -<paragraph id="par_id11931178730928" role="paragraph" xml-lang="en-US" localize="false"> +<paragraph id="par_id11931178730928" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_countifs.xhp#countifs_head"/>, <embedvar href="text/scalc/01/func_minifs.xhp#minifs_head"/>, <embedvar href="text/scalc/01/func_maxifs.xhp#maxifs_head"/>, @@ -73,7 +74,7 @@ <embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/> </paragraph> -<paragraph id="par_id15970172625152" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph> +<paragraph id="par_id15970172625152" role="paragraph" localize="false"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_sumif.xhp b/source/text/scalc/01/func_sumif.xhp index 5f723e6183..5b8ac7767f 100644 --- a/source/text/scalc/01/func_sumif.xhp +++ b/source/text/scalc/01/func_sumif.xhp @@ -37,6 +37,7 @@ <paragraph id="par_id3152083" role="paragraph"><emph>SumRange: </emph>Optional. The range of cells from which values are summed. If no SumRange is given, the values in the Range are summed.</paragraph> <embed href="text/scalc/01/ODFF.xhp#odff"/> <section id="ex_sumif"> + <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/> <h4 id="hd_id451710857799382">Simple usage</h4> <paragraph role="paragraph" id="par_id171711049202378"><input>=SUMIF(C2:C6,">=100")</input></paragraph> diff --git a/source/text/scalc/01/func_sumifs.xhp b/source/text/scalc/01/func_sumifs.xhp index 039d1d81bc..4e7bc391d3 100644 --- a/source/text/scalc/01/func_sumifs.xhp +++ b/source/text/scalc/01/func_sumifs.xhp @@ -38,6 +38,7 @@ <embed href="text/scalc/01/ex_data_stat_func.xhp#note01"/> <embed href="text/scalc/01/ex_data_stat_func.xhp#par01"/> <embed href="text/scalc/01/ODFF.xhp#odff"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/> <h4 id="hd_id193452436229521">Simple usage</h4> |