[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

--- Comment #3 from Pawel <pavlo250 at gmail.com> ---
(In reply to m.a.riosv from comment #2)
> Created attachment 145254 [details]
> 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.

I see now. Thanks for clarification. I agree now that there is no bug, but
would be great to mention about that use case in documentation of sumif
formula.

-- 
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/1ce8ccf0/attachment.html>