The SUMIF function below sums values in the range B1B5 if the corresponding cells in the range A1A5 contain exactly circle. Cells in each range must be numbers or names arrays or references that contain numbers. How to Use SUMIF with Multiple Criteria in Excel The SUMIF function is designed to sum numbers based on one criterion.
The names of the vegetable names of suppliers and quantity are in column A column B and column C respectively.
But if you want to add numbers based on multiple criteria then you have the following options to use. Formula used for the SUMIFS Function in Excel SUMIFS sum_range criteria_range1 criteria1 criteria_range2 criteria2 criteria_range3 criteria3 criteria_range_n criteria_n Where. For example you would use SUMIFS to sum the number of retailers in the country who 1 reside in a single zip code and 2 whose profits exceed a specific dollar value. In our case the range a list of dates will be the same for both criteria.