» 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:
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Excel Charts
- Microsoft Access 2002 for Dummies
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- A Mathematician Plays the Stock Market
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
