source/text/scalc/01/ex_data_stat_func.xhp | 77 ++++++++++++++---------------
source/text/scalc/01/func_averageif.xhp | 70 +++++++++++++-------------
source/text/scalc/01/func_averageifs.xhp | 40 +++++++--------
source/text/scalc/01/func_countifs.xhp | 43 ++++++++--------
source/text/scalc/01/func_filter.xhp | 1
source/text/scalc/01/func_maxifs.xhp | 41 +++++++--------
source/text/scalc/01/func_minifs.xhp | 41 +++++++--------
source/text/scalc/01/func_sumif.xhp | 1
source/text/scalc/01/func_sumifs.xhp | 1
9 files changed, 160 insertions(+), 155 deletions(-)
New commits:
commit 9f4e1983f6edae8f5ce8ee2e319410d4e1e39084
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Tue Mar 26 13:11:59 2024 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed Mar 27 19:29:55 2024 +0100
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.hal...@libreoffice.org>
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>
