title: EXCEL COUNTIF with 2 AND Parameters
body: <p>I need the syntax for a CountIf where 2 parmeters must be fullfild.</p>
  <p>Count the Number of Persons who has a Partner AND Children</p>
  <p>Here's an example:</p>
  <p><a href="https://i.stack.imgur.com/5t1Cr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5t1Cr.png" alt="enter image description here" /></a></p>
  <p>I tried this to solf the problem</p>
  <p><code>=COUNTIF(3:3;&quot;Partner&quot;) </code></p>
  <p><code>=COUNTIF(2:2;&quot;Children&quot;) </code></p>
  <p>But this does works</p>
  <p><code>=COUNTIF(AND((3:3;&quot;Partner&quot;);(2:2;&quot;Children&quot;)))</code></p>