View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
robert morris robert morris is offline
external usenet poster
 
Posts: 222
Default What is worng with my formula?

Ron,

Beautiful!! Like a charm. Thanks so much. I'm trying but I have so much
to learn.

Thanks again!

Bob


"Ron Rosenfeld" wrote:

On Mon, 20 Aug 2007 09:52:08 -0700, robert morris
wrote:


I trying to determine the sum of nine numbers in Row / Column
I12,M12,Q12,u12,y12,ad12,ah12,al12,ap12, minus the two largest numbers of
the nine.

Thanks

Bob


=SUM(I12,M12,Q12,U12,Y12,AD12,AH12,AL12,AP12)-
SUM(LARGE((I12,M12,Q12,U12,Y12,AD12,AH12,AL12,AP12 ),{1,2}))


--ron