QuantumPion wrote...
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?
SUMIF only provides one criterion. Use the array formula
=SUM(LARGE(IF(ISNUMBER(List),IF(List<X,List)),ROW( INDIRECT("1:32"))))
|