<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 - FILEOPEN XLSX: Calc doesn't handle SUMIFS() with array as the third parameter correctly"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133260">133260</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILEOPEN XLSX: Calc doesn't handle SUMIFS() with array as the third parameter correctly
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.6.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>enhancement
</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>plateauwolf@qq.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=161113" name="attach_161113" title="Sample file using SUM(SUMIF())">attachment 161113</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=161113&action=edit" title="Sample file using SUM(SUMIF())">[details]</a></span>
Sample file using SUM(SUMIF())
This bug is forwarded and translated from a report in a Chinese user forum,
original report (in Chinese) at:
<a href="https://bbs.libreofficechina.org/thread-2459-1-1.html">https://bbs.libreofficechina.org/thread-2459-1-1.html</a>
The issue is that in MS Excel the function SUMIFS() allows its third parameter
"criteria1" to be an array, and the return value is also an array corresponding
the SUMIFS() result with the criteria being each member of the parameter array.
The attached example shows one usage of this by using SUM() on the SUMIFS()
result array and calculate the sum of different people's salaries. This works
in Excel but not in Calc. The expected value for cell D17 is 15501 (sum of D10
and D13), while in Calc (after "Recalculate Hard" if necessary) D17 is 9812
(just D10).
On the other hand, I can't find official documentation saying SUMIFS() supports
array as the third parameter, and I don't know what the specification says, so
I'm filing as an enhancement request.
The original report is for version 6.3.6 on Windows 10 and 6.4.3 on Ubuntu
20.04, I've reproduced with 6.4.4:
Version: 6.4.4.2 (x64)
Build ID: 3d775be2011f3886db32dfd395a6a6d1ca2630ff
CPU threads: 2; OS: Windows 10.0 Build 18363; UI render: default; VCL: win;
Locale: zh-CN (zh_CN); UI-Language: en-US
Calc: threaded</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>