,First, I will give the SUMIF syntax to you for reference:,,,SUMIF(range, criteria, [sum_range]),,,,Range,: the range of cells to be evaluated by your criteria;,,Criteria,: the condition that you want to use;,,Sum_range,: the range of cells to sum if the condition is met,,For applying this SUMIF function, I will take the following data for example:,,,,,,(1.) Sum of quantity when the product is “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:,,,,,,(2.) Sum the quantity of all products except “KTE”:,,,,=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:,,,,,,(3.) Sum the quantity greater than 250:,,,,=SUMIF(C2:C12,">250"),, and press ,Enter, key to get the result, (,C2:C12, refers to the range you want to sum,>250, is the criterion you need, you also can change it to less than 250 as you need), see screenshot:,,,,,,(4.) Use SUMIF+SUMIF+… function with multiple OR criteria, sum the quantity of KTE and KTW:,,,,=SUMIF(A2:A12,"KTE",C2:C12) + SUMIF(A2:A12,"KTW",C2:C12),( ,A2:A12, is the range cells which contains the criteria,KTE, and ,KTW, are tHij wil je de som van de waarden van de criteria op basis refers, C2:C12, aan de. Wil je som), en dan de pers, enter, de sleutel tot de - -,,,,,,,, som - waarden met meerdere criteria in Excel,,, de SUMIFS syntax als volgt:,,, SUMIFS (sum_range en criteria_range1, criteria1, [criteria_range2, criteria2],...),,,, Sum_range: a, het bereik van de cellen te som;,, Criteria_range1: de eerste reeks, die de criteria criteria1;,,,: de eerste voorwaarde dat moet worden voldaan; criteria_range2 criteria2,,,,,,, dit zijn andere ranges... En de criteria in verband met.,,, (1.) sum de hoeveelheid van het product is waar KTE en de naam is James:,,, toets van deze formula:, =SUMIFS (C2:C12, A2:A12, "KTE, B2:B12", "James"), en C2:C12 (,, is het bereik van 10 A2:A1 (bedrag,2, ,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:,,,,,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.,,,(2.) Sum the quantity where the product is KTE and name is not James,,,Type 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), then press ,Enter, key to get the result, see screenshot:,,,,,Another array formula also can finish this operation: =,SUM((A2:A12="kte")*(B2:B12<>"James")*C2:C12),, but you must press ,Ctrl + Shift + Enter, keys after typing this formula.,,,(3.) Sum the quantity where the product is KTE and quantity greater than 150,,,You can use this SUMIFS formula: ,=SUMIFS(C2:C12,A2:A12,"KTE",C2:C12,">150"),(,C2:C12, is the range of cells need to sum,A2:A12, ,KTE, are the first criteria range and criterionj,C2:C12,,>150,, are the second criteria range and criterion), and then tap the ,Enter, key to return the result.,,,,,You can also us the SUM array formula to get the result you want,=SUM((A2:A12="kte")*(C2:C12>150)*C2:C12), please remember to press ,Ctrl + Shift + Enter, keys after typing this formula.,,,(4.) Sum the quantity wDit aantal tussen 100 en 200,,, en tussen de waarde van de nummer twee, het gebruik van deze formule:, = sumifs (C2:C12, C2:C12 "> 100", C2:C12, "< 200), (C2:C12, GSM 's, is het nodig en, C2:C12, > 100, is de eerste een norm van de werkingssfeer en normen, C2:C12, < 200, is de tweede reeks criteria en normen), en dan enter, kunnen de volgende conclusies worden getrokken:,,,,,, natuurlijk en - formule kan je helpen, = totaal ((C2:C12 > 100) * (C2:C12 < 200) *:C2 C12), weet je nog van de CTRL + shift + enter, sleutels samen tot een goed resultaat bereiken.,,,,