title: How do I sum only positive numbers from another column that must match certain criteria in my first column?
body: <p>I have about 500 item #s in Column A that represent all of the different items we put in or out of production during the week. </p>
  
  <p>In Column F I have the total lbs of that item with positive or negative numbers reflecting in to production and out of production respectively. </p>
  
  <p>I already have the following formula setup to tell me what the total loss/gain is:</p>
  
  <pre><code>=SUMPRODUCT(--(ISNUMBER(SEARCH({"0883","0884","0885"},A6:A280)))*F6:F280)
  </code></pre>
  
  <p>I would like to then sum only the positive numbers so that I can get a shrink/gain percentage based on the product we put into the room. This is where I am stuck.</p>