Dueling Excel 133

Add Nth Largest Values With Three Criteria Dynamic Formulas

DESCRIPTION

See Mr Excel and excelisfun use two methods to sum the three biggest values that match three criteria (3 conditions)
1. Advanced Filter and LARGE and MAX value
2. SUM and LARGE functions with three nested IF functions and an array constant, array formula
3. SUM and LARGE and ROW and INDIRECT functions with three nested IF functions to add nth top vales, where n is a variable from the cell so that formula is dynamic and can top 2, top 3, or any nth top values. Array formula requires Ctrl + Shift + Enter.
4. SUMPRODUCT and LARGE and ROW and INDIRECT functions with three Boolean conditional array multiplcations to add nth top vales, where n is a variable from the cell so that formula is dynamic and can top 2, top 3, or any nth top values. Array formula requires Ctrl + Shift + Enter.
Add top 2, add top 3, add top 2 values, add top 3 values, add top three numbers, sum top three values, sum top three numbers, add top three numbers, add top 3 numbers.

WORKBOOKS




Be the first to comment

Leave a Reply