[Libreoffice-bugs] [Bug 133260] FILEOPEN XLSX: Calc doesn't handle SUMIFS() with array as the third parameter correctly

[bugzilla-daemon at bugs.documentfoundation.org]

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

m.a.riosv <miguelangelrv at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |miguelangelrv at libreoffice.o
                   |                            |rg

--- Comment #1 from m.a.riosv <miguelangelrv at libreoffice.org> ---
Created attachment 161177
  --> https://bugs.documentfoundation.org/attachment.cgi?id=161177&action=edit
Edited sample file

For me:
=SUMIFS(D8:D14;C8:C14;{"li"|"liu"}) => 9812

{=SUMIFS(D8:D14;C8:C14;{"li"|"liu"})}  => 9812   5689

=SUM(SUMIFS(D8:D14;C8:C14;{"li"|"liu"})) => 9812

{=SUM(SUMIFS(D8:D14;C8:C14;{"li"|"liu"}))} => 15501

I have not excel to test but I think you need to enter it as array
[Ctrl+Shift+Enter]

-- 
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/20200523/53b46edf/attachment-0001.htm>