title: If three columns exactly match then return value by using countifs condition in excel
body: <p>Currently I'm working on countifs condition where all 3 columns matches then it will return total count. I've attached screenshot for reference.</p>
  <p>As per image you can see that in column D &quot;Total VM&quot; formula used, I'm counting total VM on basis of 3 columns &quot;A&quot;,&quot;B&quot;,&quot;C&quot; matches with column &quot;O&quot;,&quot;P&quot;,&quot;Q&quot;.</p>
  <p>Formula used</p>
  <pre><code>=index(countifs(N:N,&quot;*WinOs*&quot;,match(1,(A2=Q:Q)*(B2=O:O)*(C2=P:P),0),1))
  </code></pre>
  <p>Please guide me to correct the formula.</p>
  <p><a href="https://i.stack.imgur.com/xP7kl.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xP7kl.png" alt="enter image description here" /></a></p>