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
全站熱搜
留言列表
