View Single Post
  #5   Report Post  
Aladin Akyurek
 
Posts: n/a
Default

Just enter will do.

duane wrote:
for the five highest in row 1 (columns a:z)

=SUM(LARGE(A1:Z1,{1,2,3,4,5}))

entered with control+shift+enter