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