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"))))