https://bugs.freedesktop.org/show_bug.cgi?id=78516
Priority: medium
Bug ID: 78516
Assignee: [email protected]
Summary: "=?" conditional not recognized in SUMIF function
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 4.2.3.3 release
Component: Spreadsheet
Product: LibreOffice
Simple example: column A has numbers to be summed, but only add the values from
A if the corresponding cell in column B is not blank.
=SUMIF(B1:B5,"=?",A1:A5)
A B
---
3 A
4 A
4 B
5
2
With this data, the formula should give result 11 (the sum of the first 3
values in column A). but Calc from Libre Office Version: 4.2.3.3, Build ID:
882f8a0a489bc99a9e60c7905a60226254cb6ff0
returns a value of zero. Microsoft Excel will return the correct value.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
