[Libreoffice-bugs] [Bug 131081] SUMIF with 1 conditional on a y/n match yields 0 in LibreOffice yet sums correctly in Google Sheet with same data

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #3 from ann at href.com ---
Good suggestion to attach the sample, because, in doing that, and going through
the data to sanitize it before uploading, I noticed that all my "numbers" were
strings starting with ', due to something going wrong during the initial
import.  After removing all the leading ' symbols, SUMIFS worked to give a
non-zero answer.

Sorry to bother you. 

Perhaps a line could be added to the documentation re troubleshooting, if the
Sum is 0, most likely the data is not numeric and has to be inspected at the
cell level, not visually for the sheet.

-- 
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/20200304/4558ed02/attachment.htm>