title: Using the Excel SMALL function with filtering criteria AND ignoring zeros
body: <p>I have a list of prices for products that are variations (different size, color) of multiple parent product.  Some products (for reasons not important to this question) have a price of zero.</p>
  
  <p>I'm trying to write an excel formula that will return the lowest price for each parent product that is not zero</p>
  
  <p>I've got this far:</p>
  
  <p>=IF(SUMIFS(I:I,A:A,A3)=0,0,IF(AND(SUMIFS(I:I,A:A,A3)>0,MINIFS(I:I,A:A,A3)>0),MINIFS(I:I,A:A,A3),SMALL(IF(A:A=A3,I:I),2)))</p>
  
  <p>Where I:I is the price column and A:A is the parent reference column</p>
  
  <p>This works in all cases except where I have multiple variations of a parent product that have a zero value.</p>
  
  <p>I need variables in a SMALL or MINIF function that will:
  A. Only include the values for a single parent product in the calculation
  B. Ignore any zeros in the calculation of the lowest value</p>
  
  <p>Any help would be appreciated.</p>