https://bugs.documentfoundation.org/show_bug.cgi?id=144889
Bug ID: 144889
Summary: SUMIFS
Product: LibreOffice
Version: 7.2.1.2 release
Hardware: x86 (IA32)
OS: Mac OS X (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
SUMIFS only uses Range1 and Criteria1, it ignores all other Ranges and
Criterias
Steps to Reproduce:
Make this table:
A B C D E
1 | a | green apple | apple | =SUMIFS(A:A,B:B,"*"&D1&"*",C:C,"*"&D1&"*")
1 | Orange | | banana | =SUMIFS(A:A,B:B,"*"&D2&"*",C:C,"*"&D2&"*")
20 | a | red apple |
1 | banana |
1 | kiwi |
1 | banana |
Now E1 should equal 21. Why? because if you paste C1 into B1 then E1 equals 1,
that means SUMIFS is only using range1 and criteria2 ignoring all others
Expected Results:
21
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
For each row, the value of column A should be summed if either the value of
column B or C matches the word D.
Regex expressions should be like any other software, "*" alone doesn't mean
anything, it should have something before it, for example:
.*
a*
[1-9]*
etc
--
You are receiving this mail because:
You are the assignee for the bug.
