In fact, you can use this function to sum all the negative or positive values in the same range. Sum First, let’s take a brief look at SUMIF ().