請問Excel的高手 表格A1到A5輸入(上班)(加班)(補班)代表1 表格A6到A7輸入(休假)(特休)(生理假)代表-1 要怎麼讓A8表格自動加總 謝謝解答?
回答 (2)
2017-08-14 9:10 am
✔ 最佳答案
.A8:
=SUMPRODUCT((A1:A5={"上班","加班","補班"})*1)-SUMPRODUCT((A6:A7={"休假","特休","生理假"})*1)
2017-08-15 10:59 am
=SUMPRODUCT(($A$1:$A$7={"上班","加班","補班","休假","特休","生理假"})*{1,1,1,-1,-1,-1})
收錄日期: 2021-04-28 17:41:50
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20170813222646AAc6sBR