<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - SUMIFS"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=144889">144889</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>SUMIFS
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.2.1.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86 (IA32)
</td>
</tr>
<tr>
<th>OS</th>
<td>Mac OS X (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>simoncarbajal@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>