<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - [LOCALHELP] rewrite SUMIF Help page" href="https://bugs.documentfoundation.org/show_bug.cgi?id=120179#c6">Comment # 6</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - [LOCALHELP] rewrite SUMIF Help page" href="https://bugs.documentfoundation.org/show_bug.cgi?id=120179">bug 120179</a> from <a class="email" href="mailto:rafael.palma.lima@gmail.com" title="Rafael Lima <rafael.palma.lima@gmail.com>"> Rafael Lima</a> <pre>Created <a href="https://bugs.documentfoundation.org/attachment.cgi?id=175196" name="attach_175196" title="SUMIF with different range sizes">attachment 175196</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=175196&action=edit" title="SUMIF with different range sizes">[details]</a> SUMIF with different range sizes > 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). I ran some tests and this is no longer the case. SUMIF accepts ranges of different sizes. Maybe this was an enhancement after this bug was filed, but the fact is that now SUMIF does work if both ranges have different sizes (see attached example). It seems that the size of the first range always prevails, be it smaller or larger than the sum range. I guess this is due to MS compatibility: <a href="https://support.microsoft.com/en-us/office/sumif-function-169b8c99-c05c-4483-a712-1697a653039b">https://support.microsoft.com/en-us/office/sumif-function-169b8c99-c05c-4483-a712-1697a653039b</a> In Excel, "the formula will sum a range of cells that starts with the first cell in sum_range but has the same dimensions as range". So far, this behavior is reproducible in LO Calc as well.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>