https://bugs.documentfoundation.org/show_bug.cgi?id=96923
--- Comment #12 from Eike Rathke <er...@redhat.com> ---
Excel in itself is iconsistent. Take for example the formula
=SUMIF($B$3:$B$6,1,$C$3:$C$6) in B16. This apparently evaluates every B3:B6=1
as TRUE and thus sums all values in C3:C6 to 10. But, for
=SUMIF($B$3:$B$6,1,$B$3:$B$6) the result is 2 and not 4 so it either sums only
the numeric values in B3:B6 or only evaluates the numeric values in B3:B6 in
the condition as TRUE. Same for =SUMIF($B$3:$B$6,1)
--
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
