https://bugs.documentfoundation.org/show_bug.cgi?id=105044
Bug ID: 105044
Summary: SUMIF and SUMIFS give wrong results when empty cells
Product: LibreOffice
Version: 5.2.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
The result of SUMIF and SUMIFS is wrong when the test range contains an empty
cell and the criterium is "different from a given string".
Example: SUMIF(A1:A7;"<>X";B1:B7)
=> does not sum up cells having the A column epmty.
While: SUMIF(A1:A7;"=";B1:B7) or SUMIF(A1:A7;"";B1:B7) gives a correct result.
See attached sheet.
Steps to Reproduce:
1.Prepare a column of 7 string having some empty cells and a column of 7
numbers
2.Put the formula : SUMIF(A1:A7;"<>X";B1:B7)
3.The result is not correct.
Actual Results:
Empty cells are not counted in the sum.
Expected Results:
Empty cells should be counted since they are different from "X"
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:50.0) Gecko/20100101
Firefox/50.0
--
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
