| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
need function to sum top ranking items in list
How can I make a function that will sum the largest 32 items in a column which meet specific criteria? For example, the largest 32 values that are smaller then X, or are not #N/A? I think I want to use SUMIF, but how can I format the criteria to evaluate a function for each cell? -- QuantumPion ------------------------------------------------------------------------ QuantumPion's Profile: http://www.excelforum.com/member.php...o&userid=23991 View this thread: http://www.excelforum.com/showthread...hreadid=376101 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I filter a list using a greater than todays date function? | Excel Worksheet Functions | |||
| clock | Excel Worksheet Functions | |||
| i need a function to find the highest value in a list | Excel Worksheet Functions | |||
| Items in a List | Excel Discussion (Misc queries) | |||
| If function using a list of criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
