daaserve.blogg.se

There is another way to apply SUMIF criteria. SUMIF with Multiple Criteria – Example #2 We can cross-check the sum separately as well to match the count with the SUMIF function. To add another criterion in this syntax, we will add the quantity sold by Jenny with the help of the “+” sign as shown below.Īs we can see in the above screenshot, the quantity sold by Ben and Jenny together is coming as 35607. We will get the sum of Ben’s sold quantity as 24383. Now search and select the SUMIF function from the search list.įor calculating the sum of quantities sold by Ben, select the Owner’s name as in range, criteria as BEN, and sum range as complete Quantity Sold column C and press enter. This will enable all the inbuilt functions of excel. Here we will calculate the total quantities sold by Ben and Jenny together.įor this, go to the cell where we need to see the output and type the “=” (Equal) sign. Now we will apply multiple criteria in the simple SUMIF function.Ĭonsidering the multiple criteria for calculating the sum of the above-shown data, we need to apply SUMIF so that we can get the sum of more than 1 owner’s quantity sold data. As we can see below, the data which we have has the owner’s names and quantity sold by them for the respective product class.

We got the sales data for some product class. You can download this SUMIF Function with Multiple Criteria Excel Template here – SUMIF Function with Multiple Criteria Excel Template SUMIF with Multiple Criteria – Example #1