[Libreoffice-bugs] [Bug 144889] New: SUMIFS

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: simoncarbajal at gmail.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20211003/66c542bf/attachment.htm>