Sorry, with that layout I cannot think on a formula simpler than:
=IF(B2="x",$B$1,0)+IF(D2="x",$D$1,0)+IF(F2="x",$F$ 1,0)
The fact that there are no continuos ranges to check prevents the usage of
the sumif or sumproduct in a simple way.

Miguel.

" wrote:

Not quite there, but close (the formula doesn't compute, but that's not
the layout).

The rows (say a1 to a8) would each have a person's name. The columns
(b2 to b7) would each show a dollar figure, e.g. 1000, 15000, 15001,
50000, 50001, 100000

If a person has 1000-15000 and 15001-50000, there would be an x in both
b2 and c2 and in both d2 and e2. The sum for minimum would be b1+d1. .
..
and the sum for maximum would be c1+e1. . .

I can't quite articulate your formulas, but I think it's a simple
change. Thanks.