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@lists.freedesktop.org
Reporter: gesb...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs