<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:miguelangelrv@libreoffice.org" title="m.a.riosv <miguelangelrv@libreoffice.org>"> <span class="fn">m.a.riosv</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - sumif works wrong if Range has different row index than SumRange"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=120179">bug 120179</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>miguelangelrv@libreoffice.org
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - sumif works wrong if Range has different row index than SumRange"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=120179#c2">Comment # 2</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - sumif works wrong if Range has different row index than SumRange"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=120179">bug 120179</a>
from <span class="vcard"><a class="email" href="mailto:miguelangelrv@libreoffice.org" title="m.a.riosv <miguelangelrv@libreoffice.org>"> <span class="fn">m.a.riosv</span></a>
</span></b>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=145254" name="attach_145254" title="File sample, sumif">attachment 145254</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=145254&action=edit" title="File sample, sumif">[details]</a></span>
File sample, sumif
Both ranges should have the same length in rows or columns, or the second range
has only the first cell (not compatible with other file formats).
But if not, only the rows on the second range with the same relative position
than in range of criteria, are summed.
Take a see to your file sample modified, so what rows are summed it's more
visible.
IMO there is not a bug, it does what you have formulated.
BTW SUMIFS it's I think more friendly, because the summed range it's the first
and it's easy to add more criteria at the end of the function.
Please if you are not agree, reopen it.</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>