View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ken Guest Ken Guest is offline
external usenet poster
 
Posts: 2
Default Adding the max 8 values in a list

THANKS----Seems to be working exactly as I want it.

"Gary''s Student" wrote:

=SUM(LARGE(A1:M1,{1,2,3,4,5,6,7,8}))


--
Gary''s Student - gsnu200777