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
....

If it has to be an array formula, no point using SUMPRODUCT rather than
SUM. Also, LARGE only returns numbers, so no need for the '--' or the
parentheses enclosing the LARGE call.

=SUM(LARGE(IF(A1:A40<35,A1:A40),ROW(INDIRECT("1:3 2"))))