https://bugs.documentfoundation.org/show_bug.cgi?id=105847
--- Comment #4 from m.a.riosv <[email protected]> ---
Created attachment 131036
--> https://bugs.documentfoundation.org/attachment.cgi?id=131036&action=edit
Sample file adapted.
In reply to stragu from comment #3)
> Hi m.a.riosv
>
> ......
>
> When you say "you can put =SUMIF(A2:A5; "yes"; B2) and it works fine", do
> you mean that the sum_range "B2" is interpreted as "B2:B5"? (In which case,
> the result "4" would make sense)
Yes for SUMIF() only
>
> Or do you mean that it is useless to define the end of the range for
> sum_range, and that inputting e.g. "B2:B5" would result in "B5" being
> completely ignored? If that is the case, again, it is a very unintuitive
> behaviour, and it would not explain the result "4".
Yes for SUMIF() only
>
> Anyway, neither of those explanations would explain the bulk of the cases
> presented in the attached spreadsheet.
>
Attached you file with what the formulas are doing and the equivalent for
SUMIFS, with all cases.
This site is for bug not for questions, so it's better first do the questions
on ask.libreoffice.org, that can be founded on several languages, and then if a
bug it's appreciated report it here.
--
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
