hello there,
xxx 0
yyy 45
yyy 70
xxx 5
xxx 0

70 --=SUMPRODUCT(MAX((A2:A6=A3)*(B2:B6)))
the above formula is the MAX for yyy, how can i edit the above formula to
get the MIN value from the list but not zero if column A is yyy. im expecting
an answer of 45