From 48807862eb87e3c1b874e25eb3b48f04deb224c8 Mon Sep 17 00:00:00 2001 From: Adolfo Jayme Barrientos Date: Thu, 19 Nov 2020 19:13:41 -0600 Subject: We’re stuck with these unfortunately MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Change-Id: Ic6350bf8490a88dec55d453de849c3eb697ad9db --- source/text/scalc/01/func_countifs.xhp | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'source') diff --git a/source/text/scalc/01/func_countifs.xhp b/source/text/scalc/01/func_countifs.xhp index 9047b8b324..e9b49865f7 100644 --- a/source/text/scalc/01/func_countifs.xhp +++ b/source/text/scalc/01/func_countifs.xhp @@ -44,7 +44,7 @@ =COUNTIFS(B2:B6;">=20";C2:C6;">70") 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.

Using regular expressions and nested functions

-For these examples to work as described, make sure that Enable regular expressions in formulas is selected in %PRODUCTNAME > PreferencesTools > Options > $[officename] Calc > Calculate. +For these examples to work as described, make sure that Enable regular expressions in formulas is selected in %PRODUCTNAME - PreferencesTools - Options - $[officename] Calc - Calculate. =COUNTIFS(B2:B6;"[:alpha:]*") Counts the amount of rows of the B2:B6 range that contain only alphabet symbols. Returns 1, because only sixth row meets the criterion. =COUNTIFS(B2:B6;">"&MIN(B2:B6);B2:B6;"<"&MAX(B2:B6)) -- cgit