title: Excel Ranking with multiple conditions
body: <p><img src="https://i.stack.imgur.com/mDdMf.png" alt="enter image description here"><a href="https://www.dropbox.com/s/05f82d5piw0pfd2/Book1.xls" rel="nofollow noreferrer">https://www.dropbox.com/s/05f82d5piw0pfd2/Book1.xls</a></p>
  
  <p>Hello everyone, can anyone show me how to deal with above ranking issue that I try to solve.</p>
  
  <p>What I like to have is only ranking Names Occurrence when Month = February and Item = Item 1, also, ignore all item 2 with what even names and months between it. </p>
  
  <p>Also, since I have more records, if possible could you please tell me how to apply ranking to whole columns.</p>
  
  <p>Currently I try to use</p>
  
  <pre><code> =SUMPRODUCT(--(A:A=A2),--(C:C=C2),--(B:B=B2)--(D2=D:D))`
  </code></pre>
  
  <p>but looks like it doesn't work that way.</p>