[Libreoffice-bugs] [Bug 104646] Sumifs is not summing up if a criteria left blank

[bugzilla-daemon]

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

--- Comment #3 from m.a.riosv  ---
https://help.libreoffice.org/Calc/Handling_of_Empty_Cells

-- 
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

[Libreoffice-bugs] [Bug 104646] Sumifs is not summing up if a criteria left blank

[bugzilla-daemon]

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

--- Comment #2 from p_kongs...@op.pl ---
Could you please explain why this is implemented like this?

You are comparing 2 cells which are identical in this case blank and I expected
it to return the value.

Your workaround is solving the issue, but still I find this being a little bit
odd.

Thank you in advance.

-- 
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

[Libreoffice-bugs] [Bug 104646] Sumifs is not summing up if a criteria left blank

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 CC||miguelangelrv@libreoffice.o
   ||rg
 Resolution|--- |NOTABUG

--- Comment #1 from m.a.riosv  ---
A blank cell it's not the same than an empty string, B2 it's used as zero,
you can force an empty string with a formula like:

=SUMIFS(F$2:F$10,D$2:D$10,"",E$2:E$10,"")

that works for me.

You can test your formula putting a zero on E8.

-- 
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