If left blank, the cells under RANGE are used instead. SUM_RANGE (optional): These are the cells that will be added together.CRITERIA: This is the value or formula which Excel will compare against the cells under RANGE.RANGE: These are the cells Excel will inspect to know if it will add the corresponding values.Basically, SUMIFS gives you the ability to use two or more variables to filter your values.įormula: =SUMIF(range,criteria,) If you're going further to narrow down your filter to a particular product, you can use SUMIFS.įor example, you can use this function if you want to filter both supplier and product type. You can use the SUMIF command if you want to filter out the cells you want to add.įor example, if you only want to find the sum of inventory sold from a specific supplier, you can use SUMIF.
This formula adds one layer of complexity to the sum function.
