title: How to sum values based on same date and name
body: <p>I am trying to sum up Excel cells if they have the same date and name. In my case the column P is what I want to sum up. Column B is the date and column A is the name. Below is my attempt but it's not working. This formula works if I have ">=" but I want it calculate for specific day</p>
  
  <pre><code>=SUMIFS($P$4:$P$1000,$B$4:$B$1000,"&gt;="&amp;Q2,$A$4:$A$1000, "="&amp;R2)
  </code></pre>