How to use array and OR and AND in google spread sheet
<p>I've using this formula in google sheet to get the answer. Somewhere the logic is wrong please suggest. All logic i applied seams wrong </p>

<pre><code>=ArrayFormula(SUM(IF(OR(T:T="A",U:U="y"),1,0)))

B   X
A   y
A   x
A   y
B   x
</code></pre>

<p>Answer should be 2. Pls help where I am wrong ?</p>