Droping the lowest value

K

Kb

Hi I need a formuls to drop the lowest value and add the rest as in.....

Cell (AF4) Cell (AH4) Cell (AJ4) Cell (AL4) Cell (AN4)
100 90 80 70
170

What I want the formula to do is drop the lowest number (70) and then add
the rest together (100+90+80) and put the total in Cell (AN4)


Thanks in advance..

Keith
 
K

Kb

Kb said:
Hi I need a formuls to drop the lowest value and add the rest as in.....

Cell (AF4) Cell (AH4) Cell (AJ4) Cell (AL4) Cell (AN4)
100 90 80 70 170

What I want the formula to do is drop the lowest number (70) and then add
the rest together (100+90+80) and put the total in Cell (AN4)


Thanks in advance..

Keith
Click to expand...
Thanks, GOOGLE is your friend LOL

=SUM(AF4:AL4)-MIN(AF4:AL4)

Thanks Agian

Keith
 
B

Bondi

Hi

One way would be:

Sum(AF4,AH4,AJ4,AL4,AN4)-Min(AF4,AH4,AJ4,AL4,AN4)

Regards,
Bondi
 
Top