https://bugs.documentfoundation.org/show_bug.cgi?id=120179
--- Comment #6 from Rafael Lima <[email protected]> --- Created attachment 175196 --> https://bugs.documentfoundation.org/attachment.cgi?id=175196&action=edit 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: https://support.microsoft.com/en-us/office/sumif-function-169b8c99-c05c-4483-a712-1697a653039b 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. -- You are receiving this mail because: You are the assignee for the bug.
