https://bugs.documentfoundation.org/show_bug.cgi?id=105847
--- Comment #6 from m.a.riosv <[email protected]> ---
(In reply to stragu from comment #5)
> 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);
Ok.
> - 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)
Ok.
> - 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).
Ok. B:B it's only an abbreviation of B1:B1048576
>
> 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.
Well for me the only unintitive is when ranges has different lenght. The others
only give you more power for calculations.
>
> Plus, how come SUMIF() interprets the sum_range silently but SUMIFS() throws
> an error if dimensions are different?
I think to avoid incompatibility issues with other spreadsheet apps.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
