Hi

I am currently using the following to find the maximum value in a
range($G$120:$G$219), when the corresponding value in range ($H$120:$H$219)
is equal to a specific value.
=SUMPRODUCT(MAX(($H$120:$H$219=DF120)*($G$120:$G$2 19)))

My problem is that when i try to find the minimum by substuting the MAX()
for MIN() i always get a Zero.

Can anyone suggest how to return the lowest value that is not zero