https://bugs.documentfoundation.org/show_bug.cgi?id=119980
Bug ID: 119980
Summary: COUNTIF function doesn't return values when Criteria
is set to a cell
Product: LibreOffice
Version: 6.1.1.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Example:
A1 = 3
A2 = 3
A3 = 5
COUNTIF(A1:A3,"3") will return 2. However, if I populate a cell with 3 (i.e.
B1) and call COUNTIF(A1:A3,B1), this returns 0.
Also, the documentation for this function says the syntax should be
COUNTIF(<RANGE>;<CRITERIA>) but when I use this format, Calc changes the syntax
to a comma delimiting the RANGE and CRITERIA.
i.e. enter COUNTIF(A1:A3;"3") and Calc returns COUNTIF(A1:A3,"3")
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
