title: google sheets sumifs with range or named range as criteria
body: <p>I'm trying to sum all the values for the items defined in the <code>NameRange</code>, using <code>SUMIF</code>: <code>=SUMIF(E1:E10,D1:D10,NamedRange)</code></p>
  
  <p>So I would expect to have <code>1+3+7+8+10 =</code><strong><code>29</code></strong>, basically all in yellow.</p>
  
  <p>But my result is 0. What do I do wrong?</p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1S9wjWC2QcLc5cScLw_D26NP3vhIl5iKYYkyYyYIPNSE/edit#gid=0" rel="nofollow noreferrer">Here</a> is an editable example</p>
  
  <p><a href="https://i.stack.imgur.com/Xu31g.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Xu31g.png" alt="enter image description here"></a></p>