» Summing the N Largest Values in a Range
CATEGORY - Excel Summing
VERSION - All Microsoft Excel Versions
Summing the n largest values in List1 (column A) for each value of N in column B.
Solution:
Use the SUM, LARGE, ROW, and INDIRECT functions as shown in the following Array formula:
{=SUM(LARGE($A$2:$A$11,ROW(INDIRECT("1:"&B2))))}
Book Store:
Recommended Books:
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- The 11 Immutable Laws of Internet Branding
- The Financial Numbers Game: Detecting Creative Accounting Practices
- Analyzing Markets, Products, and Marketing Plans
No comments have been submitted.
