title: Excel Sum Formula With Multiple Criteria
body: <p>So I'm having a problem with summing some data in a range with multiple criteria. Take the data below as an example:
  <a href="https://i.stack.imgur.com/yW2du.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yW2du.png" alt="enter image description here" /></a></p>
  <p>I would like to sum all numbers where: Name = Bob AND the top row is equal to 02/01/20.</p>
  <p>The current formula i have is with a SUMPRODUCT, but i'm not sure if it's the solution</p>
  <pre><code>=SUMPRODUCT((Names=&quot;Bob&quot;)*(Dates=&quot;02/01/2020&quot;)*Values)
  </code></pre>
  <p>Where Names is a named range for my names, Dates is a named range for my dates and Values is a named range for all my values in the table. However, the formula keeps resulting in &quot;#VALUE!&quot;.</p>
  <p>Any ideas anyone?</p>