=COUNTIFS(D:D,"*成都*",H:H,"刘三")即可你的公式改一下=COUNTIFS(造价!Q3:Q942,"刘三",造价!H3:H942,"*成都*")
按条件求和函数，sumif函数办公实例讲解！
