The most common Functions are SUM, AVERAGE, COUNT, MIN, and MAX. If an individual wants to find the average, minimum, or maximum of their data, they can use the AVERAGE , MIN , and MAX Functions .

Even with the optional sum_range argument, the SUMIF function isn't difficult to use, but the easiest way to see it in action is by adding a range of values based on a criterion in that range.

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