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.

The SUMIF function is pretty versatile — you can use a number, text, or even a date as the criterion. Sum_range: The sum_range is optional, and is what gives this function so much power.

To use SUMIF, place your cursor where you would like the sum calculated for a particular type of audit. In the invoice in the screenshot below, I have placed my cursor in cell C46 to calculate a sum ...

Fortunately, the SUMIF () function can handle both. Summing only the negative values in a range of values sounds like a difficult task, but there’s a simple solution-use SUMIF ().