summing a set of numbers from a range of numbers

  • Thread starter Thread starter mike_c70
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum last 3 numbers greater that 0 in a range 0
Excel How to add numbers in same cell? 2
Sum number range ignoring numbers formatted as text 0
Sumif number is greater than a number but less than another number 2
Summing a variable number of rows 3
Sum Formula with variable range 2
Help Writing a SUM Formula 5
Summing Text & Numbers 2

Back
Top