title: Sumifs and Criteria - how to set "all" criteria?
body: <p>I have a table that is like this - starting in cell B1:</p>
  
  <pre><code>Type    Amount
  Bat     123
  Bat     321
  Bat     123
  Bat     354
  Car     154
  Car     156
  Car     15688
  Car     154
  </code></pre>
  
  <p>I have a SUMIF that will look at the Type, and return the Sum.  In "A1" I have a data validation with the choices "All", "Bat", and "Car".  The "Type" column is a named range ("Type"), same with "Amount" column.</p>
  
  <p>I have a formula <code>=sumifs(Amount,Type,$A$1,Amount,"&gt;0")</code>.  This works great, EXCEPT when I want to sum all of them (choosing "All" in A1).  </p>
  
  <p>How can I get the formula to, if I have "All" chosen in A1, to sum Bat + Car?  Does that make sense? In some cases I want to know Bat's sum, in others, Car's sum, and others I want the total total.</p>
  
  <p>edit: The amount being >0 is just an example, that Sumifs has a bunch of criteria, I just kept it short for example purposes.</p>