| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
That fails under the OP's "not #N/A" criterion.
In article , "Bob Phillips" wrote: Here is an example that sums the top 32 that are not equal to 35 =SUMPRODUCT(--(LARGE(IF(A1:A40<35,A1:A40),ROW(INDIRECT("1:32")) ))) it is an array formula, so commit with Ctrl-Shift-Enter -- HTH Bob Phillips "QuantumPion" wrote in message ... 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? |
| Reply |
| 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) | |||
Hybrid Mode
