https://bugs.documentfoundation.org/show_bug.cgi?id=105847
--- Comment #5 from stragu <stephane.guil...@member.fsf.org> ---
thanks for getting back to me. Thanks for the explanations in the spreadsheet.
For some reason, my result column had row 6 and 7 stuck with invalid results
and I had to recalculate them (with the F9 key), and that solved the issue with
odd numbers.
So, tell me if I understand well how SUMIF() works:
- It compares cells at a specific position *in the defined ranges*, not cells
that are aligned in the grid (e.g. for SUMIF(A2:A10, "yes", B1:B9), the cell A2
will be matched to B1);
- If <range> and <sum_range> do not have the same dimension, <sum_range> will
be modified to have the same dimensions as <range> (e.g. for SUMIF(A1:A10,
"yes", B2:B3), <sum_range> will be interpreted as B2:B11)
- If <range> has coordinates in both axes but <sum_range> is a whole column or
row, <sum_range> will be interpreted as the range of same dimension as <range>
and starting at the first cell in the column or row (e.g. for SUMIF(A3:A10,
"yes", B:B), <sum_range> will be interpreted as B1:B8).
If that is how it works, well OK, but I have to say, it feels very unintuitive
(it took me way too much time and a bug report to get my head around it), and
the LibreOffice help does not explain that at all, from what I have seen.
Plus, how come SUMIF() interprets the sum_range silently but SUMIFS() throws an
error if dimensions are different?
--
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
