[Libreoffice-bugs] [Bug 120179] New: sumif works wrong if Range has different row index than SumRange

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 120179
           Summary: sumif works wrong if Range has different row index
                    than SumRange
           Product: LibreOffice
           Version: 6.1.2.1 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: pavlo250 at gmail.com

Description:
My purpose was to conditionally sum values from a few rows.

I have written formula (G3 cell in attached file) :
=SUMIF(B2:B10,"=2",A2:A10) - this calculates good
=SUMIF(B5:B10,"=2",A5:A10) - this also is good

but when from some reasons I had to  provide different start row index in
Ranges or in SumRange then result was wrong
=SUMIF(B5:B10,"=2",A2:A10) - this fails
=SUMIF(B2:B10,"=2",A5:A10) - and this fails also

I was testing it on debian linux system with version libre office 6.0 and
latest 6.1.2



Steps to Reproduce:
1.Open attached file
2.See columns F3 and H3, should have the same values as G3 and I3 but have not.


Actual Results:
formula =SUMIF(B2:B10,"=2",A2:A10)  returns different value than
=SUMIF(B5:B10,"=2",A2:A10)

Expected Results:
=SUMIF(B5:B10,"=2",A2:A10) should return 3 also.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
I don't see any option to attach file with example of bug

-- 
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/20180928/5d229590/attachment.html>