close

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.

=sum(A1:A5)-max(A1:A5)
--
Gary's Studentquot;Tommyquot; wrote:

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

Gary

Thank you for the quick answer it works great.

Tommy

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄