title: Multiple conditionally count in google sheet
body: <p>I am trying to count thous cells which have <strong>status=Done</strong> and <strong>Date = Jun 2022</strong> in google sheet. Here I made a formula but not getting proper count value</p>
  <pre><code>=COUNTIFS(J1:J20,&quot;Done*&quot;,L8:L200,(ArrayFormula(month(L1:L20)),(MONTH(TODAY())-1)))
  </code></pre>
  <p><a href="https://i.stack.imgur.com/5zeEP.png" rel="nofollow noreferrer">Here is data screenshot</a></p>