Thread: How can I sum a list of numbers EXCEPT the lowest value in Excel?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
  
Posts: 3,572
Default How can I sum a list of numbers EXCEPT the lowest value in Excel?
Try this:

=SUM(A1:A10,-MIN(A1:A10))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"indyjohn" wrote in message
...
I have a list of test scores that I want to sum, but I want to drop the
lowest value. How can I do that in Excel?


Reply With QuoteReply With Quote