As you have most probably noticed, 45.26 is the sum of 23.53 and 23.03, which
is what SUMPRODUCT does, the sum of the multiplication of the items of an
array.

What I propose is to use an array formula (that you validate with Alt-Ctrl-
Enter):
=MIN(IF(A1:A12="b",B1:B12,9E+99))

A set of curly brackets appears around the formula once you have validated it.


Replace A1:A12 and B1:B2 by your own ranges.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200707/1