https://bugs.documentfoundation.org/show_bug.cgi?id=133260
m.a.riosv <miguelange...@libreoffice.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |miguelangelrv@libreoffice.o
| |rg
--- Comment #1 from m.a.riosv <miguelange...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs