source/text/scalc/01/func_countifs.xhp | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 48807862eb87e3c1b874e25eb3b48f04deb224c8
Author: Adolfo Jayme Barrientos <fit...@ubuntu.com>
AuthorDate: Thu Nov 19 19:13:41 2020 -0600
Commit: Adolfo Jayme Barrientos <fit...@ubuntu.com>
CommitDate: Thu Nov 19 19:13:41 2020 -0600
We’re stuck with these unfortunately
Change-Id: Ic6350bf8490a88dec55d453de849c3eb697ad9db
diff --git a/source/text/scalc/01/func_countifs.xhp
b/source/text/scalc/01/func_countifs.xhp
index 9047b8b32..e9b49865f 100644
--- a/source/text/scalc/01/func_countifs.xhp
+++ b/source/text/scalc/01/func_countifs.xhp
@@ -44,7 +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 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>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
