The SUMIF function is used widely amongst spreadsheet users as it is a simple Excel function. It allows you to Sum the values in a range that meet a criteria that you specify.

So if you want to Sum a range of sales values that are above $3,000 then this is the best Excel function to use, as I explain below.

**Helpful Resource:**