This is almost comical!
I STILL put the dollar signs in the wrong place.

This is the latest in a series of final formulas (sheesh!)
=SUMIF($B$5:$D$5,"<"&MIN($B$5:$D$5),B2:D2)

***********
Regards,
Ron

XL2002, WinXP


"Pierre" wrote:

Am totaling scores for each judge for a contest, and each entry is
judged in 3 categories. Need to sum the remaining scores, by tossing
out that judges scores.


We need to disregard all numbers from Judge 2 in the total because they
have the lowest total score.

Judge 1 Judge 2 Judge 3
Red 6 7 5
Blue 9 2 6
Green 7 1 4
TOTAL 22 10 15

Need to remove all of Judge 2's scores from the individual totals of
red, blue and green
because Judge 2 had the lowest total score. (There are actually 6
judges total.)

Answers: Red should be 11, Blue should be 15, and Green should be 11.

TIA for any thoughts.
Pierre