excel用什么函数求一列数据中满足条件的对应数据的和

Question

比如求图中款号为11515154480颜色为浅花灰和土耳其蓝，11215103205颜色为墨水蓝，11215157111颜色为浅花灰 这三款S码数量的和怎么用函数表达

Answer 1

用公式：
=SUMIFS(C:C,A:A,"11515154480",B:B,"浅花灰")+SUMIFS(C:C,A:A,"11515154480",B:B,"土耳其蓝")+SUMIFS(C:C,A:A,"11215103205",B:B,"墨水蓝")+SUMIFS(C:C,A:A,"11215157111",B:B,"浅花灰")

如果A列数据为数值类型，把引用去掉。

Answer 2

输入以下公式
=SUMIFS(C:C,A:A,"11515154480",B:B,"浅花灰")+SUMIFS(C:C,A:A,"11515154480",B:B,"土耳其蓝")+SUMIFS(C:C,A:A,"11215103205",B:B,"墨水蓝")+SUMIFS(C:C,A:A,"11215157111",B:B,"浅花灰")追问

只能采纳一个，不好意思，谢谢。

Answer 3

SUMIFS函数追问

我是函数小白，怎么写呀