View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Duke Carey Duke Carey is offline
external usenet poster
 
Posts: 1,081
Default need to make a macro to sum the highest 3 values from 10 coluns

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...