https://bugs.documentfoundation.org/show_bug.cgi?id=120179
--- Comment #3 from Pawel <pavlo...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
