=IF(OR(COUNTIF(B3:AF3,a),COUNTIF(B3:AF3,l),COUNTIF(B3:AF3,h),COUNTIF(B3:AF3,k),COUNTIF(B3:AF3,h)),SUM(AH3:AK3),"")
我想问问看我的公式哪里不对,应该怎么改
åæ¯ååè¦å åå¼å·
=IF(OR(COUNTIF(B3:AF3,"a"),COUNTIF(B3:AF3,"I"),COUNTIF(B3:AF3,"h"),COUNTIF(B3:AF3,"k"),COUNTIF(B3:AF3,"h")),SUM(AH3:AK3),"")
=IF(OR(COUNTIF(B3:AF3,"a"),COUNTIF(B3:AF3,"I"),COUNTIF(B3:AF3,"h"),COUNTIF(B3:AF3,"k"),COUNTIF(B3:AF3,"h")),SUM(AH3:AK3),"")
温馨提示:答案为网友推荐,仅供参考
第1个回答 2019-11-14
COUNTIF(B3:AF3,"a")
是否包含某字母 ,字母是需要加引号的
是否包含某字母 ,字母是需要加引号的