For MIN, try this:

=SUMPRODUCT(MIN(($A$2:$A$100="a")*($B$2:$B$100)+($ A$2:$A$100<"a")*10^10))

(The additions to the formula cause non-matches to equate to 100,000,000,000
instead of zero)
--
Regards,
Ron


"CHRIS K" wrote:

The MAX works but the MIN returns 0
thanks
--
CHRISK


"Ron Coderre" wrote:

Here's one way:

In my example, I put letters down Col A and Values down Col B:
=SUMPRODUCT(MAX((A2:A100="a")*(B2:B100)))

You could also engage an autofilter and use the SUBTOTAL function to return
the maximum visible value: =SUBTOTAL(4,range)

Does that help?
--
Regards,
Ron