That did it, Myrna! Thank you so much! :)

"Myrna Larson" wrote:

It doesn't work for me.

With this formula the first part, B1:B6="Bob", returns TRUE or FALSE, but when
you use TRUE/FALSE in multiplication, FALSE is translated to 0 and TRUE to 1.
Therefore if C1:C6 contains only positive numbers, the minimum will always be
0.

This ARRAY formula (entered with CTRL+SHIFT+ENTER) WILL work:

=MIN(IF(B1:B6="Bob",C1:C6))

The reason is, you are not multiplying C1:C6 by TRUE or FALSE (1 or 0), but
rather taking the minimum of a list that contains either a value from C1:C6 or
the Boolean value FALSE. MIN ignores TRUE/FALSE. Multiplication doesn't.


On Mon, 19 Sep 2005 21:00:16 +0100, "Sandy Mann"
wrote:

Eric's formula works for me with MIN in it. There is however a surplus set
of brackets:

=SUMPRODUCT(MIN((B1:B6="Bob")*(C1:C6)))