EXCEL 簡化公式問題

2014-09-20 1:17 am

=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")

請問可以簡化以上公式嗎?

回答 (1)

MintyB

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)))

👍 0 👎 0

收錄日期: 2021-04-15 16:37:18
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20140919000051KK00062

檢視 Wayback Machine 備份