[Libreoffice-bugs] [Bug 120179] [LOCALHELP] rewrite SUMIF Help page

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=120179

--- Comment #6 from Rafael Lima <rafael.palma.lima at gmail.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210922/842faf2c/attachment-0001.htm>