(2.) Sum the quantity where the product is KTE and name is not James Here also has an array formula can help you: =SUM((A2:A12="kte")*(B2:B12="James")*C2:C12), and you need to press Ctrl + Shift + Enter keys together after typing the formula. Please enter this formula: =SUMIFS(C2:C12,A2:A12,"KTE",B2:B12,"James"),( C2:C12 is the range of cells need to sum, A2:A12, KTE are the first criteria range and criterion, B2:B12, James, are the second criteria range and criterion), and then press Enter key, see screenshot: (1.) Sum the quantity where the product is KTE and name is James: : these are additional ranges and criteria associated with them.
![sumif excel sumif excel](http://4.bp.blogspot.com/-EZj_eybRBu8/UUkjDZKmRPI/AAAAAAAAAM4/SlVRf9oSmjY/s1600/Penggunaan+SUMIFS.png)
SUMIF EXCEL HOW TO
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?