Adding Column and removing highest number
 

I have a column with 5 numbers in it they range from 75 to 110 and they are
in no order, how do I add the 4 lowest numbers to get my result. It needs to
skip the highest number.

Adding Column and removing highest number
 

=sum(A1:A5)-max(A1:A5)
--
Gary's Student


"Tommy" wrote:

I have a column with 5 numbers in it they range from 75 to 110 and they are
in no order, how do I add the 4 lowest numbers to get my result. It needs to
skip the highest number.

Adding Column and removing highest number
 

Gary

Thank you for the quick answer it works great.

Tommy