[Libreoffice-bugs] [Bug 118876] New: SUMIF using cell above criteria match. Excel works.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 118876
           Summary: SUMIF using cell above criteria match.  Excel works.
           Product: LibreOffice
           Version: 6.0.5.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: gesbrid at yahoo.com

Description:
The sheet is from the author's solution to problem 9 in Chapter 21 of
the book "Microsoft Excel 2016 Data Analysis and Business Modeling".
I get the right anwser in Excel, but the wrong result when using Calc.
There is a problem with SUMIF.  It is summing the cell above the 
the proper match in each case.

See explanation below and attached sheet with the behavior.

Steps to Reproduce:
1.Set Product value of C21 to "plane" 
2.Set Month value of D21 to "Jan"
3. cell E21 should show result of adding C9+C13, which is 160.  
Excel gives right answer.  Calc gives result of adding C8+C12 = 266.

Actual Results:

See above "Steps to Reproduce".  
Calc gives result of adding C8+C12 = 266.
Excel gives right (C9+C13) result.



Expected Results:
cell E21 should show result of adding C9+C13, which is 160.  
Excel gives right answer.  


Reproducible: Always


User Profile Reset: No



Additional Info:
The sheet is from the author's solution to problem 9 in Chapter 21 of
the book "Microsoft Excel 2016 Data Analysis and Business Modeling".

-- 
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/20180722/12ba4d41/attachment.html>