我希望添加一个列值，如果它匹配多个标准，
我想获得C列C的总和，如果列-E范围在B列中，D = a1
https://docs.google.com/spreadsheets/d/17RojhKkLbkkJ7o5dZjCrdeYAy48fK1O0yufbSg0GjlQ/edit?usp=sharing
i tried with使用以下公式 = sumproduct（e4：e13，b4：b4：b18，c4：c18））但无法添加更多标准
i am looking to add a column values if it matches multiple criteria
i like to get sum of Column-c if Column-E range is in Column-B and Column-D = A1
https://docs.google.com/spreadsheets/d/17RojhKkLbkkJ7o5dZjCrdeYAy48fK1O0yufbSg0GjlQ/edit?usp=sharing
i tried with single criteria using below formulae =SUMPRODUCT(sumif(E4:E13,B4:B18,C4:C18)) but not able to add one more criteria
发布评论
评论（1）
如果您有多个标准，则应使用
sumifs或做：
if you have multiple criteria you should go with
SUMIFSor do: