» Summing the N Largest Values in a Range
CATEGORY - Excel Summing
VERSION - All Microsoft Excel Versions
Problem: 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:
- Writing Excel Macros with VBA, 2nd Edition
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- The Interpretation of Financial Statements
- Special Edition Using Microsoft Word 2002
- Seven Habits Of Highly Effective People
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
No comments have been submitted.
