Sum Largest 1:n values. Using a specidied cell to define n

Hi there,

 

I am trying to sum the largest n values in a range and I would like to specify the n by using a cell.

 

What I am trying to achieve is something like this;

 

=SUMPRODUCT(LARGE(rng,ROW(INDIRECT("1:20"))))
 
but instead of taking the sum of the 20 largest values I would like to sum the number of values given within a cell such as $A$1
 
I have tried to find solutions but haven't yet been quite successful.
 
Any help is greatly appreciated,
 
Thanks in advance,

Jamie

 

By: Jamie

22 thoughts on “Sum Largest 1:n values. Using a specidied cell to define n

  1. www.brilliantlighttherapy.co.uk

    I would like to thnkx for the efforts you’ve put in writing this blog. I am hoping the same high-grade web site post from you in the upcoming also. In fact your creative writing abilities has encouraged me to get my own website now. Really the blogging is spreading its wings rapidly. Your write up is a great example of it.

  2. Comprar Phentermine HCL en línea

    Good – I should certainly pronounce, impressed with your web site. I had no trouble navigating through all tabs and related information ended up being truly easy to do to access. I recently found what I hoped for before you know it in the least. Quite unusual. Is likely to appreciate it for those who add forums or anything, website theme . a tones way for your customer to communicate. Excellent task..

  3. Buy Melanotan 2 UK

    Hi, Neat post. There is a problem with your web site in internet explorer, would test this… IE still is the market leader and a huge portion of people will miss your wonderful writing due to this problem.

  4. steroide kaufen

    I’d have to examine with you here. Which is not one thing I usually do! I take pleasure in reading a post that may make folks think. Additionally, thanks for permitting me to comment!

  5. sibutramin kaufen

    Hi would you mind letting me know which web host you’re working with? I’ve loaded your blog in 3 completely different browsers and I must say this blog loads a lot quicker then most. Can you recommend a good web hosting provider at a honest price? Thanks, I appreciate it!

  6. Acquistare Methandiitone compresse

    Please let me know if you’re looking for a writer for your weblog. You have some really great articles and I feel I would be a good asset. If you ever want to take some of the load off, I’d really like to write some content for your blog in exchange for a link back to mine. Please blast me an e-mail if interested. Thank you!

  7. Buy Marble Handicraft

    Please let me know if you’re looking for a author for your blog. You have some really good posts and I believe I would be a good asset. If you ever want to take some of the load off, I’d absolutely love to write some articles for your blog in exchange for a link back to mine. Please blast me an email if interested. Thanks!

  8. Sunny Weare

    My wife and i have been so fulfilled when Louis could do his reports using the precious recommendations he discovered out of the web page. It is now and again perplexing to just be making a gift of tricks which often the rest may have been selling. So we realize we need the blog owner to appreciate for that. These illustrations you have made, the straightforward site menu, the relationships you will assist to foster – it’s most wonderful, and it is letting our son and us reason why this theme is interesting, and that’s seriously indispensable. Thank you for everything!

Comments are closed.