diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2018-06-22 23:32:13 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2018-06-23 13:02:35 +0200 |
| commit | 9c72214669c1f04d0e91e4c477c76c44b3aa63b4 (patch) | |
| tree | 7d2c63923f29b9a976628982d581ec8542090194 /source/text/scalc/01/func_sumifs.xhp | |
| parent | Regex + operator finds one or more, not one (diff) | |
| download | help-9c72214669c1f04d0e91e4c477c76c44b3aa63b4.tar.gz help-9c72214669c1f04d0e91e4c477c76c44b3aa63b4.zip | |
Improve 'IFS documentation
COUNTIFS, SUMIFS, AVERAGEIFS, MAXIFS, MINIFS
Improve collateral file
Change-Id: I0573b4df1b7fdc5b656100756e98468bc2a0edf7
Reviewed-on: https://gerrit.libreoffice.org/56310
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc/01/func_sumifs.xhp')
| -rw-r--r-- | source/text/scalc/01/func_sumifs.xhp | 14 |
1 files changed, 12 insertions, 2 deletions
diff --git a/source/text/scalc/01/func_sumifs.xhp b/source/text/scalc/01/func_sumifs.xhp index cf1c5503fb..5065ea5b67 100644 --- a/source/text/scalc/01/func_sumifs.xhp +++ b/source/text/scalc/01/func_sumifs.xhp @@ -53,9 +53,19 @@ <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 SUMIFS 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">=SUMIFS(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 link to the cell is substituted with its content.</paragraph> - +<embed href="text/scalc/06/calcsamplefiles.xhp#func_ifs"/> <section id="relatedtopics"> - <paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060106.xhp#Section16">SUM</link>, <link href="text/scalc/01/04060106.xhp#Section15">SUMIF</link>, <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"/>, <link href="text/scalc/01/04060184.xhp#max">MAX</link>, <link href="text/scalc/01/04060184.xhp#min">MIN</link></paragraph> +<paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US" localize="false"> +<embedvar href="text/scalc/01/04060106.xhp#sum_head"/>, +<embedvar href="text/scalc/01/04060106.xhp#sumif_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_id15970172625152" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph> </section> </body> |