AND() seems to cheat FILTER() function?
<p>I am trying to COUNTA() a range of cells in one column.</p>

<p>When I use only FILTER() with plain conditions then it is ok.</p>

<pre><code>=COUNTA(iferror(filter(F1:F10;left(F1:F10)=5)))
</code></pre>

<p>returns a true number (7 in this case because 7 cells have 5 as the first digit).</p>

<p>But when I try to use FILTER() and one of conditions closed inside AND() then it fails.</p>

<pre><code>=COUNTA(iferror(filter(F1:F10;and(left(F1:F10)=5))))
</code></pre>

<p>returns 0. In my opinion it also should return 7.</p>

<p>I want to use AND() to make more complex conditions but it fails just at the start. Do you have any ideas why?</p>