Question

Excel如何统计某列符合条件的单元格的总值

比如我想统计Walnut规格的Praco的总数量，请问应该怎么编公式呢？

Answer 1

=sumifs(C:C,B:B,"walnut",A:A,"Praco")

名字可以换成单元格引用

=========================
=sum(sumifs(C:C,B:B,{"Walnut","Black"},A:A,"Praco"))

Answer 2

=sumproduct(A2:A25="Praco")*(B2:B25="Walnut")*(C2:C25)

Answer 3

=SUMIFS(C:C,A:A,"Walnut",B:B,"Praco")

追问

非常感谢，另外如果我要统计Walnut和Black规格的Praco数量呢，条件应该怎么写啊？

追答

=SUMIFS(C:C,A:A,"Walnut",B:B,"Praco")+SUMIFS(C:C,A:A,"Black",B:B,"Praco")