=COUNTIFS(STATUS,"EM",SIZE,22,CODE,"R1")+
COUNTIFS(STATUS,"OM",SIZE,"22",CODE,"R1")+
COUNTIFS(STATUS,"TM",SIZE,"22",CODE,"R1")+
COUNTIFS(STATUS,"XM",SIZE,"22",CODE,"R1")+
COUNTIFS(STATUS,"EM",SIZE,22,CODE,"32")+
COUNTIFS(STATUS,"OM",SIZE,"22",CODE,"32")+
COUNTIFS(STATUS,"TM",SIZE,"22",CODE,"32")+
COUNTIFS(STATUS,"XM",SIZE,"22",CODE,"32")
請問可以簡化以上公式嗎?
EXCEL 簡化公式問題
2014-09-20 1:17 am
回答 (1)
2014-09-24 2:31 am
✔ 最佳答案
你可以用以下formula代替:=SUMPRODUCT(((STATUS="EM")+(STATUS="OM")+(STATUS="TM")+(STATUS="XM"))*((SIZE=22)+(SIZE="22"))*((CODE="R1")+(CODE="32")+(CODE=32)))
收錄日期: 2021-04-15 16:37:18
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20140919000051KK00062