如题所述
可以用countifs()或sumifs()等多条件统计函数来统计,前者为多条件计数,后者多条件求和。
如统计型号为B01,颜色为白色的个数和总和,分别为:
=COUNTIFS(B2:B21,"B01",C2:C21,"白")
=SUMIFS(D2:D21,B2:B21,"B01",C2:C21,"白")