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
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.
Thank you for the good writeup. It in fact was a amusement account it. Look advanced to far added agreeable from you! However, how could we communicate?
You have brought up a very great details, appreciate it for the post.
Woh I enjoy your articles, saved to bookmarks! .
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..
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.
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!
Some really good posts on this site, thankyou for contribution.
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!
Really wonderful information can be found on web site. “You have to learn that if you start making sure you feel good, everything will be okay.” by Ruben Studdard.
Very well written information. It will be helpful to anybody who usess it, as well as yours truly :). Keep up the good work – looking forward to more posts.
I believe you have remarked some very interesting details , regards for the post.
Well I truly liked reading it. This information provided by you is very effective for good planning.
I’d like to find out more? I’d want to find out some additional information.
It’s enormous that you are getting thoughts from this
article as well as from our argument made here.
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!
It’s going to be end of mine day, except before ending I am reading this wonderful
article to improve my knowledge.
I truly appreciate this post. I have been looking everywhere for this! Thank goodness I found it on Bing. You have made my day! Thx again!
I’d have to examine with you here. Which is not something I usually do! I take pleasure in reading a publish that may make individuals think. Also, thanks for allowing me to remark!
I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post…
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!
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!