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
|