Summing only the positive or negative values in the same range of values only sounds difficult. Fortunately, the SUMIF() function can handle both.

Naturally, using an array makes most sense if the states or input values we handle are integers in consecutive order. In other cases, we might need a different solution.

Description: Dimensions: d The Sum of Different Powers function is unimodal. It is shown here in its two-dimensional form. Input Domain: The function is usually evaluated on the hypercube x i ∈ [-1, 1 ...