<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - sumif works wrong if Range has different row index than SumRange" href="https://bugs.documentfoundation.org/show_bug.cgi?id=120179#c3">Comment # 3</a> on <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - sumif works wrong if Range has different row index than SumRange" href="https://bugs.documentfoundation.org/show_bug.cgi?id=120179">bug 120179</a> from <a class="email" href="mailto:pavlo250@gmail.com" title="Pawel <pavlo250@gmail.com>"> Pawel</a> <pre>(In reply to m.a.riosv from <a href="show_bug.cgi?id=120179#c2">comment #2</a>) > Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=145254" name="attach_145254" title="File sample, sumif">attachment 145254</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=145254&action=edit" title="File sample, sumif">[details]</a> > 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>