![]() =SUMIF(A2:A12,"KTE",C2:C12), then press Enter key to add up all product quantity excluding KTE, ( A2:A12 is the range cells which contains the criteria, KTE is the criterion which excludes KTE, C2:C12 refers to the range you want to sum), see screenshot: ![]() (2.) Sum the quantity of all products except “KTE”: =SUMIF(A2:A12,E2,C2:C12) and press Enter key to get the result, ( A2:A12 is the range cells which contains the criteria, E2 is the criterion you want to sum the values based on, C2:C12 refers to the range you want to sum) see screenshot: (1.) Sum of quantity when the product is “KTE”: Sum_range: the range of cells to sum if the condition is metįor applying this SUMIF function, I will take the following data for example:.Criteria: the condition that you want to use.Range: the range of cells to be evaluated by your criteria.Sum cell values with multiple criteria in Excelįirst, I will give the SUMIF syntax to you for reference: ![]() Sum cell values with one criterion in Excel This article, I will describe how to sum with one or more criteria in Excel? In Excel, sum values based on one or more criteria is a common task for most of us, the SUMIF function can help us to quickly sum the values based on one condition and the SUMIFS function help us to sum values with multiple criteria. How to sumif with one or more criteria in Excel?
0 Comments
Leave a Reply. |