View Single Post
  #6   Report Post  
Ken Wright
 
Posts: n/a
Default

LOL - Cheers Tom, shows how much of the note I read :-)

Regards
Ken....................


"Tom Ogilvy" wrote in message
...
It was a trick Ken. He said 5 in the subject, but 12 in the body.

--
Regards,
Tom Ogilvy


"Ken Wright" wrote in message
...
What is 'best'

Assuming it is largest, then

=SUM(LARGE($A$1:$A$30,{1,2,3,4,5}))

or if smaller is better

=SUM(SMALL($A$1:$A$30,{1,2,3,4,5}))

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*------------

----
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*------------

----



"Tas" wrote in message
...
I am running a spreadsheet where I need to add up the 12 best numbers

from
a
sequence of 19, running across. Does anyone have any idea how I can do
this?

Thanks

Jon