View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default need to make a macro to sum the highest 3 values from 10 colun

Actually, you can enter it normally - it doesn't need to be entered as an
array formula.

--
Regards,
Tom Ogilvy


"Duke Carey" wrote:

You can use an array formula to do it, without resorting to a macro:

=SUM(LARGE(A1:J1000,{1,2,3}))

enter it by pressing Shift-Ctrl-Enter


"Antonio" wrote:

I need to make a macro thta select the 3 highest values from 10 coluns and
then sum up these values...