[Libreoffice-bugs] [Bug 120179] sumif works wrong if Range has different row index than SumRange

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=120179

m.a.riosv <miguelangelrv at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |miguelangelrv at libreoffice.o
                   |                            |rg

--- Comment #2 from m.a.riosv <miguelangelrv at libreoffice.org> ---
Created attachment 145254
  --> https://bugs.documentfoundation.org/attachment.cgi?id=145254&action=edit
File sample, sumif

Both ranges should have the same length in rows or columns, or the second range
has only the first cell (not compatible with other file formats).
But if not, only the rows on the second range with the same relative position
than in  range of criteria, are summed. 

Take a see to your file sample modified, so what rows are summed it's more
visible.

IMO there is not a bug, it does what you have formulated.

BTW SUMIFS it's I think more friendly, because the summed range it's the first
and it's easy to add more criteria at the end of the function.

Please if you are not agree, reopen it.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180928/a2f69ca4/attachment.html>