Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to sum highest ranking values meeting criteria within a limit?
I need a function that will sum the n largest values in an array, where the values are less then x and are not #N/A, meet a criteria in a seperate array, and where the total of the sum is less then or equal to y. How can I do this? Thanks. :) For example, here is my data: Code: -------------------- name type value alpha g 1 bravo 5 charlie g 2 delta g #N/A echo 3 foxtrot g 7 -------------------- I want a function that will find the sum of the largest two values that are "g" that add to 8 or less. So the output would look like: Code: -------------------- name value alpha 1 charlie 2 sum: 3 -------------------- -- QuantumPion ------------------------------------------------------------------------ QuantumPion's Profile: http://www.excelforum.com/member.php...o&userid=23991 View this thread: http://www.excelforum.com/showthread...hreadid=376117 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Values that meet another cells criteria | Excel Worksheet Functions | |||
Sum the values of one column, only if they meet certain criteria . | Excel Worksheet Functions | |||
COUNTIF MEETING TWO CRITERIA eg>5 AND <10.1 | Excel Worksheet Functions | |||
ranking an row of values | Excel Worksheet Functions | |||
Need formula to check values of data in several cells as criteria | Excel Worksheet Functions |