**Excel SUMIFS and SUMIF with multiple criteria – formula …**
https://www.ablebits.com/office-addins-blog/2014/11/12/excel-sumifs-sumif-multiple-criteria/

Nov 12, 2014 · This approach works with numbers as well as with text values. For instance, if instead of the suppliers' names in column C, you had supplier IDs like 1, 2, 3 etc., then your SUMIF formula would look similar to this: =SUM(SUMIF(C2:C9, {1,2,3} , D2:D9)) Unlike text values, numbers needn't be enclosed in double quotes in array arguments. Example 3.

**DA:** 79 **PA:** 11 **MOZ Rank:** 33