» 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:
- Accounting the Easy Way
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Microsoft Word Version 2002 Inside Out
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Microsoft Windows XP Registry Guide
- Investments + S&P Card + Powerweb + StockTrak discount coupon
No comments have been submitted.
