[算表] EXCEL函數替代
軟體:EXCEL
版本:2003
=SUMPRODUCT( --(D2:D1000="A01:苗"), --(Sheet1!A2:Sheet1!A1000="AAA"))
=SUMPRODUCT( --(D2:D1000="A01:苗"), --(Sheet1!A2:Sheet1!A1000="BBB"))
=SUMPRODUCT( --(D2:D1000="A01:苗"), --(Sheet1!A2:Sheet1!A1000="CCC"))
=SUMPRODUCT( --(D2:D1000="A01:苗"), --(Sheet1!A2:Sheet1!A1000="CCC"))
=SUMPRODUCT( --(D2:D1000="A01:苗"), --(Sheet1!A2:Sheet1!A1000="EEE"))
=SUMPRODUCT( --(D2:D1000="A01:苗"), --(Sheet1!A2:Sheet1!A1000="FFF"))
=SUMPRODUCT( --(D2:D1000="A01:苗"), --(Sheet1!A2:Sheet1!A1000="GGG"))
=SUMPRODUCT( --(D2:D1000="A01:苗"), --(Sheet1!A2:Sheet1!A1000="HHH"))
=SUMPRODUCT( --(D2:D1000="A01:苗"), --(Sheet1!A2:Sheet1!A1000="III"))
因為我D2:D1000要分別抓出不同的文字來做判別
可能接下來就
=SUMPRODUCT( --(D2:D1000="A02:高"), --(Sheet1!A2:Sheet1!A1000="AAA"))
但是後面的Sheet1!A2:Sheet1!A1000固定不變
也就是我必須將上面9行函數的"A01:苗"都取代成A02:高
想請教一下有沒有方法能簡單的解決此問題 謝謝
--
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 114.38.21.185
Office 近期熱門文章
PTT數位生活區 即時熱門文章
