[Libreoffice-bugs] [Bug 120179] sumif works wrong if Range has different row index than SumRange
https://bugs.documentfoundation.org/show_bug.cgi?id=120179 m.a.riosv changed: What|Removed |Added CC||olivier.hallot@documentfoun ||dation.org --- Comment #4 from m.a.riosv --- Hi Olivier what do you think about? -- 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
[Libreoffice-bugs] [Bug 120179] sumif works wrong if Range has different row index than SumRange
https://bugs.documentfoundation.org/show_bug.cgi?id=120179 --- Comment #3 from Pawel --- (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
[Libreoffice-bugs] [Bug 120179] sumif works wrong if Range has different row index than SumRange
https://bugs.documentfoundation.org/show_bug.cgi?id=120179 m.a.riosv changed: What|Removed |Added Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED -- 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
[Libreoffice-bugs] [Bug 120179] sumif works wrong if Range has different row index than SumRange
https://bugs.documentfoundation.org/show_bug.cgi?id=120179 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg --- Comment #2 from m.a.riosv --- Created attachment 145254 --> https://bugs.documentfoundation.org/attachment.cgi?id=145254=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
[Libreoffice-bugs] [Bug 120179] sumif works wrong if Range has different row index than SumRange
https://bugs.documentfoundation.org/show_bug.cgi?id=120179 --- Comment #1 from Pawel --- Created attachment 145248 --> https://bugs.documentfoundation.org/attachment.cgi?id=145248=edit ods file with example of bug related with sumif -- 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