https://bugs.documentfoundation.org/show_bug.cgi?id=95659
Bug ID: 95659
Summary: SUMIF does not sum properly if criteria cell contain
symbol within text
Product: LibreOffice
Version: 5.0.2.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
I created a column, filled it with Product Name list, and then tried to use
SUMIF to sum any cell that matched with Product Name.
Some of it didn't work, so I checked the cell Text. If it contains plus sign
(+), it won't work, for example:
*) Video+Power
*) Video + Power
But any other symbol, such as (&) or (-) works. To reproduce:
- Fill A1 with any text containing plus sign(+), such as: Video+Power
- Fill A2 to A3 with any text without any plus sign(+), such as: Video-Power
- Fill B1 to B3 with any number
- Fill C1 with this formula: =SUMIF(A1:A3;A1;B1:B3)
The SUMIF result will be 0. If you use SUMIF without any plus sign(+), it will
return the true result.
--
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
