title: How to use AND criteria in the SUMIF excel
body: <p>How to use AND criteria in the <code>SUMIF</code>, I used <code>=COUNTIF(I3:I12,AND("&gt;2","&lt;4"))</code> it shows the wrong result, and <code>=COUNTIF(I3:I12,{"&gt;2","&lt;4"})</code> is <code>OR</code> criteria, I don't want to use <code>COUNTIFS</code> for multi-array, then how to simply use the <code>AND</code> criteria?</p>