Sumif Formula In Excel Example. In such a scenario we can use the sumif function to find out the sum of the amount related to a particular vegetable from a specific supplier. For example to sum the cells that meet the following criteria.
Criteria the condition that must be met. Here i want the sum of sales value for the apparel column containing pant text. The names of the vegetable names of suppliers and quantity are in column a column b and column c respectively.
Criteria the condition that must be met.
The sumif function has the following syntax. As you see the sumif function has 3 arguments first 2 are required and the 3 rd one is optional. Remember when using the sumifs function the first argument is the range to sum followed by two or more range criteria pairs. For example to sum the cells that meet the following criteria.
