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

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

Replace A1 and A10 with your own range

"indyjohn" wrote:

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