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:54 +0200 |
| commit | e7e056ade1c2aa65aa7d1b9e6453735011886707 (patch) | |
| tree | 61e92b09be7b0616c5b8f85f31ea26ee55b03eb7 | |
| parent | 7a7b8fc05994922fe3233e80c79110012e2b11da (diff) | |
Improve 'IFS documentation
COUNTIFS, SUMIFS, AVERAGEIFS, MAXIFS, MINIFS
Improve collateral file
Change-Id: I0573b4df1b7fdc5b656100756e98468bc2a0edf7
Reviewed-on: https://gerrit.libreoffice.org/56311
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
76 files changed, 97 insertions, 24 deletions
diff --git a/source/media/files/scalc/am/functions_ifs.ods b/source/media/files/scalc/am/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/am/functions_ifs.ods +++ b/source/media/files/scalc/am/functions_ifs.ods diff --git a/source/media/files/scalc/ar/functions_ifs.ods b/source/media/files/scalc/ar/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/ar/functions_ifs.ods +++ b/source/media/files/scalc/ar/functions_ifs.ods diff --git a/source/media/files/scalc/ast/functions_ifs.ods b/source/media/files/scalc/ast/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/ast/functions_ifs.ods +++ b/source/media/files/scalc/ast/functions_ifs.ods diff --git a/source/media/files/scalc/bg/functions_ifs.ods b/source/media/files/scalc/bg/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/bg/functions_ifs.ods +++ b/source/media/files/scalc/bg/functions_ifs.ods diff --git a/source/media/files/scalc/bn-IN/functions_ifs.ods b/source/media/files/scalc/bn-IN/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/bn-IN/functions_ifs.ods +++ b/source/media/files/scalc/bn-IN/functions_ifs.ods diff --git a/source/media/files/scalc/bn/functions_ifs.ods b/source/media/files/scalc/bn/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/bn/functions_ifs.ods +++ b/source/media/files/scalc/bn/functions_ifs.ods diff --git a/source/media/files/scalc/bo/functions_ifs.ods b/source/media/files/scalc/bo/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/bo/functions_ifs.ods +++ b/source/media/files/scalc/bo/functions_ifs.ods diff --git a/source/media/files/scalc/bs/functions_ifs.ods b/source/media/files/scalc/bs/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/bs/functions_ifs.ods +++ b/source/media/files/scalc/bs/functions_ifs.ods diff --git a/source/media/files/scalc/ca-valencia/functions_ifs.ods b/source/media/files/scalc/ca-valencia/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/ca-valencia/functions_ifs.ods +++ b/source/media/files/scalc/ca-valencia/functions_ifs.ods diff --git a/source/media/files/scalc/ca/functions_ifs.ods b/source/media/files/scalc/ca/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/ca/functions_ifs.ods +++ b/source/media/files/scalc/ca/functions_ifs.ods diff --git a/source/media/files/scalc/cs/functions_ifs.ods b/source/media/files/scalc/cs/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/cs/functions_ifs.ods +++ b/source/media/files/scalc/cs/functions_ifs.ods diff --git a/source/media/files/scalc/da/functions_ifs.ods b/source/media/files/scalc/da/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/da/functions_ifs.ods +++ b/source/media/files/scalc/da/functions_ifs.ods diff --git a/source/media/files/scalc/de/functions_ifs.ods b/source/media/files/scalc/de/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/de/functions_ifs.ods +++ b/source/media/files/scalc/de/functions_ifs.ods diff --git a/source/media/files/scalc/dz/functions_ifs.ods b/source/media/files/scalc/dz/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/dz/functions_ifs.ods +++ b/source/media/files/scalc/dz/functions_ifs.ods diff --git a/source/media/files/scalc/el/functions_ifs.ods b/source/media/files/scalc/el/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/el/functions_ifs.ods +++ b/source/media/files/scalc/el/functions_ifs.ods diff --git a/source/media/files/scalc/en-GB/functions_ifs.ods b/source/media/files/scalc/en-GB/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/en-GB/functions_ifs.ods +++ b/source/media/files/scalc/en-GB/functions_ifs.ods diff --git a/source/media/files/scalc/en-US/functions_ifs.ods b/source/media/files/scalc/en-US/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/en-US/functions_ifs.ods +++ b/source/media/files/scalc/en-US/functions_ifs.ods diff --git a/source/media/files/scalc/en-ZA/functions_ifs.ods b/source/media/files/scalc/en-ZA/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/en-ZA/functions_ifs.ods +++ b/source/media/files/scalc/en-ZA/functions_ifs.ods diff --git a/source/media/files/scalc/eo/functions_ifs.ods b/source/media/files/scalc/eo/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/eo/functions_ifs.ods +++ b/source/media/files/scalc/eo/functions_ifs.ods diff --git a/source/media/files/scalc/es/functions_ifs.ods b/source/media/files/scalc/es/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/es/functions_ifs.ods +++ b/source/media/files/scalc/es/functions_ifs.ods diff --git a/source/media/files/scalc/et/functions_ifs.ods b/source/media/files/scalc/et/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/et/functions_ifs.ods +++ b/source/media/files/scalc/et/functions_ifs.ods diff --git a/source/media/files/scalc/eu/functions_ifs.ods b/source/media/files/scalc/eu/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/eu/functions_ifs.ods +++ b/source/media/files/scalc/eu/functions_ifs.ods diff --git a/source/media/files/scalc/fi/functions_ifs.ods b/source/media/files/scalc/fi/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/fi/functions_ifs.ods +++ b/source/media/files/scalc/fi/functions_ifs.ods diff --git a/source/media/files/scalc/fr/functions_ifs.ods b/source/media/files/scalc/fr/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/fr/functions_ifs.ods +++ b/source/media/files/scalc/fr/functions_ifs.ods diff --git a/source/media/files/scalc/functions_ifs.ods b/source/media/files/scalc/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/functions_ifs.ods +++ b/source/media/files/scalc/functions_ifs.ods diff --git a/source/media/files/scalc/gl/functions_ifs.ods b/source/media/files/scalc/gl/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/gl/functions_ifs.ods +++ b/source/media/files/scalc/gl/functions_ifs.ods diff --git a/source/media/files/scalc/gu/functions_ifs.ods b/source/media/files/scalc/gu/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/gu/functions_ifs.ods +++ b/source/media/files/scalc/gu/functions_ifs.ods diff --git a/source/media/files/scalc/he/functions_ifs.ods b/source/media/files/scalc/he/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/he/functions_ifs.ods +++ b/source/media/files/scalc/he/functions_ifs.ods diff --git a/source/media/files/scalc/hi/functions_ifs.ods b/source/media/files/scalc/hi/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/hi/functions_ifs.ods +++ b/source/media/files/scalc/hi/functions_ifs.ods diff --git a/source/media/files/scalc/hr/functions_ifs.ods b/source/media/files/scalc/hr/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/hr/functions_ifs.ods +++ b/source/media/files/scalc/hr/functions_ifs.ods diff --git a/source/media/files/scalc/hu/functions_ifs.ods b/source/media/files/scalc/hu/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/hu/functions_ifs.ods +++ b/source/media/files/scalc/hu/functions_ifs.ods diff --git a/source/media/files/scalc/id/functions_ifs.ods b/source/media/files/scalc/id/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/id/functions_ifs.ods +++ b/source/media/files/scalc/id/functions_ifs.ods diff --git a/source/media/files/scalc/is/functions_ifs.ods b/source/media/files/scalc/is/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/is/functions_ifs.ods +++ b/source/media/files/scalc/is/functions_ifs.ods diff --git a/source/media/files/scalc/it/functions_ifs.ods b/source/media/files/scalc/it/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/it/functions_ifs.ods +++ b/source/media/files/scalc/it/functions_ifs.ods diff --git a/source/media/files/scalc/ja/functions_ifs.ods b/source/media/files/scalc/ja/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/ja/functions_ifs.ods +++ b/source/media/files/scalc/ja/functions_ifs.ods diff --git a/source/media/files/scalc/ka/functions_ifs.ods b/source/media/files/scalc/ka/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/ka/functions_ifs.ods +++ b/source/media/files/scalc/ka/functions_ifs.ods diff --git a/source/media/files/scalc/km/functions_ifs.ods b/source/media/files/scalc/km/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/km/functions_ifs.ods +++ b/source/media/files/scalc/km/functions_ifs.ods diff --git a/source/media/files/scalc/ko/functions_ifs.ods b/source/media/files/scalc/ko/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/ko/functions_ifs.ods +++ b/source/media/files/scalc/ko/functions_ifs.ods diff --git a/source/media/files/scalc/lo/functions_ifs.ods b/source/media/files/scalc/lo/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/lo/functions_ifs.ods +++ b/source/media/files/scalc/lo/functions_ifs.ods diff --git a/source/media/files/scalc/lt/functions_ifs.ods b/source/media/files/scalc/lt/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/lt/functions_ifs.ods +++ b/source/media/files/scalc/lt/functions_ifs.ods diff --git a/source/media/files/scalc/lv/functions_ifs.ods b/source/media/files/scalc/lv/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/lv/functions_ifs.ods +++ b/source/media/files/scalc/lv/functions_ifs.ods diff --git a/source/media/files/scalc/mk/functions_ifs.ods b/source/media/files/scalc/mk/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/mk/functions_ifs.ods +++ b/source/media/files/scalc/mk/functions_ifs.ods diff --git a/source/media/files/scalc/nb/functions_ifs.ods b/source/media/files/scalc/nb/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/nb/functions_ifs.ods +++ b/source/media/files/scalc/nb/functions_ifs.ods diff --git a/source/media/files/scalc/ne/functions_ifs.ods b/source/media/files/scalc/ne/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/ne/functions_ifs.ods +++ b/source/media/files/scalc/ne/functions_ifs.ods diff --git a/source/media/files/scalc/nl/functions_ifs.ods b/source/media/files/scalc/nl/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/nl/functions_ifs.ods +++ b/source/media/files/scalc/nl/functions_ifs.ods diff --git a/source/media/files/scalc/nn/functions_ifs.ods b/source/media/files/scalc/nn/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/nn/functions_ifs.ods +++ b/source/media/files/scalc/nn/functions_ifs.ods diff --git a/source/media/files/scalc/om/functions_ifs.ods b/source/media/files/scalc/om/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/om/functions_ifs.ods +++ b/source/media/files/scalc/om/functions_ifs.ods diff --git a/source/media/files/scalc/pl/functions_ifs.ods b/source/media/files/scalc/pl/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/pl/functions_ifs.ods +++ b/source/media/files/scalc/pl/functions_ifs.ods diff --git a/source/media/files/scalc/pt-BR/functions_ifs.ods b/source/media/files/scalc/pt-BR/functions_ifs.ods Binary files differindex 93e43e201e..f1857045f8 100644 --- a/source/media/files/scalc/pt-BR/functions_ifs.ods +++ b/source/media/files/scalc/pt-BR/functions_ifs.ods diff --git a/source/media/files/scalc/pt/functions_ifs.ods b/source/media/files/scalc/pt/functions_ifs.ods Binary files differindex 93e43e201e..0792b5e6a0 100644 --- a/source/media/files/scalc/pt/functions_ifs.ods +++ b/source/media/files/scalc/pt/functions_ifs.ods diff --git a/source/media/files/scalc/qtz/functions_ifs.ods b/source/media/files/scalc/qtz/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/qtz/functions_ifs.ods +++ b/source/media/files/scalc/qtz/functions_ifs.ods diff --git a/source/media/files/scalc/ro/functions_ifs.ods b/source/media/files/scalc/ro/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/ro/functions_ifs.ods +++ b/source/media/files/scalc/ro/functions_ifs.ods diff --git a/source/media/files/scalc/ru/functions_ifs.ods b/source/media/files/scalc/ru/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/ru/functions_ifs.ods +++ b/source/media/files/scalc/ru/functions_ifs.ods diff --git a/source/media/files/scalc/si/functions_ifs.ods b/source/media/files/scalc/si/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/si/functions_ifs.ods +++ b/source/media/files/scalc/si/functions_ifs.ods diff --git a/source/media/files/scalc/sid/functions_ifs.ods b/source/media/files/scalc/sid/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/sid/functions_ifs.ods +++ b/source/media/files/scalc/sid/functions_ifs.ods diff --git a/source/media/files/scalc/sk/functions_ifs.ods b/source/media/files/scalc/sk/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/sk/functions_ifs.ods +++ b/source/media/files/scalc/sk/functions_ifs.ods diff --git a/source/media/files/scalc/sl/functions_ifs.ods b/source/media/files/scalc/sl/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/sl/functions_ifs.ods +++ b/source/media/files/scalc/sl/functions_ifs.ods diff --git a/source/media/files/scalc/sq/functions_ifs.ods b/source/media/files/scalc/sq/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/sq/functions_ifs.ods +++ b/source/media/files/scalc/sq/functions_ifs.ods diff --git a/source/media/files/scalc/sv/functions_ifs.ods b/source/media/files/scalc/sv/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/sv/functions_ifs.ods +++ b/source/media/files/scalc/sv/functions_ifs.ods diff --git a/source/media/files/scalc/ta/functions_ifs.ods b/source/media/files/scalc/ta/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/ta/functions_ifs.ods +++ b/source/media/files/scalc/ta/functions_ifs.ods diff --git a/source/media/files/scalc/tg/functions_ifs.ods b/source/media/files/scalc/tg/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/tg/functions_ifs.ods +++ b/source/media/files/scalc/tg/functions_ifs.ods diff --git a/source/media/files/scalc/tr/functions_ifs.ods b/source/media/files/scalc/tr/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/tr/functions_ifs.ods +++ b/source/media/files/scalc/tr/functions_ifs.ods diff --git a/source/media/files/scalc/ug/functions_ifs.ods b/source/media/files/scalc/ug/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/ug/functions_ifs.ods +++ b/source/media/files/scalc/ug/functions_ifs.ods diff --git a/source/media/files/scalc/uk/functions_ifs.ods b/source/media/files/scalc/uk/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/uk/functions_ifs.ods +++ b/source/media/files/scalc/uk/functions_ifs.ods diff --git a/source/media/files/scalc/vi/functions_ifs.ods b/source/media/files/scalc/vi/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/vi/functions_ifs.ods +++ b/source/media/files/scalc/vi/functions_ifs.ods diff --git a/source/media/files/scalc/zh-CN/functions_ifs.ods b/source/media/files/scalc/zh-CN/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/zh-CN/functions_ifs.ods +++ b/source/media/files/scalc/zh-CN/functions_ifs.ods diff --git a/source/media/files/scalc/zh-TW/functions_ifs.ods b/source/media/files/scalc/zh-TW/functions_ifs.ods Binary files differindex 93e43e201e..f20937c84d 100644 --- a/source/media/files/scalc/zh-TW/functions_ifs.ods +++ b/source/media/files/scalc/zh-TW/functions_ifs.ods diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index 08c0ffc7e6..297f91c12c 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -1122,7 +1122,7 @@ <comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMME" id="bm_id3163608" localize="false"/> -<paragraph id="hd_id3163596" role="heading" level="2" xml-lang="en-US">SUM</paragraph> +<paragraph id="hd_id3163596" role="heading" level="2" xml-lang="en-US"><variable id="sum_head"><link href="text/scalc/01/04060106.xhp#Section16">SUM</link></variable></paragraph> <paragraph id="par_id3163625" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SUMME">Adds all the numbers in a range of cells.</ahelp></paragraph> <paragraph id="hd_id3163643" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> @@ -1150,7 +1150,7 @@ <comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMMEWENN" id="bm_id3151969" localize="false"/> -<paragraph id="hd_id3151957" role="heading" level="2" xml-lang="en-US">SUMIF</paragraph> +<paragraph id="hd_id3151957" role="heading" level="2" xml-lang="en-US"><variable id="sumif_head"><link href="text/scalc/01/04060106.xhp#Section15">SUMIF</link></variable></paragraph> <paragraph id="par_id3151986" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SUMMEWENN">Adds the cells specified by a given criteria.</ahelp> This function is used to browse a range when you search for a certain value.</paragraph> <embed href="text/shared/00/00000001.xhp#regulaer"/> diff --git a/source/text/scalc/01/04060181.xhp b/source/text/scalc/01/04060181.xhp index 1909e4b56e..df8f67f535 100644 --- a/source/text/scalc/01/04060181.xhp +++ b/source/text/scalc/01/04060181.xhp @@ -62,7 +62,7 @@ <comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ANZAHL" id="bm_id3153040" localize="false"/> -<paragraph id="hd_id3148437" role="heading" level="2" xml-lang="en-US">COUNT</paragraph> +<paragraph id="hd_id3148437" role="heading" level="2" xml-lang="en-US"><variable id="count_head"><link href="text/scalc/01/04060181.xhp#count">COUNT</link></variable></paragraph> <paragraph id="par_id3150700" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ANZAHL">Counts how many numbers are in the list of arguments.</ahelp> Text entries are ignored.</paragraph> <paragraph id="hd_id3153930" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> @@ -82,7 +82,7 @@ <comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ANZAHL2" id="bm_id3148738" localize="false"/> -<paragraph id="hd_id3149729" role="heading" level="2" xml-lang="en-US">COUNTA</paragraph> +<paragraph id="hd_id3149729" role="heading" level="2" xml-lang="en-US"><variable id="counta_head"><link href="text/scalc/01/04060181.xhp#counta">COUNTA</link></variable></paragraph> <paragraph id="par_id3150142" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ANZAHL2">Counts how many values are in the list of arguments.</ahelp> Text entries are also counted, even when they contain an empty string of length 0. If an argument is an array or reference, empty cells within the array or reference are ignored.<comment>UFI: fix to #i35888#</comment></paragraph> <paragraph id="hd_id3148573" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> @@ -103,7 +103,7 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ANZAHLLEEREZELLEN" id="bm_id3149730" localize="false"/> -<paragraph id="hd_id3150896" role="heading" level="2" xml-lang="en-US">COUNTBLANK</paragraph> +<paragraph id="hd_id3150896" role="heading" level="2" xml-lang="en-US"><variable id="countblank_head"><link href="text/scalc/01/04060181.xhp#countblank">COUNTBLANK</link></variable></paragraph> <paragraph id="par_id3155260" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ANZAHLLEEREZELLEN">Returns the number of empty cells.</ahelp></paragraph> <paragraph id="hd_id3145144" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> @@ -122,7 +122,7 @@ <comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZAEHLENWENN" id="bm_id3164909" localize="false"/> -<paragraph id="hd_id3164897" role="heading" level="2" xml-lang="en-US">COUNTIF</paragraph> +<paragraph id="hd_id3164897" role="heading" level="2" xml-lang="en-US"><variable id="countif_head"><link href="text/scalc/01/04060181.xhp#countif">COUNTIF</link></variable></paragraph> <paragraph id="par_id3164926" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ZAEHLENWENN">Returns the number of cells that meet with certain criteria within a cell range.</ahelp></paragraph> <embed href="text/shared/00/00000001.xhp#regulaer"/> diff --git a/source/text/scalc/01/04060184.xhp b/source/text/scalc/01/04060184.xhp index fd6dc0eceb..bd85e34437 100644 --- a/source/text/scalc/01/04060184.xhp +++ b/source/text/scalc/01/04060184.xhp @@ -34,7 +34,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3154511"><bookmark_value>MAX function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MAX" id="bm_id3146972" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3154511" role="heading" level="2">MAX</paragraph> +<paragraph xml-lang="en-US" id="hd_id3154511" role="heading" level="2"><variable id="max_head"><link href="text/scalc/01/04060184.xhp#max">MAX</link></variable></paragraph> <paragraph xml-lang="en-US" id="par_id3153709" role="paragraph"><ahelp hid="HID_FUNC_MAX">Returns the maximum value in a list of arguments.</ahelp></paragraph> <paragraph xml-lang="en-US" id="par_id9282509" role="paragraph">Returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN() and MAX(). The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. Passing a literal string argument to MIN() or MAX(), e.g. MIN("string"), still results in an error.</paragraph> <paragraph xml-lang="en-US" id="hd_id3154256" role="heading" level="3">Syntax</paragraph> @@ -50,7 +50,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3166426"><bookmark_value>MAXA function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MAXA" id="bm_id3150304" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3166426" role="heading" level="2">MAXA</paragraph> +<paragraph xml-lang="en-US" id="hd_id3166426" role="heading" level="2"><variable id="maxa_head"><link href="text/scalc/01/04060184.xhp#maxa">MAXA</link></variable></paragraph> <paragraph xml-lang="en-US" id="par_id3150363" role="paragraph"><ahelp hid="HID_FUNC_MAXA">Returns the maximum value in a list of arguments. In opposite to MAX, here you can enter text. The value of the text is 0.</ahelp></paragraph> <paragraph xml-lang="en-US" id="par_id7689443" role="paragraph">The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered.</paragraph> <paragraph xml-lang="en-US" id="hd_id3150516" role="heading" level="3">Syntax</paragraph> @@ -66,7 +66,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3153820"><bookmark_value>MEDIAN function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MEDIAN" id="bm_id3153069" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3153820" role="heading" level="2">MEDIAN</paragraph> +<paragraph xml-lang="en-US" id="hd_id3153820" role="heading" level="2"><variable id="median_head"><link href="text/scalc/01/04060184.xhp#median">MEDIAN</link></variable></paragraph> <paragraph xml-lang="en-US" id="par_id3151241" role="paragraph"><ahelp hid="HID_FUNC_MEDIAN">Returns the median of a set of numbers. In a set containing an uneven number of values, the median will be the number in the middle of the set and in a set containing an even number of values, it will be the mean of the two values in the middle of the set.</ahelp></paragraph> <paragraph xml-lang="en-US" id="hd_id3148871" role="heading" level="3">Syntax</paragraph> <paragraph xml-lang="en-US" id="par_id3155264" role="code">MEDIAN(Number1; Number2; ...; Number30)</paragraph> @@ -79,7 +79,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3154541"><bookmark_value>MIN function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MIN" id="bm_id3159226" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3154541" role="heading" level="2">MIN</paragraph> +<paragraph xml-lang="en-US" id="hd_id3154541" role="heading" level="2"><variable id="min_head"><link href="text/scalc/01/04060184.xhp#min">MIN</link></variable></paragraph> <paragraph xml-lang="en-US" id="par_id3143222" role="paragraph"><ahelp hid="HID_FUNC_MIN">Returns the minimum value in a list of arguments.</ahelp></paragraph> <paragraph xml-lang="en-US" id="par_id2301400" role="paragraph">Returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN() and MAX(). The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. Passing a literal string argument to MIN() or MAX(), e.g. MIN("string"), still results in an error.</paragraph> <paragraph xml-lang="en-US" id="hd_id3154651" role="heading" level="3">Syntax</paragraph> @@ -93,7 +93,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3147504"><bookmark_value>MINA function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MINA" id="bm_id3155752" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3147504" role="heading" level="2">MINA</paragraph> +<paragraph xml-lang="en-US" id="hd_id3147504" role="heading" level="2"><variable id="mina_head"><link href="text/scalc/01/04060184.xhp#mina">MINA</link></variable></paragraph> <paragraph xml-lang="en-US" id="par_id3147249" role="paragraph"><ahelp hid="HID_FUNC_MINA">Returns the minimum value in a list of arguments. Here you can also enter text. The value of the text is 0.</ahelp></paragraph> <paragraph xml-lang="en-US" id="par_id4294564" role="paragraph">The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered.</paragraph> <paragraph xml-lang="en-US" id="hd_id3150435" role="heading" level="3">Syntax</paragraph> @@ -110,7 +110,7 @@ <bookmark_value>averages;statistical functions</bookmark_value> </bookmark><comment>mw added "averages;"</comment> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELABW" id="bm_id3156396" localize="false"/> -<paragraph role="heading" id="hd_id3166465" xml-lang="en-US" level="2">AVEDEV</paragraph> +<paragraph role="heading" id="hd_id3166465" xml-lang="en-US" level="2"><variable id="avedev_head"><link href="text/scalc/01/04060184.xhp#avedev">AVEDEV</link></variable></paragraph> <paragraph role="paragraph" id="par_id3150373" xml-lang="en-US"><ahelp hid="HID_FUNC_MITTELABW">Returns the average of the absolute deviations of data points from their mean.</ahelp> Displays the diffusion in a data set.</paragraph> <paragraph role="heading" id="hd_id3150038" xml-lang="en-US" level="3">Syntax</paragraph> <paragraph role="code" id="par_id3145636" xml-lang="en-US">AVEDEV(Number1; Number2; ...; Number30)</paragraph> @@ -124,7 +124,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3145824"><bookmark_value>AVERAGE function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELWERT" id="bm_id3146878" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3145824" role="heading" level="2">AVERAGE</paragraph> +<paragraph xml-lang="en-US" id="hd_id3145824" role="heading" level="2"><variable id="average_head"><link href="text/scalc/01/04060184.xhp#average">AVERAGE</link></variable></paragraph> <paragraph xml-lang="en-US" id="par_id3150482" role="paragraph"><ahelp hid="HID_FUNC_MITTELWERT">Returns the average of the arguments.</ahelp></paragraph> <paragraph xml-lang="en-US" id="hd_id3146943" role="heading" level="3">Syntax</paragraph> <paragraph xml-lang="en-US" id="par_id3154679" role="code">AVERAGE(Number1; Number2; ...; Number30)</paragraph> @@ -138,7 +138,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3148754"><bookmark_value>AVERAGEA function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELWERTA" id="bm_id3149690" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3148754" role="heading" level="2">AVERAGEA</paragraph> +<paragraph xml-lang="en-US" id="hd_id3148754" role="heading" level="2"><variable id="averagea_head"><link href="text/scalc/01/04060184.xhp#averagea">AVERAGEA</link></variable></paragraph> <paragraph xml-lang="en-US" id="par_id3145138" role="paragraph"><ahelp hid="HID_FUNC_MITTELWERTA">Returns the average of the arguments. The value of a text is 0.</ahelp></paragraph> <paragraph xml-lang="en-US" id="hd_id3153326" role="heading" level="3">Syntax</paragraph> <paragraph xml-lang="en-US" id="par_id3149734" role="code">AVERAGEA(Value1; Value2; ...; Value30)</paragraph> 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> diff --git a/source/text/scalc/01/func_averageifs.xhp b/source/text/scalc/01/func_averageifs.xhp index 6a38f4e4d8..cd6be6eabc 100644 --- a/source/text/scalc/01/func_averageifs.xhp +++ b/source/text/scalc/01/func_averageifs.xhp @@ -51,9 +51,22 @@ <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> +<embed href="text/scalc/06/calcsamplefiles.xhp#func_ifs"/> <section id="relatedtopics"> - <paragraph id="par_id1279148769260" 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_averageif.xhp#averageif_head"/>, <embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_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_countifs.xhp#countifs_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_id20741445030307" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></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"/>, + <embedvar href="text/scalc/01/func_averageif.xhp#averageif_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_id20741445030307" role="paragraph" localize="false" xml-lang="en-US"><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 f47b269ab7..82c3c7716c 100644 --- a/source/text/scalc/01/func_countifs.xhp +++ b/source/text/scalc/01/func_countifs.xhp @@ -54,7 +54,19 @@ <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> <embed href="text/scalc/06/calcsamplefiles.xhp#func_ifs"/> <section id="relatedtopics"> - <paragraph id="par_id14337286612130" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060181.xhp#count">COUNT</link>, <link href="text/scalc/01/04060181.xhp#countif">COUNTIF</link>, <link href="text/scalc/01/04060181.xhp#counta">COUNTA</link>, <embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_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/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"> + <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> </section> </body> diff --git a/source/text/scalc/01/func_maxifs.xhp b/source/text/scalc/01/func_maxifs.xhp index 43c1ac083e..9483642ee1 100644 --- a/source/text/scalc/01/func_maxifs.xhp +++ b/source/text/scalc/01/func_maxifs.xhp @@ -53,9 +53,22 @@ <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> +<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_averageifs.xhp#averageifs_head"/>, <embedvar href="text/scalc/01/func_minifs.xhp#minifs_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_id15970172625152" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph> +<paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US" 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"> +<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> </helpdocument> diff --git a/source/text/scalc/01/func_minifs.xhp b/source/text/scalc/01/func_minifs.xhp index 0f5d54f551..2443e4e533 100644 --- a/source/text/scalc/01/func_minifs.xhp +++ b/source/text/scalc/01/func_minifs.xhp @@ -53,9 +53,23 @@ <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> +<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_averageifs.xhp#averageifs_head"/>, <embedvar href="text/scalc/01/func_maxifs.xhp#maxifs_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_id15970172625152" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph> +<paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US" 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"> +<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> </helpdocument> 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> |