[Libreoffice-bugs] [Bug 131081] New: 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

            Bug ID: 131081
           Summary: SUMIF with 1 conditional on a y/n match yields 0 in
                    LibreOffice yet sums correctly in Google Sheet with
                    same data
           Product: LibreOffice
           Version: 6.3.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: ann at href.com

Description:
Numeric values in column D.  Some of these number are deductible expenses. 
Column A has a flag to say which ones are deductible.  This flag is a "y"
(single char) when deductible else blank.  Many lines are "y" and a few are
blank. 
The answer 0 is definitely wrong for my data.
This is the formula:
=SUMIFS(D2:D61, A2:A61, "=1")
Note that I imported this data from a CSV file. It is possible that some
encoding problem has resulted in a situation where LibreOffice cannot see
numbers as numbers.  Visually, I cannot see a problem.

Steps to Reproduce:
Here is some sample data, use the formula above.
        Entry Date      Desc    Amt
y       11/14/2019      abc     25
        11/14/2019      def     10

Expected Results:
25


Reproducible: Always


User Profile Reset: No



Additional Info:
The hint-help and online help for SUMIFS is particularly confusing. There are
too many different opinions about the required parameters.

I sanity checked my data and formula using Google Sheets. I pasted the data in
and did the total using their syntax, and got a non-zero answer.  Therefore I
do think my data is clean and this is a core bug on a much needed feature.

-- 
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/20200303/d68e3b3f/attachment.htm>