summing a set of numbers from a range of numbers

M

mike_c70

Hi!

First time poster. Great site BTW.

Anyhow, my problem is that I have to sum a set of numbers from a range.
For example, I'd like to sum the 5 highest numbers out from 20 numbers.
Does anyone know how to do this? I'm stumped. Thanks in advance!

Regards,
Mike
 
A

Alan Beban

mike_c70 < said:
Hi!

First time poster. Great site BTW.

Anyhow, my problem is that I have to sum a set of numbers from a range.
For example, I'd like to sum the 5 highest numbers out from 20 numbers.
Does anyone know how to do this? I'm stumped. Thanks in advance!

Regards,
Mike
Click to expand...
Array enter =SUM(LARGE(A1:A20,ROW(A1:A5)))

Alan Beban
 
Top