diff options
Diffstat (limited to 'source/text/scalc/01/func_averageif.xhp')
-rw-r--r-- | source/text/scalc/01/func_averageif.xhp | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/source/text/scalc/01/func_averageif.xhp b/source/text/scalc/01/func_averageif.xhp index ed548b2d85..fc30cc190b 100644 --- a/source/text/scalc/01/func_averageif.xhp +++ b/source/text/scalc/01/func_averageif.xhp @@ -65,7 +65,18 @@ If the whole range is empty, contains only text or all values of the range do no <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> <section id="relatedtopics"> -<paragraph id="par_id171371269326270" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060184.xhp#average">AVERAGE</link>, <link href="text/scalc/01/04060184.xhp#averagea">AVERAGEA</link>, <embedvar href="text/scalc/01/func_averageifs.xhp#averageifs_head"/>, <link href="text/scalc/01/04060184.xhp#max">MAX</link>, <link href="text/scalc/01/04060184.xhp#min">MIN</link>, <link href="text/scalc/01/04060183.xhp#large">LARGE</link>, <link href="text/scalc/01/04060183.xhp#small">SMALL</link></paragraph> + <paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US" 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"> + <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> </section> </body> |