diff options
| author | Seth Chaiklin <sdc.blanco@youmail.dk> | 2020-11-19 18:03:38 +0100 |
|---|---|---|
| committer | Seth Chaiklin <sdc.blanco@youmail.dk> | 2020-11-20 00:21:19 +0100 |
| commit | 4e4118d7e8b08b9ea42e37f75f7ef168bdab0745 (patch) | |
| tree | b71269851657131dbf5eb3b189edc4b161ddffa5 /source | |
| parent | 093a4ea01b58504de7bd88d2a043585ab078c302 (diff) | |
tdf#114660 add explanation about setting regex option in Calc help example
Change-Id: I6da4f95cb4cdb09a4d2ccdbf35fab7f5f5db1102
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/106137
Tested-by: Jenkins
Reviewed-by: Seth Chaiklin <sdc.blanco@youmail.dk>
Diffstat (limited to 'source')
| -rw-r--r-- | source/text/scalc/01/func_countifs.xhp | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/source/text/scalc/01/func_countifs.xhp b/source/text/scalc/01/func_countifs.xhp index 8d57b125ca..9047b8b324 100644 --- a/source/text/scalc/01/func_countifs.xhp +++ b/source/text/scalc/01/func_countifs.xhp @@ -44,6 +44,7 @@ <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> <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> |