How to sort the 6 highest numbers

[Guest]

Hi I have a spreadsheet where I need to choose the 6 highest cell values from a range of 12 and then sum the result. I cannot seem to find a suitable formula to do this except a macro to sort cut and paste (which seems a bit messy as I have 500 rows to compute. Can anyone help!!

Thanks in anticipation

 

[Frank Kabel]

Hi
have a look at the LARGE function

 

[JMay]

try:
=SUMPRODUCT(LARGE(D3200,{1,2,3,4,5,6}))
and there's no need to sort your range.
HTH

Hi I have a spreadsheet where I need to choose the 6 highest cell values

from a range of 12 and then sum the result. I cannot seem to find a suitable
formula to do this except a macro to sort cut and paste (which seems a bit
messy as I have 500 rows to compute. Can anyone help!!!

 

[Guest]

Frank...Does the job perfectly...Thank