https://bugs.documentfoundation.org/show_bug.cgi?id=98873
Bug ID: 98873
Summary: SUMIF does not sum
Product: LibreOffice
Version: 5.0.5.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: iea...@ielogical.com
I have many named ranges
Racks is a table with many blank values
=SUMIF(RowNbr, "11", Racks) does not work.
It returns only the first value found
Does not matter if on the same sheet or another sheet
Does not work with =SUMIF(N4:N145, "11", O4:AA145) either
Does not matter if criteria is enclosed in quotes or not
=COUNTIF(RowNbr,11) returns 4, the correct value
=SUMIF(RowNbr, "11", RowNbr) works and returns 44
=SUM(Racks) returns 272 which is the correct value
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
