https://bugs.documentfoundation.org/show_bug.cgi?id=120179
m.a.riosv <miguelange...@libreoffice.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |miguelangelrv@libreoffice.o
| |rg
--- Comment #2 from m.a.riosv <miguelange...@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._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
