作者:乔山办公网日期:
返回目录:excel表格制作
=COUNTIFS(A:A,"M",B:B,">5")
公式:
=SUMIFS(A:A,B:B,"某值",C:C,"*李四*",D:D,"<>*非机动车*")
公式来源1:
=SUMPRODUCT((B1:B7<150)*C1:C7)-SUMPRODUCT((B1:B7<=60)*C1:C7)
公式知道2:
=SUMIFS(C1:C7,B1:B7,"<=150",B1:B7,">60")
=SUMPRODUCT(ISNUMBER(FIND("a",A:A))*ISNUMBER(FIND("b",B:B))*(C:C>15)*D:D)
或知
=SUMPRODUCT(ISNUMBER(SEARCH("a",A:A))*ISNUMBER(SEARCH("b",B:B))*(C:C>15)*D:D)
或
=SUMIFS(D:D,A:A,"*a*",B:B,"*b*",C:C,">15")
第1个公式,区分英文字母大道小回写,后两个不区分大答小写。