Thread: Adding the max 8 values in a list
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Adding the max 8 values in a list
=SUM(LARGE(A1:M1,{1,2,3,4,5,6,7,8}))


--
Gary''s Student - gsnu200777
Reply With QuoteReply With Quote