<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - COUNTIF not counting non-blank cells"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=112115">bug 112115</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;">Status</td>
<td>UNCONFIRMED
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - COUNTIF not counting non-blank cells"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=112115#c1">Comment # 1</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - COUNTIF not counting non-blank cells"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=112115">bug 112115</a>
from <span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span></b>
<pre>Your formula does not count non-blank cells, it ("<>""") counts cells where the
content is unequal to " a double quote. Note that within an inline literal
string constant two double quotes "" represent one escaped double quote.
5.4 changed how empty cells are treated, ie. they are counted for "equals
empty" ("=") or "not-equals not-empty" ("<>X") like other spreadsheet
applications do.
To count non-empty cells your formula should have "<>" as criteria argument,
eg. =COUNTIF(D24:N24,"<>")
Or compare to Y in your case, =COUNTIF(D24:N24,"=Y")</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>