[Libreoffice-bugs] [Bug 121696] [EDITING] Usage of "Inequality" criteria in function SUMIF creates wrong result

https://bugs.documentfoundation.org/show_bug.cgi?id=121696 himajin100...@gmail.com changed: What|Removed |Added CC||a...@protonmail.com ---

[Libreoffice-bugs] [Bug 121696] [EDITING] Usage of "Inequality" criteria in function SUMIF creates wrong result

https://bugs.documentfoundation.org/show_bug.cgi?id=121696 Eike Rathke changed: What|Removed |Added Status|RESOLVED|CLOSED -- You are receiving this

[Libreoffice-bugs] [Bug 121696] [EDITING] Usage of "Inequality" criteria in function SUMIF creates wrong result

https://bugs.documentfoundation.org/show_bug.cgi?id=121696 Eike Rathke changed: What|Removed |Added Status|NEW |RESOLVED Resolution|---

[Libreoffice-bugs] [Bug 121696] [EDITING] Usage of "Inequality" criteria in function SUMIF creates wrong result

https://bugs.documentfoundation.org/show_bug.cgi?id=121696 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Blocks||108253 R

[Libreoffice-bugs] [Bug 121696] [EDITING] Usage of "Inequality" criteria in function SUMIF creates wrong result

https://bugs.documentfoundation.org/show_bug.cgi?id=121696 himajin100...@gmail.com changed: What|Removed |Added See Also||https://bugs.documentfou

[Libreoffice-bugs] [Bug 121696] [EDITING] Usage of "Inequality" criteria in function SUMIF creates wrong result

https://bugs.documentfoundation.org/show_bug.cgi?id=121696 himajin100...@gmail.com changed: What|Removed |Added See Also||https://bugs.documentfou

[Libreoffice-bugs] [Bug 121696] [EDITING] Usage of "Inequality" criteria in function SUMIF creates wrong result

https://bugs.documentfoundation.org/show_bug.cgi?id=121696 Mike Kaganski changed: What|Removed |Added CC||olivier.hallot@documentfoun

[Libreoffice-bugs] [Bug 121696] [EDITING] Usage of "Inequality" criteria in function SUMIF creates wrong result

https://bugs.documentfoundation.org/show_bug.cgi?id=121696 --- Comment #9 from Oliver Brinzing --- (In reply to Mike Kaganski from comment #8) > =SUMPRODUCT(A2:A7;B2:B7<>"";B2:B7<>0) will not work with excel (result is 0) > =SUMIFS(A2:A7;B2:B7;"<>0";B2:B7;"<>") will work with excel too (result

[Libreoffice-bugs] [Bug 121696] [EDITING] Usage of "Inequality" criteria in function SUMIF creates wrong result

https://bugs.documentfoundation.org/show_bug.cgi?id=121696 --- Comment #8 from Mike Kaganski --- (In reply to Oliver Brinzing from comment #7) > the "[ ] Treat empty string as zero" compatibility option seems to have no > influence. is this correct? Citing bug 73081 comment 0: > Notice the part

[Libreoffice-bugs] [Bug 121696] [EDITING] Usage of "Inequality" criteria in function SUMIF creates wrong result

https://bugs.documentfoundation.org/show_bug.cgi?id=121696 Oliver Brinzing changed: What|Removed |Added Version|6.1.2.1 release |6.1.3.2 release --- Comment #7

[Libreoffice-bugs] [Bug 121696] [EDITING] Usage of "Inequality" criteria in function SUMIF creates wrong result

https://bugs.documentfoundation.org/show_bug.cgi?id=121696 Mike Kaganski changed: What|Removed |Added CC||er...@redhat.com --- Comment #6

[Libreoffice-bugs] [Bug 121696] [EDITING] Usage of "Inequality" criteria in function SUMIF creates wrong result

https://bugs.documentfoundation.org/show_bug.cgi?id=121696 Oliver Brinzing changed: What|Removed |Added See Also||https://bugs.documentfounda

[Libreoffice-bugs] [Bug 121696] [EDITING] Usage of "Inequality" criteria in function SUMIF creates wrong result

https://bugs.documentfoundation.org/show_bug.cgi?id=121696 Oliver Brinzing changed: What|Removed |Added Keywords||bibisected,

[Libreoffice-bugs] [Bug 121696] [EDITING] Usage of "Inequality" criteria in function SUMIF creates wrong result

https://bugs.documentfoundation.org/show_bug.cgi?id=121696 --- Comment #4 from Oliver Brinzing --- Created attachment 147007 --> https://bugs.documentfoundation.org/attachment.cgi?id=147007&action=edit example excel 2016 result with excel 2016 is 63 -- You are receiving this mail because: Yo

[Libreoffice-bugs] [Bug 121696] [EDITING] Usage of "Inequality" criteria in function SUMIF creates wrong result

https://bugs.documentfoundation.org/show_bug.cgi?id=121696 Oliver Brinzing changed: What|Removed |Added Status|UNCONFIRMED |NEW CC|

[Libreoffice-bugs] [Bug 121696] [EDITING] Usage of "Inequality" criteria in function SUMIF creates wrong result

https://bugs.documentfoundation.org/show_bug.cgi?id=121696 --- Comment #2 from Mike Kaganski --- And what happens if you put 0 to B5 and B6? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Lib

[Libreoffice-bugs] [Bug 121696] [EDITING] Usage of "Inequality" criteria in function SUMIF creates wrong result

https://bugs.documentfoundation.org/show_bug.cgi?id=121696 Martin Lorscheid changed: What|Removed |Added CC||lorma...@arcor.de --- Comment