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.

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