In the SUMIFS function, we will add the Sum_range first, which is the data in the Number of Sales columns, which specify how many items were purchased by each customer.. Type the cell C3:C10 or ...

The SUMIF function provides a quick and simple way to create a sum based on a specific criterion, such as the type of audit. Because you only have one criterion (type of audit), SUMIF is sufficient.

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.